Creating drill down reports is common in data reporting scenarios and is simple to define within QuickReportz.


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




Create navigation column to the Child Report

Navigation from the parent to the child report is available through 2 methods:

  • Single row-column button
    • To learn more about this method click here.
  • Multi-row check-boxes
    • To learn more about this method click here


Passing Data from Parent to Child

There are two methods for passing data from the parent to the child, automatic parameter linking, and LinkID


Automatic Parameter Linking

The easiest method is Automatic Parameter Linking.  Using this method all parameter values and all the columns from the clicked row are passed to the child report to be used in the query.  No additional setup is necessary for this to work.  


To learn more about this method click here.


Using LinkID

Using the LinkID method for linking reports creates a common contract between reports and allows for linking between parent-child as well as related reports not in a parent-child relationship.  The LinkID method also makes it possible for child reports to be linkable from the URL so a link to the report can be emailed to another user.


To lean more about this method click here