Reports based in parameter query.

[TIbbs]

I'm having some problems with creating some reports,
The reports are to be based on what the parameter queries returns. They would need to run the following:
Customer sales report:
by customer,by year, by semester, bytotal sales, by brand, etc.
If you where in datasheet view you would filter each field individually, but am not sure how I would create that as reports.
This involves a lot of parameter passing.
Should I pre-create the reports to display in a certain way or I would need to use VB to pass the data onto the reports?
The query has various levels, so am wondering if I apply the parameters to the query or create filters with the report.

Am a bit at loss in how to solve this one

 

[pbaldy]

For one or two fields, I generally use this:

http://www.mvps.org/access/queries/qry0001.htm

For as many as you have, I would use VBA to build a wherecondition and open the report with that.