Urgent: Populating table fields based on a parameter value

[kncd2005]

Hi,

I have 2 different tables that can be linked together by the same field name. I want to display all field values from these tables in Crystal Report 11 based on a parameter value getting from JSP. For example,

Table 1
Employee_ID First_Name
1 Tom
2 Bill
3 James


Table 2
Employee_ID Extension_Number
1 123
2 456
3 789

If I have the value "1" for the Employee_ID (getting from JSP parameter), how do I get the First_Name and Extension_Number values (i.e Tom and 123) to display in my CR 11? Your prompt to this issue is greatly appreciated. Thanks.

KNCD2005

 

[synapsevampire]

Not sure what your question is, nor whether this parameter exists within the Crystal Report already, or if you are stating that you have a parameter collection screen in Java and you want to modify the record selection formula within the report.

I would suggest creating the parameter within Crystal, and then joining table1 to table 2 within Crystal, and then populating the parameter from your java code.

Here's the jsp samples:

http://support.businessobjects.com/communityCS/FilesAndUpdates/crxi_jrc_jsp_samples.zip.asp

check out: jrc_set_multivalue_parameter

-k