I have two different queries in my crystal report.

 

Lets say Query1, Query2.

 

In Query1 , I have columns EmpId, EmpName, Sal.

 

In Query2, I have columns  Label, Actual Label, Language

 

I am displaying Query1 data in Details section. As of now I am displaying headings as Employee_Id, Emplyee_Name and Salary.

 

Now I want to display different labels as headings based on input parameter language.

 

So In Query 2, I have list of all labels and Actual Labels.

 

I created formulas for header labels as , EmpId_Lang, EmpName_Lang and Sal_Lang.

 

I created the forumla for EmpId as follows.

 

= If ( {Quer2.LABEL}="Employee Id" and {?Lang}='Chinese") Then {Query2.'Actual Label'} ELSE "Employee Id"

 

The problem is, its working only for first record. But if the conditioned label is after 1st record in Query2, its not working.

 

how can we do thi? Do we have this kind of functionality in Crystal?

 

Thanks in advance

 

Regards

Gowtham