SQL Reporting Bundle

Question

SQL Reporting Bundle

Aswani kumar

Mr or Mrs. 500

Points: 556
More actions
October 9, 2007 at 4:39 am

#175801

Hi,
Iam very new to sql reporting services,please find the below questions let me know it is possible or not ?
1)Integrating multiple reports into a single package.
2)Scheduling a package?
After scheduleing if i execute the reports daily i need to change the report name .
Package 1
:Report 1
:Report 2
Daily iam executing the above package at 1.00 AM,i am moving the report1 to a different server on 1st aug ,i need to give the report name as Report 1 1St August,on 2nd Aug Report 1 2nd August.
Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Michael Earl-395764 SSC Guru Points: 53873 More actions · Answer 1

Not directly, but you have a couple of options.

First, if you want to literally do what you are suggesting, you could create your own SQL job to do this. When you schedule a report, a SQL Agent job is created to run the report. You could modify the scheduled job to run all of your reports and then copy of move the output of these reports to another server and rename them.

However, if I understand what you are trying to do, you have the option in reporting services to create report snapshots. These are stored on the report server and can be accessed through report manager. You also have shared schedules.

So, using these options, you could run all of your reports from a single shared schedule and have snapshots created that your users could access at any time through the web interface rather than collecting spreadsheets or pdf files on a file server.

Look at report snapshots in books online.

Aswani kumar Mr or Mrs. 500 Points: 556 More actions · Answer 2

Thank u ,

I want to do the things by using asp.net and Sql Reporting services APIS.

I need to develop a webpage where the users can integrate multiple reports in to one package.That package can be schedule daily at morning 7 o clock.

That package which consits lot of reports has to execute morning at 7 o clock and it has to delivery to the customer.

My Question :

1)In which database or tables i need to enter the records for schedling a package

2)Whether this thing is possible or not?

3)What APIS is need to use