Bob_Hansen
Senior Member Members
    Offline
 WOW, They have the Internet on computers now!
Posts: 1861
Location: Salem, NH
Joined: Nov 24 th, 2002
|
Reports - Temp Changes
Nov 15th, 2004 at 10:22pm
|
Print Post
|
1. I can define reports with Saved Specs. These specs will ignore the current record set and only show those records that comply with the Saved Report Specs. That is good.
2. I can define reports with no Saved Specs. This allows me to do real time definition of the current record set, so only those records, selected now, will be on the Report. That is good.
3. How can I have the user call up the report with the Saved Specs, and make temporary changes to that Report, similar to what we could do in Q&A?
I may want to use a Report with pre-defined Sort Specs and predefined Retrieve Specs, but allow the user to modify only the Date Range, or just the Customer Name, etc. Currently, if the user knew what the Saved Report Specs are, they could at least manually call up those Saved Specs. But more common is the situation where the end user may not know the names of the Saved Report Specs, so it will just be trial an error.
Right now I use a different naming convention for reports that can be defined at time of use, and those that have non-changeable Saved Report Specs.
Hmmmm, maybe some programming with an AskUser command to define Date Range, Customer Name, etc. at time report is run? OR Maybe a Report Utility that prompts for a number of variables with defaults already inserted? Based on results of prompts/combo boxes, certain macros could be called to execute the Retrieve/Sort parameters, then run the canned report.
Until then, I look forward to being told that I have overlooked a simple report tool, and that tool is called ??? ???
|