on 11-03-2016 9:55 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
72 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.