Trouble viewing images? Click on images to enlarge.
Group the report using a preferred field in Group and Sort at the bottom of the Finished Reports designer. In this example we use EmployeeID.
Place a field (EmployeeID) in the group header (Label1) for the main grouping.
Add the detail items. For this example we added Contact Name, City and OrderDate.
Set the detail band’s “Drill-Down-Control” property located in the behavior tab of properties to “Label1” and uncheck the “Drill-Down-Expanded” property.
Adding field headers in the drill-down
Add the field headers to the report. (4 new labels used for the headers above the original fields)
Set the following properties for each new header label:
Set the “Process Duplicates Mode” property to “Suppress and Shrink”
Set the “Process Duplicates Target” property to Tag
Process Duplicate Properties
Set the “Tag” property located in the Data tab of the properties to the field that was used for the grouping. In this case it would be EmployeeID. In order to do this, click the checkbox to the right of the property and select Tag Expression. Then double click on the desired field and click okay.
Once you have a field selected, you should see a icon where the checkbox was. Repeat this step for each header.
** Please note, in order for the drill-down to work correctly, the item that controls the drill event (in this case the label) will need to be on an outer band. Also, the drill-down will only be available in the previewer. The drill-down will not be exported as it’s only available in the previewer. **