Link to home
Start Free TrialLog in
Avatar of Clifton Bardwell
Clifton BardwellFlag 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
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

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.
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
Avatar of 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.
ASKER CERTIFIED SOLUTION
Avatar of dsacker
dsacker
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yeah, I got that.  ;-)
Thanks.  :-)
Very welcome.