dcsimg
Results 1 to 4 of 4

Thread: find report vs solution file

  1. #1
    Join Date
    Oct 2008
    Posts
    17

    find report vs solution file

    Hi,
    I am trying to debug a report. I can access report in Report Manager and know what needs fixed. My problem is finding the Visual Studio solution which created the report. This is an old report I did not work on and there are multiple versions. I used windows Search, but the report may be named differently.
    How can I find where a report was originally created?
    Thanks

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    A couple of ideas ...

    You can look at the Properties (where you can get the name of the .rdl file, the creation date and the creator username), and then search on the .rdl file around that time frame.

    If you can't locate the original, and you simply need to modify the existing report, click Edit on the Properties page for the report in report manager, and you can download the file via "Save," and then re-enter it in the BI Development Studio, do your mods, and then re-deploy.

    Get back to us with any further questions ...

    Bill

  3. #3
    Join Date
    Oct 2008
    Posts
    17
    I couldn't see any Edit button - These reports are in Reporting Services 2000.

    I found a query on the web to retrieve the sourcecode from SQL Server. Here is query incase any-one else has same issue (I made slight modification to original query)

    SELECT Path, Name
    ,SourceCode = CAST(CAST(content AS VARBINARY(max)) AS varchar(max))
    FROM ReportServer.dbo.Catalog
    WHERE Type IN (2,6,3) and
    ([path]= 'xx' or [name]like '%xxx%')
    ORDER BY Path, Type, Name

    Since varchar(max) wasn't available in SQL Server 2000, I had to backup and restore ReportServer db to a SQL Server 2005, first.

    I then modified report sourcecode and uploaded it.

  4. #4
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607

    Great!

    And thanks for pointing out this approach! Can't get it much more direct than from the catalog, can you?

    Bill

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •