Drill-down

Cory Fifield -

Trouble viewing images? Click on images to enlarge.

 

Drill-down

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.

Grouping
mceclip2.png


Add the detail items. For this example we added Contact Name, City and OrderDate.

Detail Items
mceclip3.png


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.

 Drill-down Properties
mceclip4.png


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)

 

mceclip5.png

 

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
mceclip6.png


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  mceclip7.png icon where the checkbox was.

Databinding Property
mceclip8.png


Drill-down Example
mceclip9.png

 

** 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. **

Have more questions? Submit a request

Comments