Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum
Suggested answer

Ordering and Filtering data within Word Templates

Posted on by 60

Hi,

Using the Word Templates is it possible to order and filter data?

If not, what alternative solutions are there?

For example, we have a list of items that contain a data and we want the items to be displayed in a table ordered by date descending. Is this possible?

The filtering example, is that we have a list of items with a type against them, e.g. hardware, software and support. In our template we want 3 tables to display the items per type. How can we filter the data to achieve this?

Thanks

Tom

  • LuHao Profile Picture
    LuHao 40,844 on at
    RE: Ordering and Filtering data within Word Templates

    Hi Tom2015,

    Sorry, sorting and filtering of data in Word templates is currently not supported.

    I recommend that you use Report or SSRS Reports to complete it.

    You could refer to this article for Report, and this article for SSS Reports.

    76581.Capture.JPG

    You could  save it as Word and download it locally, or print it directly.

    Hope this helps.

    Best Regards,

    Lu Hao

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 20,973 Super User on at
    RE: Ordering and Filtering data within Word Templates

    Hi Tom2015,

    Consider using a SQL Server Reporting Services (SSRS) report instead of a Word Template for this task.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,835 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,526 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans