You’re offline. This is a read only version of the page.
Hi
I am fairly new to SSRS reporting for Dynamics CRM and i'm looking for help.
I have an issue with a report I am creating in Microsoft Sequel Server Reporting Services. I have a fetch xml created from Dynamics CRM (version 2016 update 1) which has been used in a dataset in SSRS. This has a date field in it called DOE. It is a calculated field that has a behaviour of Date Only. I have used this field to create two parameters, a start and end date. See screenshot below.
When i go to preview in SSRS it comes up with the error below.
I believe this error to be because of the date format. The DOE field seems to be coming through as MM/dd/yyyy rather than dd/MM/yyyy. I have set the report language to en-GB and i have tried numerous combinations of the FormatDateTime, CDate and Format functions on the parameter's but to no avail.
Can anyone help me fix this error? I'm going round and round in circles and not getting anywhere.
Thanks
Colin
*This post is locked for comments
I have the same question (0)
With a FetchXml query, the dates should be in the format yyyy-MM-dd - e.g. 2017-06-30
Share
Report
All responses (
Answers (
14,065
