I noticed today that it appears the format of the date in a select value causes the report to run significantly slower. Normally, I enter a date value as 11/01/2011 However, today I entered a date as 11/1/2011. The report took a long time to return data. I changed the date to 11/01/2011 and the date was returned within seconds.
I tested with a few other reports and noted the same performance issue when using the xx/x/xxxx date format.
I am curious if anyone else can duplicate this issue in SL2011.
For Example:
Try report: 40.740.00 Sales Orders by Order No
Options: Include Closed Orders
Select:
soheader.orddate equals 11/01/2011 (or a date with data)
then try the same report but change the date to 11/1/2011
Database size: 40+GB