Scripting - Re running a report using DAS 2

[ATP]

I am publishing reports as HTML to a web page using the Document Agent Server.

Since we publish one report per supplier, I need to re run the report 140 time (one for each supplier). Running each one as a separate job will be a bit of a maintenance nightmare!

So I've written a script to take a standard report, alter the query for the a supplier and refresh the report. The script will run the report for each supplier in a list.

The problem I have is that I can not find a script command to save the refreshed report as HTML. I've tried using the "ExportAsHTML" command but can't get it to work.

Has anyone tried this before, if so do you have an example?

 

[Guest_imported]

Do you still have this problem ?

 

[ATP]

No, I managed to fix this one.

All I needed to do was add "Call" to the start of the command and use ExportSheetsAsHtml instead.

e.g.
call myDoc.ExportSheetsAsHtml(HtmlFile,SheetNames,1,1,1,1,1,1,1,0,0,0)

Thanks

ATP

 

[BobWard]

good news for you then. I'd liek to di the same as you but i've got 20 reports which want to go out to 1000 customers a query can take 3 minutes per refehs, so as you can see i soon run out of time to publish these reports. any suggestions ?

 

[ATP]

My option will just reduce the number of jobs I have to schedule not the time taken to produce the data. I remove a condition from the query, re run and export.

The only thing I can think to do is to create a report for all the data and then iterate changing of a filter in the report and then exporting and see if this is any quicker.