Create Report with SubReport Filtered by ComboBox and date in header

[crimedog]

See attached


I have created a list of orders (Table)
I query the Table - filtering by Year and Quarter (Quarter being a calculated field)

Now - I want to print report - One page per Rep That shows Rep Information Then the Deals by Month (depending on the Quarter chosen)
So Subreport 1 should show Jan if quarter 1 April if Quarter 2 etc...
SubREport 2 shows Feb, May, etc...
etc...

So far it Asks the Year and Quarter for each Rep for each subreport (so open in Design Mode)

Also - how do I set a checkbox or something that filters out all the reps that do not have a null value in exit date?

[June7]

Why are you using subreports? Consider a single report using Grouping & Sorting features. Access Help has guidelines

Don't use parameter input popups. Build a form for user input of criteria. Reference controls on form for parameters.

Review:
http://www.datapigtechnologies.com/f...mtoreport.html

[crimedog]

Thanks for the link -I knew about DataPig, but haven't watched this - Very Nice.
The subreports are because I want a report for every Rep - for a particular Quarter that shows each Deal from January with subtotals, February with Subtotals etc...

In essence: Month 1, Month 2, Month 3 of the quarter. Seperated and totaled

[June7]

Still sounds like a report with Grouping & Sorting should be able to accomplish that.

[crimedog]

Okay I have Grouping to seperate the months - How would I subtotal the groups?

[June7]

Can have multiple groupings.

Textbox with aggregate function expression in group or report or page header/footer can summarize at any of those levels.

=Sum([fieldname])

=Count([fieldname])

=Avg([fieldname])

etc.