Solved

language depending code text in crystal report

Posted on 2000-03-14
5
586 Views
Last Modified: 2010-05-02
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.
0
Comment
Question by:pce
5 Comments
 
LVL 4

Expert Comment

by:vindevogel
ID: 2616227
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
 

Author Comment

by:pce
ID: 2618765
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
 
LVL 2

Accepted Solution

by:
cero earned 100 total points
ID: 2632302
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
 
LVL 2

Expert Comment

by:cero
ID: 2632303
Of course this code in Visual Basic
0
 

Expert Comment

by:pnozay
ID: 10223063
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

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question