converting dates in parameters

[hambo12]

I have managed to get a simple report from a Progress Openedge database connected to SQL reporting services.

The report uses an un-named parameter to select the date.
However, progress formats their dates as MM/dd/yyyy.
SQL reporting services parameter uses dd/MM/yyyy as the format to select the date. Therefore, the report returns an error when I select a date from the parameter calendar. This is the error:

An error occurred during local report processing.
The value provided for the report parameter 'Parameter1' is not valid for its type.


The only way I can get the report to work is to manually enter the date format in MM/dd/yyyy.

Is there any way to fix this issue? Can I change the format of the date when it is selected in the parameter?

 

[markros]

Check

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/setting-a-standard-dateformat-for-sql-se

 

[hambo12]

Im not sure how to use this. I cant run those queries on a progress database, and I have no sql DB to run this against...

 

[markros]

I see, I don't know then, sorry.

 

[hambo12]

thanks for the help anyway

 

[hambo12]

Further to this:

I have tried the following in the parameter tab in the dataset:

=format(Parameters!Parameter1.Value, "dd/MM/yyyy")

However when I try to run the report, I get this:

An error occurred during local report processing.
The value provided for the report parameter 'Parameter1' is not valid for its type.

I then try to change the parameter data type to "String" and re-run the report and enter the dd/MM/yyyy date. i get the following error:

"Attempted to read or write protected memory. This is often an indication that other memory is corrupt".


Also,I can run the query in the Query analyser in the Data tab, and input the dd/MM/yyyy format, and the results display fine. However, when I run the report in the preview tab, the report fails.

Any ideas?