Skip to Content
author's profile photo Former Member
Former Member

Database issue in crystal reports

Hi Every one please solve this.

My requirement is like this.

I have a label called employee.i need to display it based on language selected like this.

if language=english then Employee

if language=french then Utilisateur

For this i created a database table called test like this.

language keyname keyvalue

english emp Employee

french emp Utilisateur

Then i pull this table into report and I created a parameter for language field like this {?language}

then i created formula like this

If test.language={?language} and test.keyname="emp" then test.keyvalue

But the issue is if i drag this formula to page header is it is taking only first row from the db table only.i.e,

if i select language=english then it is giving the correspondence keyvalue Employee, but for french it is not giving the keyvalue Utilisateur,

What i observed is that it is taking first row data only.

Can anyone please explain what wrong i did or is there any way to implement this approach from database

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Dec 10, 2012 at 10:51 PM

    Hi Vissu,

    The Page Header will only return the first record that appears on that page because it can only process 1 record. If you create a group, the Group Header will only return the first record in the group.

    So I would recommend creating a group on Language then your records will fall into to the correct language.

    Hope this helps,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.