Reports - Save a report by Group

[JJPetersen1]

Not sure how to intelligently ask this question. I'm a novice.

I have a report, the data is grouped by Unit. What I want to do is save a report for each grouping (Unit) on the report.

I could send the whole report to all Units but I don't want each unit to have the information from the other units.

I could run a separate report for each unit; however, that's very time consuming for a report that's frequently run.

I'm asking for a lot, I know. Any help would be appreciated.

[June7]

Options:

1. run report for each group with filter criteria for each group - this can be automated with VBA procedure

2. run one report which is designed to start new page for each group and split up printed pages for distribution

[Welshgasman]

Could also filter the query for the report?

[June7]

Apply filter to query or to report (I would do the latter) still basically option 1.

[Welshgasman]

Apply filter to query or to report (I would do the latter) still basically option 1.

My thinking was with query only records satisfying the filter would be retrieved.
With report, all records retrieved, then filtered for required?

If large dataset, then first option might be quicker as O/P said running a report for each would be time consuming?

I agree still mostly option 1.

[June7]

Does applying filter criteria with DoCmd.OpenReport retrieve all records?

By 'save a report', do you mean make PDF?
One example of option 1 https://stackoverflow.com/questions/...iple-pdf-files

[Welshgasman]

Does applying filter criteria with DoCmd.OpenReport retrieve all records?

By 'save a report', do you mean make PDF?
One example of option 1 https://stackoverflow.com/questions/...iple-pdf-files

I thought it worked the same as a form? where if the filter is removed when the form is open, then all the data is available.
Just tried now with a report and it does not change?

Talk about consistency.

[June7]

I just tried and it did change.

[Welshgasman]

I just tried and it did change.

Hmm, I opened a report with a filter in the docmd, then in the load, set it to empty and FilterOn to False, but left with same data.
Refresh is disabled.
How did you do it June7?

[June7]

Oh, I tested with immediate window

Reports!MyReport.Filter = ""