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.

Drill through in Olap Cube and implement at Share Point

Hi,

I want to integrate a Olap cube to sharepoint in which we can achieve drill through and multilingual also.

Please help me out to get solution of 2 problems.

Thanks

For the OLAP cube drillthrough from SharePoint, I'm using 3rd-party OLAP Web Parts, which expose cube-defined Reporting Actions. When the user selects such an action, a Reporting Services report is launched, which executes the MDX drillthrough query (using the OLE DB for OLAP Provider) and displays tabular results. Relevant current cube co-ordinates for the drillhrough are passed as URL paramters to the report.|||Deepak,

Which 3rd party tools which expose cube actions have you had the best luck with?

Thanks,
Todd
|||

Hi Todd,

I'm using DSP Portal Edition 4.3 right now, but perhaps ProClarity for SharePoint Portal Server will also work...

Drill through in Olap Cube and implement at Share Point

Hi,

I want to integrate a Olap cube to sharepoint in which we can achieve drill through and multilingual also.

Please help me out to get solution of 2 problems.

Thanks

For the OLAP cube drillthrough from SharePoint, I'm using 3rd-party OLAP Web Parts, which expose cube-defined Reporting Actions. When the user selects such an action, a Reporting Services report is launched, which executes the MDX drillthrough query (using the OLE DB for OLAP Provider) and displays tabular results. Relevant current cube co-ordinates for the drillhrough are passed as URL paramters to the report.|||Deepak,

Which 3rd party tools which expose cube actions have you had the best luck with?

Thanks,
Todd
|||

Hi Todd,

I'm using DSP Portal Edition 4.3 right now, but perhaps ProClarity for SharePoint Portal Server will also work...