Building a report from the correct query file.

[chris35]

We are using Info 7.5. I have scheduled a query to run every day with a date parameter prompt set to 'Yesterday'. This runs fine. Now I want to build a report off this query and schedule it to run dependent on the query returning an exit code of '0'. My question is when I am building the report in Info Design, I have to choose either a query object or a specific query instance. Which one do I use so that the report runs off the same day's query data and not a previous run of the query?

Thanks.

 

[gsomerville]

Hi Chris,

Base the report on the crystal query and not the instance.
When the SQL query is built it should have "Save data with report" disabled.

If there are any instances the report will use the latest instance as the datasource. If you don't schedule the SQL
query, the query will be run when the report is scheduled providing the report with the required data.

Unless the SQL query is used as a datasource for multiple
reports, I prefer scheduling the reports on a daily basis and not creating any SQL instances. This way the data will always be "fresh" and the output will be in the required format.

Regards,

Gavin

 

[chris35]

Thanks Gavin, but we do intend to use the queries for multiple reports. How do we accomplish it?

Chris