I am using Crystal Reports 9.0 and have created a report with a subreport. The main report passes several paramaters to the sub-report and then runs a stored procedure. I am passing the values via Subreport linking integrated in Crystal.
My problem is that when I try to link the main report fields with the Sub-Report parameters I cannot get the date/time parameters to show up. This means that they are incompatible data/types. My main report is talking to an Access XP database and the datatypes are listed at date/time in design view of Access and the stored procedure paramters are set to datetime. Why would they not be compatible? When I look at the table structure of the Access Database in Crystal it shows the datatype as Date and the SQL as DateTime.
How do I go about fixing this situation....any help or suggestions would be greatly appreciated.