swaggrK
asked on
Deploy SSRS Report
I've created an SSRS report using Visual Studio 2005.
I now need to deploy the report as HTML so that our Marketing Department can view it.
I am not sure of the steps to make it viewable to them.
There are only two members in the marketing department and I am not sure how I make the link accessible to them as well as how I ensure that only those two individuals can run it.
I now need to deploy the report as HTML so that our Marketing Department can view it.
I am not sure of the steps to make it viewable to them.
There are only two members in the marketing department and I am not sure how I make the link accessible to them as well as how I ensure that only those two individuals can run it.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Basically, you need to deploy (push) the report to SSRS from Visual Studio and then perhaps setup security to the 2 marketing people to be able to execute the report from their browser.
A quick look at the Visual Studio Solution Explorer, top right, right click and properties of the highest level in the heirarchy will show you the settings that this reprot is set up for publishing.
If the values there are filled in with Http:'s then that is "most likely" the place where your SSRS resides. But you need to fill in these details to actually get the rdl and datasets and data sources over to your SSRS.
It is quite involved to get from where you are to where you want to be.
I think perhaps a wee Google around deploying SQL 2005 reports would be wise.
There are fish hooks everywhere, but once you've cracked it, you should be away laughing.
Hope this helps.