Skip to Content
Former Member
Nov 07, 2008 at 04:52 PM

CR 8.5 passing a date from SQL to CR


I have a Stored Procedure in SQL 2005 that returns a date in this format 11/07/2008.

SQL was returning 2008-11-07 00:00:00.000 but I converted the field to the above format.

In the report when I'm prompted for the date I can enter a date and a time.

At this point the report returns no records.

I'm suspicious it's a date\Time issue.

Do I have to create a start and end date to give CR a range?

Is there a way to pass just the date and have CR return everything for that date?

I'm not sure what I need to be passing to CR.

Any help would be apprecitated...