Run SSRS report through SQL Job

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Run SSRS report through SQL Job

Author

Topic

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2012-01-16 : 05:59:26

Hi,

I have a report in SSRS with date as an input parameter. I need to run the report every month and export it to excel. So I need this to be done through sql job.

Kindly let me know the procedure.

Thanks,
Sandesh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-16 : 06:56:10

isnt it enough to set a subscription for the report monthly which will do the same thing on the background?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sandesh.ravi
Posting Yak Master

110 Posts

Posted - 2012-01-16 : 08:15:29

Thank you.

In addition to that. I have a data set that returns 2 columns program,count

Program Count
A 1000
B 2000
C 3000

I need to display the report as

A B C
1000 2000 3000

Kindly let me know the procedure to achieve this.

Thanks,
Sandesh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-16 : 10:26:00

just use a matrix container for report and add a column grouping on Program field and for expression use
=SUM(Fields!Count.Value)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources