Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

AnnieRider (MIS) (OP)
11 Sep 09 6:46
Hi

I had a report on my local drive which had uploaded in the Report Viewer. I have since mistakenly deleted the report of my local drive and want to find it on the Reports server so that I can take a copy back.

I can run the report in our web application and can see it's entry in dbo.Catalog but cannot find the report stored anywhere!

Is it actually physically stored anywhere?  If not is there anyway I can get to the coding so that I do not have to start again from scratch?


Many Thanks
Annie
mrdenny (Programmer)
11 Sep 09 6:48
The RDL files are loaded into the database, and stored as rows in the tables.  If you connect to the report server with SSMS you should be able to export the report back out.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)

My Blog

AnnieRider (MIS) (OP)
11 Sep 09 6:55
Hi

Thanks for your reply, I am new to SSRS and am not sure how to do that, could I possibly trouble you for some help with instructions?

Kind Regards
Annie
hencyt (MIS)
11 Sep 09 11:18
Annie -

You didn't say which version of SRS you have. If you have 2008, the easiest way I know of is to go to the reports website, find the original deployment folder (make sure you have chosen 'show details'), click on the icon under the 'Edit' column to the left of the report you need. On the next screen under the General 'tab' on the options on the left, there is a section on that page called "report definition"; if you click Edit under that it will ask you where you want to save the report.

This is a new option in 2008 though so if you have 2005 this won't work.

Good Luck!
Sunny
bburnell (Programmer)
11 Sep 09 13:55
In 2005, the edit button is under the properties tab of the report.

--------------------------
Web/.net Programmer & DBA
Central PA

AnnieRider (MIS) (OP)
14 Sep 09 2:54
Thanks ever so much all of you, I have 2005 and have found it easily now thanks to your posts.

Kind Regards
Annie smile

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close