October 10, 2008 at 6:29 am
Hi All,
Is it possible to upload multiple reports in a single folder in a single go.
Regards,
[font="Verdana"]Sqlfrenzy[/font]
October 10, 2008 at 7:05 am
October 10, 2008 at 2:17 pm
Luke L (10/10/2008)
Yes, I do this all the time with visual studio. You can either deploy your entire project, or use cntl+click to select the reports you want to deploy then right click and choose deploy.-Luke.
Can u give me script....or a help me write one...
Regards,
[font="Verdana"]Sqlfrenzy[/font]
October 10, 2008 at 2:23 pm
no script is needed, inside of VS just select the reports you want to deploy, right click and deploy them.
If you want to do it in a script you can make use of the scripts that would work with rs.exe There is a decent sample in the C:\Program Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples directory called PublishSampleReports.rss
-Luke.
October 10, 2008 at 2:31 pm
Luke L (10/10/2008)
no script is needed, inside of VS just select the reports you want to deploy, right click and deploy them.-Luke.
Does this method can be used to deploy reports to a remote server....
Regards,
[font="Verdana"]Sqlfrenzy[/font]
October 14, 2008 at 9:27 am
sorry about the delay I was out of the office for a few days.
Yes. I deploy reports from my workstation to my report server in another building. As long as you have connectivity you should be able to deploy them.
If that doesn't work for you, you could look into using rs.exe and the script samples that you can download from MS to deploy reports without Visual Studio or BIDS.
-Luke.
October 15, 2008 at 4:38 am
Luke L (10/14/2008)
sorry about the delay I was out of the office for a few days.Yes. I deploy reports from my workstation to my report server in another building. As long as you have connectivity you should be able to deploy them.
If that doesn't work for you, you could look into using rs.exe and the script samples that you can download from MS to deploy reports without Visual Studio or BIDS.
-Luke.
Thnks luke....I was able to add the reports...However...I have to set the database for each and every report separately on the report server.....
Is there a way to do the same at once
Regards,
[font="Verdana"]Sqlfrenzy[/font]
October 15, 2008 at 5:22 am
Use shared datasource for all reports. For better organizing.
October 15, 2008 at 6:19 am
Kishore.P (10/15/2008)
Use shared datasource for all reports. For better organizing.
I am using shared database ... I had to assign shared database to each report manualy...Is there a way to do it automaticaly....
Regards,
[font="Verdana"]Sqlfrenzy[/font]
October 15, 2008 at 6:21 am
Exactly, If you setup a shared datasource in your Report Project/Solution you can point all of your reports to that datasource. Then just publish the datasource with the reports.
Additionally If you have numerous Report projects contained within the same solution as long as you point the datasources folder in each project to the same datasources folder you can copy the datasource to each of your projects and have all of the reports use the same one.
-Luke.
October 15, 2008 at 12:30 pm
Luke L (10/15/2008)
Exactly, If you setup a shared datasource in your Report Project/Solution you can point all of your reports to that datasource. Then just publish the datasource with the reports.Additionally If you have numerous Report projects contained within the same solution as long as you point the datasources folder in each project to the same datasources folder you can copy the datasource to each of your projects and have all of the reports use the same one.
-Luke.
This is exactly the same what I am doing....but I have to assign the shared datasource manualy to each report after deploying them to the remote report server.....Is there a way to do this automaticaly.....
Regards,
[font="Verdana"]Sqlfrenzy[/font]
October 15, 2008 at 1:40 pm
You need to copy the datasource to each one of your project's datasource folder, but in the project properties make sure they all point back to http://servername/resportserver/datasources or something like that so they all reside in the same place on the reportserver itself. The reports will then all be looking for the same datasource in the same place once they are deployed.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply