About Me - Who is DR DBA?

Hello. My name is Rudy Panigas and I am a Production Senior Microsoft SQL Server Database Administrator (DBA) with over 14 years of experience. Have published articles with SQL Central, am a leader for the my local PASS chapter in Toronto (TORPASS) and love to automate anything SQL including disaster recovery. I created this blog to share my views, knowledge and to discuss Microsoft SQL server in order to help out others in this field. Please test these scripts before using. I do not warranty and do not take any responsibility for it, its misuse or output it creates. You can reach me at this email address: sqlsurgeon@outlook.com

Friday, June 15, 2012

Convert an SSRS Report to .RDL for Editing

Hello Again,

How to copy / export an existing SSRS report for editing is a common question DBAs get asked. Here is a link that explains this easy process.

http://lukehayler.com/2010/02/download-reports-rdl-files-for-editing-4/

If the link is not available, below are the steps to take.

  1. Open SQL Server Management Studio,
  2. Log on to the Reporting Services Instance that contains the reports you are looking for
  3. Browser through the directory structure to the report that needs to be updated
  4. Right-click the report and choose Edit…
  5. Now follow the prompts to save the file to a destination of your choice
  6. Open BIDS & create a new project/solution
  7. Import the saved .rdl file into your SSRS project.
  8. Edit your content
 This process is great if you don't have the project or .rdl file but can access the report.

Thanks,

Rudy
Posted by at No comments:
Subscribe to: Posts (Atom)