July 22, 2008 at 7:36 am
Hello friends,
We have all the reports deployed at certain places called dashboard. Now most of them created by our team and we save it to particular location so that we can work in future if there is any changes required. Some of the contractor worked in our company and created some reports and we are not sure where they saved it. We have it working on dashboard but need to find out where is the actual copy of that report on server.
We cant find it. I tried to search but there are 2 versions and i am not getting the latest version. Any idea how to find out location of actual reports? I can download rdl file where it is deployed but i need report with all detail so that i can redeploy it.
thanks.
July 23, 2008 at 8:08 am
If you can you locate the report in the report manager website. Click on the report and then on properties and then click on Edit under report definition. You need to be a content manager to see the edit option. When you click on edit, it will ask you to save the report definition to a file.
Good luck
Chandra
July 24, 2008 at 3:21 am
Hi,
I already tried that but it will only give rdl file and i can find out data source. Data source will tell about stored procedure used and any query. But i need to know source of project file. Actual project location.
Thanks for your reply.
July 24, 2008 at 6:10 am
The report project file will have an extension of .rptproj. You might try doing a wildcard search for the *.rptproj
MG
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
Tony Hoare
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
July 24, 2008 at 2:32 pm
Actually, if you already have downloaded the rdl from the production report site you are more than half way there. The rdl will contain the definition of all the datasets used in the report. Some data source information is in there as well (level of detail depends on what type of data source) - for instance if it uses a shared data source it will have the name of that data source and it's DataSourceID from the production server. That should be of some help.
Happy hunting.
Eric
July 25, 2008 at 7:31 am
Yes, its the .rdl file that will point you to the correct stored procedure. Open it in VS, and click on the Data tab.
July 28, 2008 at 12:17 pm
If you aren't using source control, I would look into it asap. It will prevent issues like this from occurring in the future. If your company does not have the budget for TFS or VSS, then use Subversion. It's very popular and from my limited use works very well. At that point you just need to find a server to hold the application.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply