Converting Crystal Report from IBM server to Microsoft Server

Question

I have a Crystal report that is currently connected to a IBM database ODBC. I have to convert the report connection to a Microsoft SQL connection. I have mapped the fields and tried to run the report and I get an error message " A string is required" and the Record Selection Formula Editor opens and highlights the two formula Fields: Begin Date to number and End Date to number

{PPHRTRX.DATE_PERFORMED} in {@Begin Date to number} to {@End Date to number}

The formula for these fields are: tonumber(ToText ({?Begin Date},"yyyyMMdd" )) tonumber(ToText ({?End Date},"yyyyMMdd" ))

The Parameter Fields type is: Date The list of Values: Static enter image description here

I am new to Crystal and not sure what I need to change to correct this issue.

question from:https://stackoverflow.com/questions/65852652/converting-crystal-report-from-ibm-server-to-microsoft-server

Answer 1

Waitting for answers