Cache in ReportNet 2

[Jedrow]

Hello everyone.

I`m looking for help. I`m using ReportNet and I would like to cache reports during the night and than in the morning run them without accessing database or at least to make the execution time shorter.

 

[amalcolmf]

Schedule your reports to run overnight and save the output in your preferred format ie. HTML, PDF, ASCII, XLS, XML.

You can also look into bursting.

 

[Jedrow]

Thank you for your help

 

[jo0001]

Just run the reports (as amalcolmf said) overnight and save your reports as reportView. This will cache the sql-statement.

Jochen

 

[Draoued]

I m not sure to agree with you.

If you run the reports during night in HTML format( after db update). Then if user runs the report in PDF or Excel he will access the database.
If you want the report to be ready , then you have to run all possible formats and prompt answers.

If you want that , why don't you train your users to schedule their own reports with the right format and right prompts answers.

There is nothing like Snapshot in Impromptu.