• Documentation
  • Back to www.mscrm-addons.com
  • Documentation
  • Back to www.mscrm-addons.com
home/Knowledge Base/DocumentsCorePack(DCP)/Charts Formatting Options in Dynamics 365

Charts Formatting Options in Dynamics 365

256 views 0

There are two Formatting Chart options in your DocumentsCorePack templates. If you select a chart in your template, you can access the formatting option with the “Field properties” button in our ribbon in word.

  1. Formatting
  2. Excel Formatting


Figure 1: Field properties

You can see the preview of the setup formatting in the columns for the attributes.


Figure 2: Formatting Chart Options

1. Formatting

With a double click on the “Formatting”-field, this window opens where you can edit the existing formatting. Dependent on the data type you can select the formatting and the culture as for any other merge field that is used with DocumentsCorePack.


Figure 3: Chart Category

The “Your Pattern for this property” section supports the DocumentsCorePack property syntax. As you may know, when using an aggregation fetch to group by month you only get the numeric values to do not apply for a proper date formatting. By utilizing the property syntax capabilities you can create a date out of the actual values and formats it accordingly.

Figure 4: Example of date formatted to display the actual month names in your generated document 

 

2. Excel Formatting

We, unfortunately, do not support the “Number” section you see in Figure 5 when you set it up in your template. If you want to have specific formatting here you will have to set it as a specific DCP property. How to apply such formatting is described in the next few steps.

Take your template in which you have imported a chart of your choice like in Figure 3 and make a double click on the “Category” until the “Format Axis“-selection pops up. Make sure to have the “Axis Options” selected where you click on the chart symbol. Here you can find a “Format Code” in every displayed selection like in this example “Numbers“.


Figure 5: Format Code

Please copy this code and open the Field properties in your template. Make a double click on the Excel Formatting-field.


Figure 6: Field properties – Excel Formatting

This window pops up. Paste the copied code in the yellow highlighted field “Excel Formatting” and press “OK”. This is necessary if you need some Formatting in Excel.


Figure 7: Paste copied code in Excel-Formatting-Field

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

 

 

Was this helpful?

Yes  1 No
Related Articles
  • Control access to DocumentsCorePack One-Click-Actions via Dynamics 365 security roles
  • 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
  • Multipart documents in DocumentsCorePack
Leave A Comment Cancel reply

Latest Articles
  • Control access to DocumentsCorePack One-Click-Actions via Dynamics 365 security roles
  • How to display various activity-attributes within multiple rows in Gantt view
  • Recap: European Power Platform Conference 2022
  • How to solve the issue with DocumentsCorePack fields in Arabic text
  • How to access mscrm-addons product settings in Dynamics 365
Popular Articles
  • DocumentsCorePack Online Service Configuration
  • Where do I find the Unique Organization name in Microsoft Dynamics 365?
  • 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?
  • How to work with the new DocumentsCorePack custom connector for PowerAutomate (Microsoft Flow)
Categories
  • *News and General Infos* 50
  • Template Designer(DCP 160
  • DocumentsCorePack(DCP 181
  • TelephoneIntegration (TI 64
  • AttachmentExtractor (AE 55
  • PowerSearch (PS 43
  • 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.