• Documentation
  • Back to www.mscrm-addons.com
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/DocumentsCorePack(DCP)/Advanced reporting with DocumentsCorePack by using Dynamic Filters

Advanced reporting with DocumentsCorePack by using Dynamic Filters

622 views 1 Updated on April 20, 2022

Dynamic Filters increase the reporting capabilities of DocumentsCorePack by allowing you to pass dynamic values into the data query when loading data into your template.
Basically, they are variables that can be passed into the data query (when resolving relationships) in DocumentsCorePack templates.

The source for these variables can be either any field (attribute) of the root table (entity) for which the template is made or a user prompt that is defined within the template.

Figure 1: A document based on a template using user prompts to filter results

To use and understand Dynamic Filters, it is recommended to have some experience with basic template creation, along with the creation of relationships, relationships filters, and also user prompts.

If you are new to DocumentsCorePack our getting started article would be recommended to gather basic knowledge around those topics.

Prerequisites:
– DocumentsCorePack Server Based 2020.105 (Version & Upgrade Info)
– DocumentsCorePack Client Based 10.25 (Download here)

The below chapters will show the different options that dynamic filters offer based on a sample
and a description of where to find this and how to add this to your templates.

We also have a recording of a webinar available covering this feature in a video presentation.

Dynamic Filters explained by an example

In our example, we have a template based on accounts with a relationship to contacts. On top, we added fields to display the account name along with the phone number of the account.❶

In addition, we added a relationship to contacts four times in the given template. The tables will show us contacts…
❷… without a dynamic filter, as reference for the other options
❸… that have the last name that I entered in the Dialog during generation
❹… that have the same phone number as the account itself
❺… that are born after a specified date

Figure 2: Template with each paragraph described

For the filters applied in example ❸ (lastname) and ❺ (born after) we need to define user prompts in our template.

Figure 3: User prompts setup in the template

We are executing this template against a record with the following record by using the Create Document button from within the account form

Figure 4: Sample Data record

After the initial step of selecting our template, we are presented with the Prompts dialog that asks for the additional user input defined in our templates.

Figure 5: Input for User Prompts in the DCP Dialog

After this, we completed the DocumentsCorePack Dialog by selecting to create a Docx document. In our result, we see the basic information of the account record ❶. as well as the data shown in Figure 6.

For the relationships we get:
❷… all contacts related to this account without any filter
❸… all contacts that have the last name that I entered in the Dialog (“Doe”)
❹… all contacts that have the same phone number as the account itself
❺… all contacts that are born after the specified data (06/30/1995)

Figure 6: Result document

How to Add/Edit a Dynamic Filter

in this section, we will not cover the general creation of relationships, relationships filters but will focus on the definition of dynamic filters.

To add a dynamic filter you have to Add/Edit a filter ❶ and Add/Edit a condition ❷ once you have opened the Condition dialog you will see an additional section called “Dynamic Filter” ❸.

Figure 7: How to add a dynamic filter to your relationship

In the drop-down in the Dynamic Filter section, you can either add fields from your root entity that can be found at the beginning of the dropdown list (see Figure 8).

Figure 8: Sample of using root field for a dynamic filter

Any Prompts that are part of your template can be found at the end of this dropdown (see Figure 9).

Figure 9: Sample of user prompts for a dynamic filter

Pleaes Note: Any attribute that is not part of your document needs to be added to the “Additional Fields” section in the advanced template settings, otherwise the parameter will not be available during the merge process.

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

Known Issues:

Testing´ templates with user prompts does not work using the “Choose Data” option within Microsoft Word or when viewing results in the relationships designer. To test, you have to save the template and use the “Create Document” options from the DocumentsCorePack Dialog.

Was this helpful?

1 Yes  No
Related Articles
  • Generate and process documents within customer journeys in Dynamics 365 Marketing
  • Multi-Select Picklist fields in DocumentsCorePack Templates
  • How to solve the issue with DocumentsCorePack fields in Arabic text
  • How to access mscrm-addons product settings in Dynamics 365
  • One-Click-Actions (OCAs) in DocumentsCorePack
  • Service Configuration options
Latest Articles
  • How much data & file capacity can you save by moving email content and file attachments?
  • Generate and process documents within customer journeys in Dynamics 365 Marketing
  • Multi-Select Picklist fields in DocumentsCorePack Templates
  • PowerSearch – How to install license with subscription number/ID 
  • PowerSearch – How to install the license key for perpetual License
Popular Articles
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • DocumentsCorePack Online Service Configuration
  • mscrm-addons.com Application Access for Dynamics 365 (App Access) – DocumentsCorePack
  • How to activate the DocumentsCorePack connector for PowerApps & Microsoft Flow
  • How licenses are counted
Top Rated Articles
  • 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
  • Can you save data capacity by moving email content?
  • Online Services: Required Application Permissions
Categories
  • *News and General Infos* 51
  • Webinars 21
  • Template Designer(DCP 161
  • DocumentsCorePack(DCP 181
  • TelephoneIntegration (TI 64
  • AttachmentExtractor (AE 56
  • PowerSearch (PS 45
  • ActivityTools (AT 57
  • SmartBar (SB 51
  • GroupCalendar (GC 45
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.