Can A Report Contain Parameters Which Don't Need To Be Selected?

[Sange]

I have report which has been developed in CR9. The reports list attendees at different stations. There are currently three different versions of this report which lists the station attedances according to Region, Division, District. For example, in the Region Report the end user can elect to look at records for Region 1 and do so by selecting Region 1 in the parameter box.

Rather than three seperate reports for each of these categories, what I'd like to do is give the end user the option of viewing the reports at a regional, district or divisional level depending on which parameter they select. Each parameter would contain the different relevant details for the end user to choose from. Is this possible? There would also be a date range that the end user would have to enter.

Any suggestions would be welcomed.

 

[mchoss]

Not sure if this helps your situation, or works with your data, but i had a similar issue where i wanted the default option for certain parameters to be 'all' values such that if they supplied selection criteria then filter, otherwise pick all records according to that parameter. This involved implementing the following for all fields concerned:

When creating your parameter field values list, make the first value 'all'.

In your record select formula add the following code:
({?Parameter} = 'all' or {?Parameter} = {table.field})

If you have 'all' as the first value of your parameter values list, it will be the default value, and users won't have to enter anything unless they want to select on a specific value.