Avatar of Clifton Bardwell
Clifton Bardwell
Flag for United States of America asked on

Finding a Legacy Report

I've taken over for another developer.  Unfortunately he left in such a hurry, he was not able to pass back a whole lot of info about what he had done and what he was working on.

One of the things he did, it seems, was to create using technologies just to say he used those technologies.  One of these is SSRS.  Most reports currently used are Crystal Reports, but there are a couple that were created using SSRS.  Unfortunately, at least one of these needs to be modified.  Fine.  I took a three day course in SSRS back in 2004.  It was similar (sort of) to Crystal, and I don't think it's changed that much.  :-)  

Unfortunately the one problem I have is where to find the report file (the "rpt" file, if it were Crystal Reports).  Our network is pretty vast, but there are not too many places where it may be, but I need to know what to search for.

Any help?

TIA
SSRS

Avatar of undefined
Last Comment
dsacker

8/22/2022 - Mon
Jim Horn

Was the SSRS report deployed to a SSRS server, where the path is known?  If yes you should be able to access it.  Any version control software such as Team Foundation?

In my opinion if you are experienced in Crystal, then SSRS should be a pretty manageable learning curve.
dsacker

They are stored in the database. If they are stored somewhere in RDL files, it's because someone manually downloaded them. However, you'll be working them in Report Builder.

Verify if you have a web interface that can be used to access them.

Try going to http://<yourdbserver>/Reports
Clifton Bardwell

ASKER
Unfortunately the http://<yourdbserver>/Reports gave a 404 error.

I understand that the reports are usually kept internal.  I seem to remember something about that from the course back in 2004.  :-)

I'm thinking I'm going to need a bit of hand holding.  Is there any tutorial available that will show how to retrieve the reports (maybe via Visual Studio)?

Thanks.
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
dsacker

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Clifton Bardwell

ASKER
Yeah, I got that.  ;-)
Clifton Bardwell

ASKER
Thanks.  :-)
dsacker

Very welcome.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.