Hi folks,
We have had a subscription running on a weekly basis but this week it has failed to run
When I have gone into the report itself and attempted to run the report, I was met with the message that the value provider cannot be converted to this type.
Now I assume this in reference to the parameters which are start date and start date1
The expression for the former is =DateAdd(DateInterval.Day, -6,DateAdd(DateInterval.Day, 1-Weekday(today),Today))
The expression for the latter is =DateAdd(DateInterval.Day, -0,DateAdd(DateInterval.Day, 1-Weekday(today),Today))
Simply put we are capturing the previous week's data.
This is the error message in it's entirety; "Semantic query compilation failed: e InvalidParameterValueType The data type of the parameter "Booking Start Date1" is DateTime. However, the value provided for the parameter cannot be converted to this type. (SemanticQuery ''). (rsSemanticQueryEngineError)
Thanks in advance
----------------------------