ParameterRR on SQL

[Chris_Barnes]

We are currently in the process of rejigging all of our R&R reports to run on the SQL version of R&R10.0.____We currently use ParamRR fields to select dates, when we convert the reports and try to run them we get a "Conversion of CHAR Data Type to DATETIME" message. Is there anyway round this?____TIA____Chris__

[kfleming]

In Xbase did you have a parameteRR field that was date data type that was used in a query comparison with a database date field and now the report is converted to SQL?____Kathleen__R&R Support

[Chris_Barnes]

Hi Kathleen,____Got it in one. I suspect that because DATETIME fields in SQL Are interpreted as dd/mm/yyyy hh:mm:ss that there is a conflict between the param field and the actual data field on the SQL Server, but we^re not sure how to resolve it.____

[kfleming]

You can create a parameteRR field whose datatype is datetime.____Kathleen__R&R Support