Report Builder Report - Column Sum

Bob 3 (146●6●50) | asked Oct 11 '19, 1:35 a.m.
edited Oct 11 '19, 1:37 a.m.

Is there a way to create a columnar sum in a Report Builder report?

We are using version 6.0.6.1.

As drawn in the graphic, I am seeking a column total.

Can this be done with the Report Builder wizard? If not, can it be done with custom SPARQL? (If yes, I will seek out SPARQL expertise.)

Comments

Bharath Rao commented Oct 15 '19, 1:56 a.m. | edited Oct 15 '19, 1:59 a.m.

Hi,

A similar query was answered in the below forum link:

https://jazz.net/forum/questions/231278/how-to-sum-all-work-hours-on-jrs

Please review and let me know if that works for you or if you need any further assistance.

Regards,

Bharath

Bob 3 commented Oct 15 '19, 3:08 p.m.

Bharath, thank you for your response.

I followed the instructions in the link that you provided as best I could apply them to my situation. I found that it resulted in a new column with row-based sums - not column-based sums. Any ideas for producing a column-based sum?

Bharath Rao commented Oct 17 '19, 2:00 a.m.

Hi Bob,

I do not know of such an option available in JRS.

However, while searching for the solution, I found the below forum post which appears to be answered by you :)

https://jazz.net/forum/questions/264689

Bob 3 commented Oct 17 '19, 6:01 p.m. | edited Oct 17 '19, 6:01 p.m.

Bharath, my reporting customer has returned to me, renewing their request for columnar sums.

That is why I have submitted the question to the forum with a slightly different approach.

Thank you for your responses!

Be the first one to answer this question!

It's all about the answers!

Related questions

Report Builder Report - Column Sum

Be the first one to answer this question!