Post reply

Report Locations

  • June 16, 2010 at 8:12 am

    #233898

    Hi

    I am new to a company and i am required to makes some changes to some ssrs reports that are shown on a sharepoint site.

    I cant find the reports anywhere. I have the url, both the webserver and the database server names.

    Have you any idea where i could look? or what i could do to find them?

    thanks in advance

  • June 16, 2010 at 11:41 am

    #1181198

    Hi,

    You have mentioned you have URL , is it the report server URL ? Do you know the report server database ? If so can you try the below code in that database, this will tell you the path of the report and the name in the Report server.

    select Path,Name from Catalog where Type = 2

    Am I correct ? or understood your question wrongly ?

    Thanks & Regards,
    MC

  • June 17, 2010 at 4:27 am

    #1181446

    hi

    yes it looks like you understood the question

    the code gives the error - invalid object name catalogue

    Thanks again

  • June 17, 2010 at 4:34 am

    #1181449

    dunne.neal (6/17/2010)

    hi

    yes it looks like you understood the question

    the code gives the error - invalid object name catalogue

    Thanks again

    The code you were given works if executed in the correct database. Try this: -

    SELECT PATH,

    name

    FROM reportserver.dbo.catalog

    WHERE content IS NOT NULL

    AND TYPE = 2

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • June 17, 2010 at 4:43 am

    #1181450

    Hi

    Thanks i was looking in the wrong database.

    The path gives me the URL, what i really need is the windows path

    is this posible?

    thanks again

  • June 17, 2010 at 5:03 am

    #1181459

    Hi

    Sorry maybe there is another way to do what i need to do.

    I just need to be able to edit the reports, i have the path for them all now but im still not sure how to open them to edit them.

    sorry if my questions are basic.

    Thanks a lot

  • June 17, 2010 at 5:08 am

    #1181464

    Open the report in BIDS (SQL Server Business Intelligence Development Studio).

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • June 17, 2010 at 5:18 am

    #1181470

    Hi

    I have opened BIDs and then gone to file > open > file and when i paste the url in the open filed it just opens a page that looks a bit like xml in a text file.

    again sorry if my questions are very basic but how do i open the report in bids from my URL?

    Thanks

  • June 17, 2010 at 5:33 am

    #1181476

    You need the report files with .rdl extension in order to edit the report in BIDS (which will provide better UI enabled editing)....

    Prashant Bhatt
    Sr Engineer - Application Programming

  • June 17, 2010 at 6:47 am

    #1181517

    thanks

  • June 17, 2010 at 6:55 am

    #1181522

    When you're using Native deployment method you can go into properties and choose Report Definition "EDIT". That let's you save the RDL. I would think there is something similar within SharePoint mode.

  • June 17, 2010 at 8:14 am

    #1181585

    where do i go into report definition?

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply