Bilingual report

[iccsi]

I have a report needs support 2 languages.
I can have 2 reports or have a table to store 2 languages and retrieve
the text on print.

I would like to have a table store data for future maintainence just
want to know will it affect performance of the rport if it reads text
from tables.


Your information is great appreciated,

 

[NTC]

I wouldn't think it would make much difference; in tables would be easier
should you be going to more than 2 languages in the future however that's for
sure....

 

[iccsi]

I wouldn't think it would make much difference;  in tables would be easier
should you be going to more than 2 languages in the future however that'sfor
sure....







- Show quoted text -

Thanks millions,

 

[iccsi]

I wouldn't think it would make much difference;  in tables would be easier
should you be going to more than 2 languages in the future however that'sfor
sure....







- Show quoted text -

Thanks for the information,

The only thing is I need run query every label.
For example, there are 100 labels on the form then I need call 100
times queries to get individual label for different languages.
Are there any way to run a query to get all label in one shot?

Thanks again,

 

[NTC]

I believe the issue is your overall design - - which you need to reconsider.

One can have a table with essentially 3 columns/fields:
Language
Label
Text

you can have unlimited entries....

a single search by language i.e. "spanish" would then return all records...
and you can create your report on this query.

clearly you have not conceived/invented your design in this manner if you
are wrestling with 100s of queries - - and my description above may not be
what you seek ideally - - - but a design requiring 100s of queries is not
feasible and so you must reconsider a different approach.