cancel
Showing results for 
Search instead for 
Did you mean: 

In crystal report ,how to pass result columns from a main report to subreport as parameters

Former Member
0 Kudos

I have a main report with fetching details of employees and sub report fetching address of the employee. Subreport is also a query based with parameters emp_id and address_type as parameters and sub report is a column in main report.

So I have to fetch details as below:

Emp_Id ......Address_type.. Address --> Column name

1234 ..........Home............ etcetc ------->> data fetched on main report

Here etcetc is fetched form sub report for a particular emp_id and Address_type from main report.

Accepted Solutions (0)

Answers (1)

Answers (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Akshay,

1. Right-click the Subreport > Change Subreport Links > Move the 'Emp ID' field to the pane on the right.

2. From the drop-down at the bottom right that says 'Subreport parameter field to use', choose the 'Emp ID' prompt. This links the EMP ID field in the Main Report to the Subreport's prompt.

3. Repeat steps 1 and 2 for Address Type.

-Abhilash