Resource for run time control of reports

  • Thread starter Thread starter Dave the wave
  • Start date Start date
D

Dave the wave

I am working on a dynamic report that changes according to the filtering and
sorting of a form. I would like to see some examples of reports either
created or greatly modified at run time. Specifically, I need to apply the
same filtering (multiple filters), sorting, and reassign controls
accordingly once the user has requested a hard copy of the screen data.

Any help is greatly appreciated.
 
I don't have any such examples, because what you describe tends to the
"complex" and my preference is for "simpler" solutions. In general, the
dynamic reports that I have observed in others' databases have been more
trouble than they were worth... and have all benefitted from simplification.

It is possible to obtain the Filter and RecordSource properties of the Form
and construct SQL in code to use as the RecordSource of a Report. Sorting
and grouping in reports is controlled by the Reports' Sorting and Grouping.
but that can be affected by the Report's OrderBy property (however, the
OrderByOn property must be set to True for the OrderBy to have any effect).

Larry Linson
Microsoft Access MVP
 
Back
Top