Reporting 2008 R2, SharePoint and drilldown

As most of you probably know in SQL Server 2008 SSRS integrated in SharePoint we had a most annoying bug. When you want to add a drilldown action to another report when using SharePoint you had to add the entire URL to the action. As can be seen in this BOL article: http://msdn.microsoft.com/en-us/library/ms159847.aspx

The list of report names includes all reports in the current report server project. If the drillthrough report is on the report server but is not in the project, type the name of the report. The report name can contain a relative path from this report or an absolute path to the report on the server. An example of a relative path is …DrillthroughReportStore. An example of an absolute path is SalesReportsDrillthroughReportStore.

On a report server configured in native mode, specify a drilthrough report name without the file extension .rdl.

On a report server configured in SharePoint integrated mode, you must specify the report name in an expression and include the file extension .rdl. For example, =”http://site/subsite/Documents/DrillthroughReport.rdl”.

When i read the what is new in Reporting services 2008 R2 i noticed this sentence:

When working with reports on a SharePoint server integrated with reporting services, subscriptions and drill-through links will now work directly with the linked resources in the document library itself.

When i got home I immediately decided to check it out, and it worked 🙂 So now it you can just add the filename and it works. I noticed something else as well:

They finally embedded the return to previous page in the control as well ! yeahhh.

Two small but great changes who will make my life a little easier 🙂

  • Vinay

    Hi,

    I tried the same options in my reports as well which is in sharepoint integrated mode.

    It works, but when you try to access the drill down for the 2nd time without refreshing the report then I am getting the following AJAX error.

    Webpage error details

    User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; MS-RTC LM 8)
    Timestamp: Fri, 13 Jul 2012 07:40:32 UTC

    Message: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by calls to Response.Write(), response filters, HttpModules, or server trace is enabled.
    Details: Error parsing near ‘
    <!DOCTYPE html PUB'.
    Line: 5
    Char: 62099
    Code: 0
    URI: http://blr2k8plcor08/ScriptResource.axd?d=rL57K1OHcpgT2MWYhS5xxBrT1BFSD3SBuY7p9VI-WdYZhOEimY4iU0mz5ScDklPyMQ7VkqUyIQfERMuLpbXr3ru5s7eY_nYBimP-50GIkU7ZEZEQma4WAm7-YO2qdzWKRKGvv7mvo8WnrzWeJC3WAGe0wgo1&t=fffffffff9d85fa6

    Any idea how to solve this issue?

    Thanks,
    Vinay