• Release History
  • Documentation
  • Back to www.mscrm-addons.com
  • Release History
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/Template Designer(DCP)/How to sort data in DocumentsCorePack with the Relationship Designer

How to sort data in DocumentsCorePack with the Relationship Designer

735 views 1 Updated on September 12, 2023

This blog article outlines how to sort data in DocumentsCorePack templates by using the Relationship Designer. This tool allows you to sort your data individually.

Step-by-step description

Step 1: Open Microsoft Word and navigate to www.mscrm-addons.com. Next, click on the Insert MailMerge Fields button and prepare the data you want to sort, e.g. like in the example below.

Data you want to sort
Figure 1: Data you want to sort

Step 2: Next, navigate to the ❶ Additional tab on the right side. Select the data table you want to sort – in this case, ❷ Contact (table1) and click the ❸ Edit button.

Additional template settings
Figure 2: Additional template settings

Step 3: The Relationship Designer window opens, and you can define how you want to sort your data by adding the respective fields you want to sort by (see Figure 3)❶.

The sorting priority is automatically determined by the ❷ order in the list (Prior to v10.45 of the Template Designer it was defined by an integer value). All sorting entries at any level are consistently displayed and can be ❸ rearranged with the up and down arrows and deleted with the minus sign.

Note: If you are using fields from related records the respective sorting field can only be edited within the ❹ correct relationship context.

New sorting element
Figure 3: Defining the sort order for retrieving related records

Please note: This function will sort all records before these are merged. After saving your template and merging it with Dynamics 365 data, the table should look like below.

Result of sorting data with DCP Relationship Designer
Figure 4: Resulting table with rows sorted as defined via the  Relationship Designer

It is also possible to sort grouped tables.  For more information about how to group tables in DocumantsCorePack templates, please look at this blog article.

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.

Was this helpful?

1 Yes  No
Related Articles
  • Sample Templates 
  • Step-by-Step: How to create an account sales report template
  • Step-by-Step: How to create a NDA-contract template 
  • Step-by-Step: How to create a work order template
  • Step-by-Step: How to create a quote template 
  • Step-by-Step: How to create an initial contact template for a lead
Latest Articles
  • Sample Templates 
  • Step-by-Step: How to create an account sales report template
  • Step-by-Step: How to create a NDA-contract template 
  • Step-by-Step: How to create a work order template
  • Step-by-Step: How to create a quote template 
Popular Articles
  • DocumentsCorePack Template Designer – Getting Started
  • Step-by-Step: How to configure a One-Click-Action
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • DocumentsCorePack Online Service Configuration
Top Rated Articles
  • “Undefined”-labels in Chrome and Edge 114 and higher
  • IMPORTANT information for Dynamics 365 online customers using DocumentsCorePack and/or AttachmentExtractor
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • Step-by-Step: How to configure a One-Click-Action
  • How licenses are counted
Categories
  • *News and General Infos* 52
  • Webinars 37
  • Template Designer(DCP 192
  • DocumentsCorePack(DCP 204
  • TelephoneIntegration (TI 65
  • AttachmentExtractor (AE 64
  • PowerSearch (PS 48
  • ActivityTools (AT 59
  • SmartBar (SB 53
  • GroupCalendar (GC 46
Our Vision

“We see it as our purpose to provide products that simplify and speed up our customers’ Microsoft Dynamics 365 experience.”

Knowledgebase
LogIn
mscrm-addons.com
  • Products
  • Online Shop
  • Downloads
  • My Account
About Us
  • About Us
  • Case Studies
  • Newsletter
  • Partner Program
  • Contact
Support
  • Support
  • Terms & Conditions
  • Documentation
  • Webinars
  • Legal Documents
  • Impressum
  • © 2022 www.mscrm-addons.com. All Rights Reserved.