SQR Production Reporting Studio allows you to graphically generate reports that you can run on a regular basis (daily, weekly, and monthly).
When you create a report in the Layout window and save the resulting SRM layout file, SQR Production Reporting Studio generates an associated SQR file. The SQR file is located in the same directory as the SRM file, and the files have the same name (for example, reportname.srm and reportname.sqr).
Once you successfully create a Production Reporting report, you can move the report into production and run it from a centralized area.
If you have an SQR file that was not generated from an SRM file, remove all hard-coded file paths. If the file contains an Interactive Reporting Analysis chart or cross-tab, reload the SRM file to publish.
To move an Production Reporting report into production and run it from a centralized area:
Transfer the Production Reporting file to the central area where you will run the report.
Copy all of the #INCLUDE files referenced by the Production Reporting file.
For example, if you modify the Production Reporting code to include a standard header file #include xxx, you must copy the xxx file along with the Production Reporting file.
When SQR Production Reporting Studio embeds an image, the Production Reporting code contains the fully qualified path to the image. Since the path will likely change when the file is moved to the centralized area, you should manually modify the Production Reporting code. Do a text search on the phrase IMAGE= to locate the fully qualified path and modify it as necessary.
Set up a batch file or command script to run the report with the proper command line options.
The command script will contain at least a single line of script similar to the following:
Sqr reportname.sqr -keep -nolis username/password@server -printer:EH
See Volume 2 in the Hyperion SQR Production Reporting Developer's Guidefor more details on the Production Reporting command line syntax.