How to execute a report based on a query

• jeroen gruppen

  Newbie

  Points: 7

  More actions

  January 23, 2006 at 4:20 pm

  #166722

  I wonder if the following is possible;

  I would like to fire off an Reporting Services report based on the outcome of a query. Something like: 'if the total amount of salaries > 10.000 then execute a specific report and mail it to a subscriber'.

  I know you can define data driven subscriptions, but they only allow you to dynamically specify the receiver of the email based on a query.

  I would rather be able to define a query that would then trigger a scheduled report. Anybody knows if this has been done already (without development in .NET, VB or ASP)?

   

   

• philcart

  SSC-Forever

  Points: 47797

  More actions

  January 23, 2006 at 11:28 pm

  #616572

  You could setup your report on a schedule then check the command text of the SQL Agent job that is created.

  Just use the same command text in a trigger or other stored procedure.

   

  --------------------
  Colt 45 - the original point and click interface