Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Date format in ROI Select criteria affect performance of report

Posted on by 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

 

 

  • 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

  • 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

  • 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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,647 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans