Drill down through parameter fields

[demchak]

I am looking for a way to have users select report info based off of a drill down.
I was thinking of using parameter fields but could not figure out how to do it.

Ex.

User is prompted to
Select the type of report you want to run

Division
Department
Section

The next menu will only offer the appropiate choices so for example they picked division the next menu would offer

Commercial banking
Consumer loans

but if they picked section the next menu would offer

Res Lending I
Res Lending II
Res LEnding III
Com Lending I
Com Lendng II


Thanks for any ideas on how to do this.

 

[vidru]

You could do something like this with a table structure like the following:

ReportType    SubReportType
------------  -------------
ReportTypeID  SubReportTypeID
Description   ParentID
              Description

... where SubReportType.ParentID = ReportType.ReportTypeID.

Group by ReportTypeID, with the SubReportType info in your details section (which would be hidden, but allowing drill-down). In the details section for each SubReportType, you could use On Demand Subreports for each different kind of report.

-dave