Kaseya Community

Business Intelligence report distribution

  • Hey Everyone,

    We are currently developing reports using Business Intelligence studio. We are at the point now where we wish to send the reports out to clients in a bulk, automated manner.

    Is anyone else doing the same thing, if so how are you achieving this?

    Thanks.

    Legacy Forum Name: Business Intelligence report distribution,
    Legacy Posted By Username: powernet
  • powernet
    Hey Everyone,

    We are currently developing reports using Business Intelligence studio. We are at the point now where we wish to send the reports out to clients in a bulk, automated manner.

    Is anyone else doing the same thing, if so how are you achieving this?

    Thanks.


    Our development team is working on a similar project and told me that I will need to upgrade to SQL Enterprise to have this happen. Apparently there are a lot of report/distribution features in the Enterprise version.

    Legacy Forum Name: How-To,
    Legacy Posted By Username: CCDave
  • If you use SQL Enterprise you can run querys at the subscription stage of SSRS so that your parameters can be queried - Send this to all clients that begin with Letter A.

    In SQL standard you would need to create a subscription per client.

    Legacy Forum Name: How-To,
    Legacy Posted By Username: mmartin