I am trying to use a .qry file created from an SQL statement as the datasource for a Crystal 8.5 report and then pass it a parameter to only select rows where a date field year is what is selected. When I create a .qry file from SQL Designer, it always converts my date fields to strings and then doesn't let me cdate them in CR back to do my year selection. Has anyone had this problem and come up with a solution?
(You can replicate the problem with the Xtreme Sample Database - just use SQL Designer and create a new qry on the Orders table selecting order.date. It saves the column as String 22, not datetime.)
Any help would be greatly appreciated.
thanks,
Jack
(You can replicate the problem with the Xtreme Sample Database - just use SQL Designer and create a new qry on the Orders table selecting order.date. It saves the column as String 22, not datetime.)
Any help would be greatly appreciated.
thanks,
Jack