I have used prefiltering many times with success, but all use cases are for running an SSRS report from a form with a single record. The single record produces the report flawlessly every time.
However, I would like to use the same simple report when selecting multiple records from a sub-grid, view or Advanced Find. However, I only get the first record. Anyone out there have a fix? Here's the query:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="rsmus_clinicalcasenote" enableprefiltering="1" prefilterparametername="CRM_FilteredCCN" >
<attribute name="rsmus_clinicalcasenoteid" />
<attribute name="rsmus_name" />
<attribute name="createdon" />
<attribute name="statuscode" />
<attribute name="statecode" />
<attribute name="overriddencreatedon" />
<attribute name="rsmus_priority_clinicalcasenote" />
<attribute name="ownerid" />
<attribute name="modifiedon" />
<attribute name="modifiedonbehalfby" />
<attribute name="modifiedby" />
<attribute name="rsmus_generalclinicalnote" />
<attribute name="rsmus_date" />
<attribute name="createdonbehalfby" />
<attribute name="createdby" />
<attribute name="rsmus_category_clinicalcasenote" />
<attribute name="rsmus_case" />
<order attribute="rsmus_name" descending="false" />
<order attribute="rsmus_case" descending="false" />
<order attribute="createdon" descending="true" />
<link-entity name="incident" from="incidentid" to="rsmus_case" link-type="inner" alias="Case" >
<attribute name="rsmus_client" />
<attribute name="ownerid" />
<attribute name="statecode" />
<attribute name="rsmus_programid" />
<attribute name="statuscode" />
</link-entity>
</entity>
</fetch>
And here are the two parameters. I have gone back and forth on using the CRM_FilterText (used it; abandoned it) with the same issue: only one record returned.
Here is parameter CRM_FilteredCCN:
Default Value here is:
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"><entity name="rsmus_clinicalcasenote"><all-attributes/></entity></fetch>
Here is the parameter CRM_FilterText:
And finally here is the incredibly simple report in design surface:
Any help/advice will be much appreciated,
Dan
