News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... how to grab SQL query ...

Finance | Project Operations, Human Resources, ...

Suggested answer

how to grab SQL query to get sumup values of rows in ssrs report

(0) Share

Report

Report

Posted on by M_R

125

hello all,

how to grab SQL query or any the other suggestion please

Here in this report,, the required output is vendor should come only once and we should sumup the quantity and get the total directly of all the columns

can you pls help me out?

All responses Img

All responses (2)

Answers Img

Answers (0)

M_R 125 on at

Like (0)

Report

how to grab SQL query to get sumup values of rows in ssrs report

yes , i tried
Suggested answer

Waed Ayyad 6,332 Super User 2024 Season 2 on at

Like (0)

Report

how to grab SQL query to get sumup values of rows in ssrs report

Hello @ M_R,

Did you try to group the row by vendor account?

Regards,

Waed Ayyad.

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

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

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans