Monday, March 12, 2012

How to deploy reports from my pc to my client's server?

Hi Guys,

I am using MS Visual Studio .Net 2003 to design reports from the data in MS SQL Server.

I have no problem to deploy, view or run the reports in my pc with MS SQL Reporting Services installed.

Now, my client's server with MS SQL Reporting Services only installed, but no MS Visual Studio installed.

How to deploy all my reports in my pc into my client's server so that user can view the reports in the server thru IE?

Thanks.

Yes, you can upload the .RDL file into Server.

You need to open http://<servername>/Reports page and press Upload File Button on the command bar. Then you can browse for your .RDL files (files that are copied from your home computer) and after you upload these reports to your server you may consider to change the Data Source.

For changing the Data Source you must open the report and go to the Properties Tab, than select Data Sources. You can choose from Shared Data source or Custom Data source, after you make your selection you need to press Apply button (on the bottom of the page).

Good luck.

|||

Thanks for your reply.

Just manage to get the server up.

But when I open http://<servername>/Reports I can't see any Upload File Button. I got only "Home | My Subscriptions | Help" on right top corner.


|||

Hi,

#1. go to Control Panel->Administrative Tools -> IIS , open Internet Information Services.

#2. Double click your server name-> goto web sites-> Default WebSite

#3. right click on report server goto directory security tab click edit button and deselect the anonymous acces check box.

do the step 3 for "Reports" also,.

and go to http://<servername>/Reports ull be able to see the upload button now.

Hope this solves your problem.

|||Yupe.. I see it now.. Thanks to both PFerns and Pavel Cristian Gabriel!

No comments:

Post a Comment