March 30, 2012 at 1:54 pm
I want to see all parts of some of the exsiting sql server reporting services 2008 r2 ssrs reports since I need to write some on my own for the first time. I want to look at some exsiting reports for an example. The notes I found from a previous co-worker said I should go to the company's intranet reproting services website to open an existing folder and then open the file using report builder 3.0.
However from what I have seen on the internet, if I want to everything that is on a particular report, I need to open the rdl using the Business Intelligence development studio.
Thus my question is if all the ssrs 2208 r2 code is on the ssrs reporting server, how to I use my business intelligent studio 2008 to open all the code on the reporting server? Do I open this as file, or website, solution file or what? How should I open the http site?
Can you tell me and/or point me to a reference that will give me that information?
March 30, 2012 at 2:37 pm
When you deploy your RDL, it imports the code into the database on SQL server.
You can extract the RDL from there (see this article: http://jasonbrimhall.info/2011/11/29/ssrs-export-part-2-export-data-source/ )
It is easiest to see all of the components of a report by loading the RDL into a BIDS project.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
April 1, 2012 at 2:59 pm
thanks!
April 2, 2012 at 7:36 am
You're welcome.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply