I have written a report which, depending upon the data year you want to analyze, runs against different databases. If you want the 1987 data, for example, you pull from the 1987 database, and so on.
It is no problem to change ("update") the files to the correct year and then run the report...when you remember to do it.
Is there a way to put an "alert" or something into the report which reminds the user to "update" the data files before actually running the report? What would the syntax be?
Or better yet, is there a way to automate the "update" files process based on a parameter such as [?Year}?Alternatives :
-Develop a small application in a visual language (Delphi, VisualBasic, FoxPro)
-Copy the report for each year and name them and configure them accordingly (Report1987, Report1988, and so on)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment