Wednesday, March 7, 2012

Deploying a Report

I'm having a little bit of trouble deploying the report project I have set up. In fact, I'm not even sure that deploying the project is what I want to do. All I want is to have something so I can view the report I've created in HTML or PDF form, something that was advertised when I downloaded the reporting services. Any help with what I would need with this would be appreciated.

Deploying your reports is what you need to do, but first you need to ensure that you have an instance of Report Server to deploy to - do you have that? Once you do, you just run the report, then you can specify whether you want to export it to PDF, Excel, etc.

|||I don't think I do have that. Or, if I do, I have no idea what it is. How would I get an instance of Report Server that I can deploy to?|||

So, it would seem that you have started up a new BI project, created some reports, and now need to make them visible to everyone? In that case, you need to find out from your DBA or sys admin where reporting services is installed (usually it resides on the same server as SQLServer), if you don't have one then you can install it from your SQLServer cd. Once done, you upload your datasource to it, and deploy your reports, set any rights you want on those reports (i.e. set the security on them), then to access your reports you would use a url similar to this: http://<your report server>/Reports/<any subfolder you created>/<your report name.htm>

Of course this is a very quick summary, you will find much more detail in BoL (Books On Line) and in the MSDN help (msdn.microsoft.com) Wink

Hope that helps.

|||Yes, that definetly helps, thank you very much!

No comments:

Post a Comment