Creating FRx Reports with Drilldown Capability

Drilldown capability is one of FRx’s basic, and most important features.

Yet I’ve seen more than one report recently where the design of the row prohibited drilldown to account and subaccount detail, so this design flaw is more common than I thought. So here are a couple of examples. Both give the same finished results, but one you’ll be able to drilldown on, and the other you won’t. Care to guess which is which?

This row won’t allow you to drilldown on Operating Expenses. Note the individual accounts are nonprinting. Only total Operating Expenses will print, and because its components are nonprinting, you won’t be able to see the detail behind the total.

This is the same row, but revamped to allow for drilldown on Operating Expenses. Cleaner, isn’t it?

And don’t forget to set the Detail Level in the catalog to Financial & Account. Even a properly designed row won’t drilldown without it!