Sunday, February 19, 2012

Drillthrough problems with Reporting services in Integrated Mode

We have started to use reporting services in integrated mode with windows sharepoint. Since this installation the drillthrough reports have stopped working. We get the following error when a hyperlink is cllicked:-

  • The item 'http://vtrends/reports/IslandRegionCountryState' cannot be found. (rsItemNotFound)

    In the textbox properties we have set the 'Jump to Report' hyperlink option to use a condition. Based on the link clicked, one of two reports will be displayed. If i remove this condition and manually select the report to run then there are no problems. This however is not the functionality that is needed.

    Any help will be appreciated.

    In WSS mode, the report path is completely different. It must reference the report location in the WSS library wherethe report is deployed. See this blog for more details.
  • No comments:

    Post a Comment