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 Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
rlperez
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
whynot
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.
You are not authorized to post a reply.

Acceptable Use Policy