question

bushfoot avatar image
bushfoot asked

How can I programmatically create a data driven subscription for SSRS?

We currently have a reporting model that supports running reports on demand and/or on a schedule. Our reporting model also supports email and printer distribution.

I have been asked to explore leveraging SSRS for our reporting model moving forward. How can I programmatically create a data driven subscription?

ssrssubscriptions
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

visakh16 avatar image
visakh16 answered
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rajib Bahar avatar image
Rajib Bahar answered

Did you mean programmatically in C# or TSQL? In TSQL, you can create a stored procedure (defining the biz logic) and have it return the columns that the "Data Driven Subscription" wizard would expect.

If you meant C# then visakh16 appears to have the solution.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.