Steph said:
How do I give the user the option to develop the requirements for
their own reports?
The best way is to show them how to do their own reports.
If not then you need to find out what they (think) they need and build
reports for them.
Code can be used to allow a report to print a variety of ways but I've
always ended up just adding a copy of the report, then modifying it to suit
them and place it on a menu.
Another approach if they want to see subsets of something is to use a
subform or two with a checkbox. I have a form with Doctors names and
requested tests as subforms.
Both have a "include" yes/no field and buttons at the top of each subform
which will select or deselect all the names.
The user check the docs he wants and the test he wants and this is used in a
query to provide a report sorted by docs with a count of the tests selected.
