Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Office add-ins - Unabl...
Finance | Project Operations, Human Resources, ...
Answered

Office add-ins - Unable to add Qiery that uses aggregate functions in a word template

(0) ShareShare
ReportReport
Posted on by ist 805

Hello,

I am trying to add document data source in a word template but came across the following error message:

message.png

Here is my query:

28464.query.png

Is there any restriction about using aggregate functions in the document datasources?

Regards,

  • ist Profile Picture
    ist 805 on at
    RE: Office add-ins - Unable to add Qiery that uses aggregate functions in a word template

    Hi Blue,

    This workaround works.

    Thanks!

  • Verified answer
    Blue Wang Profile Picture
    Blue Wang on at
    RE: Office add-ins - Unable to add Qiery that uses aggregate functions in a word template

    Hi Jaret,

    Try to create a view based on your query.Then add Sum and GoupBy field TaxValue to View field.

    Create a second view and use the view as data source. Add a query reference to the second query at the document data sources.

  • George_D365 Profile Picture
    George_D365 on at
    RE: Office add-ins - Unable to add Qiery that uses aggregate functions in a word template

    Hi Jaret,

    What version of AX 2012 are you running?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans