language depending code text in crystal report

I have an accesstable containing per code and per language the description.
example :
code  language  text
A      E        English text for code A
A      F        French text for code A

Instead of printing the code on my crystal report, i would like to print the text coming from the translation table.
I'm working in access 97.
I could write a UFL in visual basis in the crystal report but i hope there is another solution.
pceAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ceroConnect With a Mentor Commented:
Well in CR, u can create the report without restrictions. Then when you want to show the report in a especific language, u could use the selectionformula like this

MyCRObject.SelectionFormula = " MyField = '" & MiVarLanguageID & "'"

before showing the report.

0
 
vindevogelCommented:
You can create a query in your Access table.

You can have a query like "Select * from table ..... where Language = 'E'

In this query you should include the textfield for that code, of course.

You can then base your report on the query. Works just the same for CR.
0
 
pceAuthor Commented:
the languagecode is a parameter in CR.  This parameter is passed at the moment of execution.  How do I pass this to the accessquery ?
0
 
ceroCommented:
Of course this code in Visual Basic
0
 
pnozayCommented:
Softlang has developped a new tool called "Crystal Translator" designed specifically to translate/localize reports produced by Crystal Report.
Check it out at www.softlang.com
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.