How to control when a report executes, by statement not only date and time.

Last Post 07 Aug 2006 06:22 AM by whynot. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

31 Jul 2006 11:23 AM
How do you control when a report executes (Report Services - Report), I need to control by statement not just Date and Time. Basically if the record set has no records do not execute.

Can this be done at the DTS level by simply adding a "Data Driven Query Task"? and or is thier other approaches within the Reporting Services Tool Set?

-- Ralph Perez
New Member
New Member

07 Aug 2006 06:22 AM
I would do this before start the report by creating a VB package or SSIS package, even T_SQL code. The first step in the package is to check if there is anything. Then start or not start the report.

Acceptable Use Policy