41333members
184398posts

Automated Report Generation

Highlighted
Crewman

Automated Report Generation

Hi Community 

 

I'm trying to determine how to automate a current and working Query that does diagnostic on our RTUs to daily generate and export that list at a particular time everyday.

 

 

Thanks for your assistance guys 

Tags (1)
6 REPLIES 6
Highlighted
Lieutenant JG

Re: Automated Report Generation

In the DataBase Tree, right click, then Create New > Other > Schedule. 

 

Put your Query into a "SQL Export". Setup the Schedule to run Daily, weekly, or Monthly, etc, choose the time. Then drag and drop the SQL Export into the Object portion at the bottom of the Schedule window and choose "Export SQL Query Result" as the method.

Highlighted
Lieutenant JG

Re: Automated Report Generation

An alternative to an "SQL Export" would be a Crystal Report. This gives you more choices over the generated file format, e.g. Word, Excel, PDF, rather than just CSV.


Andrew Scott, Lead Engineer, AVEVA
Highlighted
Crewman

Re: Automated Report Generation

Thank you very much for taking time and effort to respond.

 

I will look into this

 

Tdog

Highlighted
Lieutenant

Re: Automated Report Generation

I've marked Hardin4019's post as the solution, feel free to do so yourself if you are happy with an answer in future.

Highlighted
Crewman

Re: Automated Report Generation

Hi Would anyone have an example script of how to do this?

Highlighted
Lieutenant JG

Re: Automated Report Generation

Not much of a need to use a script since most of what you would need to run a report can be accomplished with a schedule. But, I suppose if you wanted to, the biggest thing you would need to know is how declare and call a Method to Execute or Export a SQL Export or a Crystal Report. 

 

Here is a link that might have helpful info.  https://tprojects.schneider-electric.com/telemetry/display/public/CS/Reporting