Dynamic Reporting

[Louise]

I have a table of volumes processed for a particular financial quarter including the totals for each month within that quarter.

I need to create a series of static information reports from this data. The table is broken down into clients, products and activities with their respective volumes and I need to be able to present reports in all combinations. For example, volumes for all clients for a particular activity. Or alternatively volumes for all activities for a particular client and product. Basically I've worked it out to approximately 36 separate breakdowns.

What I would like to achieve is not 36 separate queries and reports, but a few templates where the contents and criteria for the reports can be generated on the fly by user selection in a custom dialog box.

Can anyone refer me to some documentation, either in the help files (I have not found anything usefull so far) or tutorials or articles elsewhere on the web?

I am competent in vba coding and some sql so that is no issue. I'm just not sure what the process is. Once I have that, I should be able to figure out the details.

Thanks!!

 

[Carol]

Create a user parameter form using unbound combo boxes, with its recordset set to the fields that you want the report to be based upon. Call these unbound combo boxes within the criteria line of your query. On your form, you can have the selection "From" and "To" for each type of selection and you can have multiple field selections. Using this method, (depending on the complexity of the reports) you may only have to create one form and one query to obtain the desired results that you want.
Example:
Between [Forms]![MyFormName]![BeginningDate] And [Forms]![MyFormName]![EndingDate]
where MyFormName represents the name of your form and BeginningDate and EndingDate will represent the names of 2 of your unbound combo boxes.

Good luck