Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Date format in ROI Sel...
Microsoft Dynamics SL (Archived)

Date format in ROI Select criteria affect performance of report

(0) ShareShare
ReportReport
Posted on by Steve Wier 940

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

 

 

*This post is locked for comments

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: Date format in ROI Select criteria affect performance of report

    Hi Steve,

    I see you you are using the RTM version of SL 2011.  Since that was released, there have been many hot-fixes and a service pack.  I would recommend making a test copy of your system and application database.  Apply the hot-fix that you can download from knowledge base article 2669730.  Then test and see if the situation improves.  Let me know how it goes.

  • Steve Wier Profile Picture
    Steve Wier 940 on at
    Re: Date format in ROI Select criteria affect performance of report

    Carolyn,

    8.00.20321.00

    Steve

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: Date format in ROI Select criteria affect performance of report

    Hi Steve,

    No I only have the demo database for use in testing.  There are some hot-fixes which include a new ROI.exe.  What version of SL 2011 are you using.  Can you send me the complete version information from your Help | About Microsoft Dynamics SL screen?

  • Steve Wier Profile Picture
    Steve Wier 940 on at
    Re: Date format in ROI Select criteria affect performance of report

    Carolyn,

    Did you happen to try it on a large database?

    Steve

  • Carolyn Kolpien Profile Picture
    Carolyn Kolpien on at
    Re: Date format in ROI Select criteria affect performance of report

    Hello Steve,

    I tried your steps on several reports in AR and AP as well as the Sales Order report and I noticed no difference in performance with the date format on the Select tab.  I'm testing on the demo database.  Do you have a demo database on which to perform an additional test?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans