none
rsItemNotFound When try to open a report.

    Question

  • We have a bunch of reports deployed on SSRS 2008 r2. These are accessed through a browser normally.

    We also have a VB Application - through which some of the above reports are accessed using WebBrowser.Navigate(string)

    The report I'm trying to access is a report that contains a whole bunch of sub reports. the main report simply takes and passes the parameters to sub reports.

    I have a report I'm accessing currently through this vb application. It's named  1190_Marketing_Detail.rdl

    and it takes branch location as parameter.

    Below is the string I'm passing and it works.  The same string/url I place in the browser address bar, I get the report.

    If I remove the parameter LocationID=40 I get an appropriate error message similar to the first bullet point below.

    "http://reports.organization.net/ReportServer/Pages/ReportViewer.aspx?/APA/1190_Marketing_detail&LocationID=40&rs:Command=render&rc:Parameters=false&rc:Toolbar=false"

    Now I'm trying to access another report(the one that has sub reports as I mentioned above) It's named simply 1190.rdl

    and it takes a bunch of parameters.  However, right now I'm not passing any parameters. Below is the string I'm passing

    "http://reports.organization.net/ReportServer/Pages/ReportViewer.aspx?/APA/1190&rs:Command=render&rc:Parameters=false&rc:Toolbar=false"

    I'm expecting error message like below

    • This report requires a default or user-defined value for the report parameter 'LocationID'. To run or subscribe to this report, you must provide a parameter value.

    But I get this instead

    • The item '/APA/1190' cannot be found. (rsItemNotFound) 

    1190.rdl is there.  I'm not sure why reporting services doesn't see it.  Thanks in advance for your help.



    • Edited by BRKUMAR Thursday, August 14, 2014 4:56 AM
    Thursday, August 14, 2014 4:52 AM

Answers

  • I'm working with the stuff someone else did.

    When I navigated to APA folder, I realized that this folder contains links to actual folder where the report is deployed to.

    When I changed the path to deployed location it worked.

    Thanks for your help

    • Marked as answer by BRKUMAR Thursday, August 14, 2014 2:56 PM
    Thursday, August 14, 2014 2:56 PM

All replies

  • When you navigate to the report in the APA folder using report manager, as it's listed there, does it have the ".rdl" extension in the name? If so you'll have to reference it in your URL.  Otherwise, you might try renaming the report temporarily to see if something odd isn't going on in the back end. 

    You might also verify the permissions on the report and make sure no one broke inheritance or something and removed permissions.  It's also possible the account accessing the report doesn't have access to one of the sub reports.

    • Proposed as answer by JJordheim Thursday, August 14, 2014 3:21 PM
    Thursday, August 14, 2014 12:58 PM
  • I'm working with the stuff someone else did.

    When I navigated to APA folder, I realized that this folder contains links to actual folder where the report is deployed to.

    When I changed the path to deployed location it worked.

    Thanks for your help

    • Marked as answer by BRKUMAR Thursday, August 14, 2014 2:56 PM
    Thursday, August 14, 2014 2:56 PM