Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I have to create a report which uses "From Date" and "To Date" as dynamic values from user. For achieving this I have created two parameters of Date/Time type in ssrs report and added the following filter in fetchxml:
<filter type="and"> <condition attribute="date" operator="on-or-after" value="@CRM_FromDate" /> <condition attribute="date" operator="on-or-before" value="@CRM_ToDate" /> </filter>
This works fine on visual studio but the .rdl file uploaded in crm throws an error: The expected parameter has not been supplied for the report. The error shows up even before prompting for the "From Date" and "To Date"
There is no security role issue, as I've logged in as administrator neither do I have multiple Datasets to focus on their order.
Any help would be appreciated.
Have you specified default values for each parameter ? If not, try applying default values.
Something else to consider is that FetchXml expects dates to be provided in YYYY-MM-DD format, and SSRS may not do that by default. The date formatting in SSRS may differ by user, and this will be different in Visual Studio compared to the server. It may be necessary to use an expression to get the date in the correct format
Could you please tell me whether you are using pre-filtering or not?
Yes, I am using pre-filtering
Do you have two data source? or just a single one?
I tried assigning default value by specifying the following: =Format(Parameters!CRM_ParameterName.Value, "0000-00-00 00:00:00")
It gives me the following error : The DefaultValue expression for the report parameter contains an error. The expression references a parameter which does not exist in Parameters collection.
The parameter does exist in the collection and I also crosschecked if it uses the correct case.
I have a single data source.
Can you please share your .rdl file. I am having not sure why you are using pre-filtering?
There is an associated entity, that is the reason why I'm using pre-filtering. The parameter checks the date value from the associated entity's date field.
Business Applications communities