Delete instances with no data

[Former Member]

Hi All,

I have several reports that run daily and create blank reports if there is no data. Is there a way to suppress/delete the instance/output from showing up in history for these reports in Infoview/Instance manager?

All my reports use stored procedure to extract data from database and the procedures return a blank record if no data is available. So the report will not error out for no data condition. Infoview would show such instances as success. My problem is that there are hundreds of instances with no data to report and users have to go through each of these instance checking for any data. Appreciate your help.

Environment: CRS XI, CRS2008

Reports developed in CR XI R2 and CR 2008.

Thanks

[Former Member · Accepted solution]

Perhaps you could schedule your reports based off of an event.

The stored procedure could create a small text file with the name "success.txt" and send it to the Business Objects Server. Once this file arrives on the server, that would be the event, and then the report would run.

If this file does not arrive, (ie: no records in the stored procedure) then the report would not run.

You would have to modify your stored procedure to send a file called "success.txt" if there was >0 records found.