Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Word templates: group field in body

Posted on by Microsoft Employee

Hi,

I have to design a SOP invoice that has 2 grouping. The report need to group the item under the 2 category.

e.g Comment text and then comment text 2. I am passing some value through the fields.  So I want the report to show comment text, then comment text 2 and then list all the item link to comment text 2 , followed by comment text and the move to the next comment , followed by comment text 2, items ........ Is this something that I need to do in report writer before putting it in the word templates? 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Word templates: group field in body

    Thank you Leslie.

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Word templates: group field in body

    Hi Patrick

    First answer is Yes, you need to do it in Report Writer first. The second challenge is finding a way to do it. The default design is to have four available Comment Text fields per line item. Do you want to switch it around so that the Comment Text is the header and the individual items fall below them (or above them)? You could kind of do it the way it's setup by entering the comment on the last item in the group. You would need to enter the items on the SOP document in the correct order to get this to work. Out of the box, there is not a setting that allows this behavior.

    Kind regards,

    Leslie

  • Lyn Barr Profile Picture
    Lyn Barr on at
    RE: Word templates: group field in body

    A standard practice for designing Word Templates is to make all your changes in the Standard (Report Writer) form first.  The Word Templates use the Report Writer XML, so you need to be sure everything in the Report Writer form is set up correctly before you design your Word Template.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans