Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

DateTime Picker

Posted on by 200

Does anyone know how to use it in the reports ?

I need to do report similar to Daily Sales by Department where user can amend the report date, but I cant find the way of using it in actual Active Report in RMS.

Thanks in advance for any help .

*This post is locked for comments

  • Darrin Downing Profile Picture
    Darrin Downing 430 on at
    Re: DateTime Picker

    Ed Boyer

    ...and start with all the details in collapsed mode.

    How do you get a report to Start in collapsed mode. I can find no option for that.

    DDowningMO

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: DateTime Picker

    Date Time picker is related to the column type that is being filtered by.  If the column is a date type then the datetime picker will be used by the report generator.  If the column type is a string or char then datetime picker is not used.

    Some reports within RMS changes the time column to a string to do some alterations before the report is generated.

    Also the Daily Sales reports are not like any of the other reports in RMS.  They are summarized in the database and not by the report, so I would suggest that you start with the detailed sales report and use some summarization headers.  Then have the report grouped by department, or date, or whatever column you need and start with all the details in collapsed mode.

    Thanks

    Ed Boyer

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans