O no..lang support??!?!?

[mission2java]

I have a vb6 database and I'm working on crystal reports. The problem is one of the people here wants the report im working on in various languages. I have added columns to my database table to support 3 additional languages and they will have to administer this data by translating the description in the three languages. However, how should I handle the report in this? Is there a way to tell crystal to pick up specific table columns and use them as data based on a user selecting a language? I shouldn't create 4 individual reports should I?????

Thanks,
Jon

 

[pgtek]

hi
In your vb app have a secton for user to pick alanguage
of the report to view.
you might have to create report to match language the user picks.

Crystal does not translate to different language a report done in a specific language.
Or
create a parameter on your report for the user to select language and in the report have the header change to specific language used. It's long for you have to create formula to match the choice.
Have your database fields match the parameter selection and formula used
I works for i did it before.

hope this helps you

cheers

pgtek

 

[mission2java]

Not sure what you mean...Im asking on the database side...wont I have to collect the correct columns from the table? Meaning if I have a table of components. Lets say I have 4 fields:

EnglishDesc
GermanDesc
FrenchDesc
SpanishDesc

These fields all contain the identical data except in different languages...dont I need to select the correct column here? How would selecting something on my front end determine this? Would this be one report or 4 individual reports?

Thanks,
Jon

 

[pgtek]

Hi
Here what i mean
in your report have a parameter for the language.
English, German, French, Spanish

In your report
column heading have this formula for each sector
ex:

part num desc price


formula

@desc
if
language = "French"
then
FrenchDesc
else
language = "English"
then
EnglishDesc
else
if
language = "German"
then
GermanDesc
else
if
language = "Spanish"
then
SpanishDesc
you need one report to do this

hope this clear up


cheers

pgtek

 

[mission2java]

Im not too good with programming in crystal, hence my confusion. it wouldnt be possible for you to whip up an example for me would it? Just a small report like so..just so i can look at it. You can use access db if you so desire.

Thanks,

Jon

 

[pgtek]

Hi
this would take to long for me to do since i'm at work.
create a parameter language
set as text no link to table

your report inser your table
depends whait field you have is hard for me to see

can you copy your database field and definition you used on your report
ex:
desc char (50)

and so on for me to see
and a layout of your report
header and fields use

this would help me greatly

cheers

pgtek

 

[mission2java]

Ok...

I have the following ...

Basically I have a group header that has basic information such as a Customer, Site, Commission, Cost Unit, etc.
Then I have 4 detail sections (basically sub reports)
Details A is transport components
Details B is pallet components
Details C is station components
Details D is optional item components

The fields I have for each component detail section is:
Position, Component, and ComponentDescription (Currently ONLY in English)
Position is a number field basically integer. Component is text varchar(50), and ComponentDescription is also a text field varchar(255). I dont know parameters and code in crystal that is why I was asking for an example. I do understand however you have your own work to do...but i do not expect you to have an example right away. Is it possible you can work on a small example and return back to me sometime next week? This is not urgent...
Thanks again,

Jon

 

[pgtek]

Hi
This is good
since tou have already design the report this should be easy for you to do.
for every Header you have in your report
just create formula to match the language
ex:
Customer,
@cust_Lang
Site
@site_Lang
Commission
@comm_Lang
Cost
@Cost_Lang
Unit
@Unit_Lang

do the same for your sub report

use the formula i listed in the previous post
replace each header by the formula you created for each header
and so on
have a parameter call {?Lang} as string
and for each formula you created use the select expert to link each of the formula to that parameter
ex:
{@Desc_Lang}= {?Lang}
and so on for the rest of the formula
so when user is prompt to select language the parameter will check what is link to it and then the correct header name and language will be on that report.
Link you subreport to {?Lang} = {?Sub_Lang}

NOTE in your sub report use the same formula but have @sub_Name} in front
for you parameter for your sub name it {?Sub_Lang}
link you main report to sub report
{?Lang} = {?sub_Lang}

hope this clears it up a little

cheers

pgtek

 

[mission2java]

I dont know if this has helped...since i dont know where to place any of this stuff...that is why i wasasking for a sample.

Would it be a bother for anyone to post a sample of what im looking to do. Sorry for this inconvenience.

Thanks for your time
Jon

 

[pgtek]

Hi
well this is as much i can do for you since i dont have a layout of your report or what are the requirements and database information.
Hope someone other than me can help you.
sorry

pgtek

 

[synapsevampire]

Try:

Insert->Field Object->Right Click Parameters and select New

Name it :

Language

place something like:

Please select the desired language

in the Prompting text and select Set Default Values.

In the Select or Enter Value to Add, add in each of your languages followed by the right arrow.

Hit OK, and unselect the Allow editing of default values.

Now create formulas for whatever fields will be language dependent as in:

Insert->Field Object->Name of the field you'll be language dependednt on

If {?language} = "French" then
{table.frenchdescr}
else
If {?language} = "English" then
{table.Englishdescr}
etc...

Hope this resolves for you.

-k

 

[mission2java]

Thanks Vamp,

Im going to give this a try.

One final question...I understand now because of your post how to have a menu come up for the language...however my last question is..there is just one field for each sub report (details) section that shows this field...its just the description. Will this be replaced by each language once the user has specified which language he / she wants?

Thanks,
Jon