• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 68
  • Last Modified:

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
0
Clifton Bardwell
Asked:
Clifton Bardwell
  • 3
  • 3
1 Solution
 
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
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

 
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
 
Clifton BardwellProgrammerAuthor Commented:
Yeah, I got that.  ;-)
0
 
Clifton BardwellProgrammerAuthor Commented:
Thanks.  :-)
0
 
dsackerContract ERP Admin/ConsultantCommented:
Very welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now