I wanted to add extra functionality to my reports so that it calls a webservice to determine if the datawarehouse is loading or not. Based on this answer I want to continue querying the other datasources for data or stop the report all together (returning a blank report).

 

Basically I want to do this...

 

If "loading" Then

    Dont query the database and generate a blank report

Else

    Generate the report as usual

 

Is this possible to do in CR without it having to read all the data first? Or am I better off inserting this logic into my stored proc?

 

The last step in the ETL job is to copy a file to the folder that is being watched by the BOE server.

 

It is also possible to string groups of reports together using these events.