Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Dynamic CRM word template group columns

(0) ShareShare
ReportReport
Posted on by 10

Hi,

Could someone please let me know, who we can group column in dynamic crm word template. I've designed a word template to print opportunity details. Under my opportunity products, products can have duplicate lines.

eg:

Item qty price
AAAAAA 1 100
BBBBBB 1 340
AAAAAA 1 100

So in my template, I want to group this as follows

Item Qty Price
AAAAAA 2 200
BBBBBB 1 340

Thank you

  • ak_chamara Profile Picture
    10 on at
    RE: Dynamic CRM word template group columns

    Hi Paul,

    Thank you so much for your post.

    When consider on my client business process & the way the system has implemented, It's not possible to simply increase the qty. The product id will be always unique by a product property.

    Regards.

  • Paul_Owen Profile Picture
    2,027 on at
    RE: Dynamic CRM word template group columns

    Hi, just curious, why would you enter the same product more than once and not just edit the quantity?

    Regards

    Paul

  • Suggested answer
    AJ-22040756-0 Profile Picture
    on at
    RE: Dynamic CRM word template group columns

    Hi Partner

    Unfortunately this is not achievable through Word, you can try this in Excel if that helps out. 

  • Suggested answer
    Kokulan Profile Picture
    18,054 on at
    RE: Dynamic CRM word template group columns

    Hi

    As suggested above, i don't think you will be able to achieve this with CRM word template features. You might be able to look into word macro or VBA code to achieve this but then the script may not on all the user's machine due to trust issues.

    If there are duplicate Opportunity Products, if I were you, i would consider writing a plugin to merge them as soon as they are created in CRM so that you have a clean data in CRM.

  • Verified answer
    Charles Abi Khirs Profile Picture
    3,569 on at
    RE: Dynamic CRM word template group columns

    Hello,

    I think it is not feasible in word template.

    What you can try is to do it with Excel Template and use different expressions, pivot table... that are more flexible to achieve your need.

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Daivat Vartak (v-9davar) Profile Picture

Daivat Vartak (v-9d... 225 Super User 2025 Season 1

#2
Eugen Podkorytov Profile Picture

Eugen Podkorytov 106

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 106 Most Valuable Professional

Overall leaderboard

Product updates

Dynamics 365 release plans