Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 03, 2016 at 01:03 PM

    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

    Add comment
    10|10000 characters needed characters exceeded