Linking reports using the automatic parameter linking method enables passing all column data from the clicked parent row to the child vs. only a single value that is allow in the alternative LinkID linking method,
CREATING THE CHILD:
To create a child report simply scroll to the "Child Reports" section within the report editor and choose click the "Create Child" button. Once 1 or more child reports are created they will also be show in this section for easy access.
NAVIGATION HINT:
Once you are on a child report is it easy to return to the parent by clickin the "Go to Parent" button in the lower right
CREATING LINK FROM PARENT TO CHILD REPORT
Define a "Report Link" column on the parent grid that is associated to the child grid. To learn more about this step click here.
CHILD REPORT SQL:
The SQL command text within the child report can access all parameters for the child report as well as the parameter values and all the row/column values from the row in parent grid in which the row was clicked. For example, clicking the the "Books" button/link in the first row of the parent grid as shown in (Figure A) injects all the variables as shown in (Figure B) into the child grid command text. Context aware intellisense is provided to show which properties are available as show in (Figure C). Intellisense is refreshed each time the parent report is executed.
FIGURE A
FIGURE B
FIGURE C