Unable to create a drill through or drill down report

Hi Silent_Tracker,

In SSRS, when we add a filter to a dataset, all report parts or data regions use only data that matches the filter conditions. In your case, we need not add filter for dataset2 in subreport. The step: Add the subreport below “Specify a report” is to add the subreport name we create before. We can select the subreport in the drop down list.

For this error message, there is an similar issue, you can refer to it.

http://ift.tt/MmWIUu

Since the issue is relate to Microsoft Dynamics CRM, I recommend you post the issue to the forum below:

http://ift.tt/1pgkAbZ

It is appropriate and more experts will assist you.

If you have any questions about Reporting Services, please feel free to let me know.

Regards,

Alisa Tang

---

Alisa Tang

TechNet Community Support