Dynamics Community Forum Thread Details

SSRS Pre-filtering main report with a subreport

I have an Order main report with an embedded Order_Item sub-report. I am using Fetch-based reports in SSDT for CRM on-premise.

I want to run this report on a selected record. I added 'enableprefiltering="1"' to my XML query for the main order report. Report preview works fine separately on main and subreport, but the subreport does not show on the main report's preview. When I upload and run the report in CRM it just gets stuck on "Report is being generated". Do I need a prefilter parameter on the sub-report? Do I need to pass parameters from main to sub? Please help, thanks.

Query for Order dataset:

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
  <entity name="salesorder" enableprefiltering="1" prefilterparametername="CRM_FilteredOrder">
    <attribute name="name" />
    <attribute name="customerid" />
    <attribute name="totalamount" />

Quick Links