web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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 962

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

I have the same question (0)
  • 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?

  • Steve Wier Profile Picture
    Steve Wier 962 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

    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 962 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,

    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.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans