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 🙂