Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 access 2008 r2 rdl

Author  Topic 

jassie
Constraint Violating Yak Guru

332 Posts

Posted - 2012-03-30 : 15:45:42
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?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-03-30 : 18:03:46
you need to export report files (with extension .rdl) to your local machine. you've export option available from report manager or by connecting to reporting engine instance from sql management studio. After exporting open a project of type reporting services and add this rdl to it. then you can open and edit report layout

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -