I came accross an issue recently, I created a SSRS Report from scratch and set the locationisation to en-GB which displays the dates etc in a dd/mm/yyyy format. This presented me with a problem, when connecting to a crm online server it likes the format to be in utc so when I passed 01/08/2011 (1st August 2011) it thought i was passing 08/01/2011 (8th January 2011).
The solution it seems was to edit the rdl file in notepad and change the query parameter, which once I found out where/how was a 10 second job.
The steps were:
Find the location of the Report in question
Right click on the report and select Open with
Choose Notepad
Do a find for <QUeryParamater>
Original Code:<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
New Code:<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Format(Parameters!StartDate.Value,"MM-dd-yyyy")</Value>
</QueryParameter>
Notice the change in the Value, this simply formats the value into a mm-dd-yyyy format and then your away.
Enjoy
