1) Create Drill through report to link two reports contain related information
2) You can access related and more detailed information in one report by using to select a value in another report.
Steps:
Create child report:
Open the list report, add data items to the list report, and then create filter values like prompts. Save the report.
Create master report: open new list report, add the data items to the list report. Add the filter values like act as parameters. Right click the column that would be act as drill through column, click the new button.
1) Report—click the ellipse point and select child report.
2) Actions—click the run the report/view most recent report/ edit the report.
3) Format—select the format type like html, PDF, CSV, excel.
4) If you want open a child report in new window—OPEN IN NEW WINDOW.
5) Parameters—click edit button,
a. If the item parameters, under method, pass Parameter item value and select parameter for a value.
b. For the item parameter, under method, pass data item value and Select parameter for a value.
6) Run & save the report. |
