Date problems

[Former Member]

I am using MS SQL 2008 express as database. Date fields set to Date. when I type in my date parameters in CR I get all records. I changed the date field in CR to date. I am using MS visual studio 2010 pro.

[former_member183750 · Accepted solution]

Do the reports work in any CR Designer?

What version of CR were the reports created in?

What version are the CR assemblies in your app?

Are you using the MS SQL 2008 - SQL Native 10 client? (A requirement...)

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[former_member11696]

Format your date like this:

rpt.SetParameterValue("MyDateParm", Convert.ToDateTime(parmDate));

Don

[ido_millet]

Having a date parameter is not enough to filter the report data.  You must use that parameter in a record selection formula.