Modular Report

[thread]

Hi have several of reports based some breakdown of information
for now,for every breakdown there is a sperate report(reach to about
40)
its very stiff and i think it takes alot of place.
does anyone have an exaple of tip of one report that will be modular
and will be adjasted to the breakdown?
i manage to do it with a Modular Form but for now didnt find solution
to the report

 

[Allen Browne]

Depending on your data structure, it may be possible to reuse the same
report, filtering, sorting and grouping it on the fly.

Here's a basic example of how to open the report filtered:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

Here's a more complex filtering example:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
(Although that example is for a form, the filter string is identical for a
report.)

Here's how to change the sort order on the fly:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html
That example reassigns the ControlSource of the GroupLevel, so that's also
how you modify the grouping on the fly.