News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Total of Number column...

Microsoft Dynamics AX (Archived)

Total of Number columns using Export to Excel

(0) Share

Report

Report

Posted on by Sohaib Cheema

46,610 User Group Leader

I have come across an interesting scenario, where someone can add information to my knowledge, as I haven’t seen this earlier.

We have a client who were on AX2012 RTM
Recently we updated them to R3-CU13.

During UAT we found an issue, which is about Export to excel.

If Export to excel is being performed in RTM version, it shows totals for amount/number type columns in the exported excel sheet.
But if the same thing is performed in R3-CU13 totals do not appear for any columns.

I have never seen any settings in any version of AX, for this kind of stuff.

This is normal Export to Excel operation that one performs every day, using Ctrl+T

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Francesco 520 on at

Like (0)

Report

RE: Total of Number columns using Export to Excel

Seems like a small price to pay for moving away from the mother of all crap-versions.

I happen to have access to an R2 CU6 environment which is the farthest I can retro-AX. No totals there, but a brief peek in the AOT shows different classes for different versions of Excel, so that might also play a role.

The SysExcelWorksheetHelper has a sumRange method, which "Sums the worksheet range provided and puts the result in the specified cell.", so the functionality appears to be there.

I have no clue what is supposed to trigger it, though.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans