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
Clifton BardwellProgrammerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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.
0
dsackerContract ERP Admin/ConsultantCommented:
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
0
Clifton BardwellProgrammerAuthor Commented:
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.
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

dsackerContract ERP Admin/ConsultantCommented:
You do realize that you would substitute <yourdbserver> with your actual DB server.

Also if your database uses a named server, the format would look like:

http://YOURDBSERVER/Reports_YOURINSTANCENAME (there is an underscore between Reports_YOURINSTANCENAME)

If that doesn't bring up anything, you can go to the following links to study up on using Visual Studio:

https://msdn.microsoft.com/en-us/library/bb558708.aspx
https://www.youtube.com/watch?v=l1k37cfdd8w

There are a few others, but these are a start.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Clifton BardwellProgrammerAuthor Commented:
Yeah, I got that.  ;-)
0
Clifton BardwellProgrammerAuthor Commented:
Thanks.  :-)
0
dsackerContract ERP Admin/ConsultantCommented:
Very welcome.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.