Page 1 of 1

ParameterRR on SQL

Posted: Tue Jun 29, 2004 8:48 am
by 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__

=> RE: ParameterRR on SQL

Posted: Tue Jun 29, 2004 7:47 pm
by 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

==> RE: ParameterRR on SQL

Posted: Wed Jun 30, 2004 6:21 am
by 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.____

===> RE: ParameterRR on SQL

Posted: Wed Jun 30, 2004 7:52 am
by kfleming
You can create a parameteRR field whose datatype is datetime.____Kathleen__R&R Support