Hi All,
I needed a report so I used the report wizards to make it based on a query I
made (also made with a wizard). That all works great.
However, now I need a identical report only based on a subset of the data I
used for the first report...plus, a little other info (from another query).
I thought, okay, I'll copy the first report and rename. Except it's source
is the 1st query. I need it's source to be another query. Not a problem,
just copy the query, rename it, change it accordingly and used that as the
2nd report's source, and viola. There's my new report.
But, now I've got 2 querys and 2 reports to maintain--plus some subreports I
have to worry about too...so now I've got 2 of those, etc.
If my user says "gee, sure would be cool if these reports hand "x" in them
too, then I've got to change multiple reports/querys/subreports, etc. A
pain.
Is there a way to tell access to run a report, but instead of the report
being based on a specific query (hardwired, so to speak in the "source" area
of the report), have it use different querys with basically the same info,
chosen at runtime? And, if it's possible, can someone point me to where I
might find the correct way to do this?
Thanks,
ron
I needed a report so I used the report wizards to make it based on a query I
made (also made with a wizard). That all works great.
However, now I need a identical report only based on a subset of the data I
used for the first report...plus, a little other info (from another query).
I thought, okay, I'll copy the first report and rename. Except it's source
is the 1st query. I need it's source to be another query. Not a problem,
just copy the query, rename it, change it accordingly and used that as the
2nd report's source, and viola. There's my new report.
But, now I've got 2 querys and 2 reports to maintain--plus some subreports I
have to worry about too...so now I've got 2 of those, etc.
If my user says "gee, sure would be cool if these reports hand "x" in them
too, then I've got to change multiple reports/querys/subreports, etc. A
pain.
Is there a way to tell access to run a report, but instead of the report
being based on a specific query (hardwired, so to speak in the "source" area
of the report), have it use different querys with basically the same info,
chosen at runtime? And, if it's possible, can someone point me to where I
might find the correct way to do this?
Thanks,
ron
Comment