Click here to Skip to main content
12,950,084 members (42,229 online)
Rate this:
Please Sign up or sign in to vote.

I am building a report using report builder 2.
let say the data from my query is look like below:

Select membershipid,billamount,transactionAmount
From  membership m inner join bill b on
left outer join transaction t on

MembershipId(membership Table) billAmount(bill)  TransactionAmount (transaction)
1                              100                   20
1                              100                   20
1                              100                   50
1                              100                   10
2                              50                    10
2                              50                    10 
2                              50                    20

when I used the row group in report builder on membershipId then add Total group
,report output is like this:
1                             400                  100
2                             150                  50

I want to see this output:
1                             100                  100
2                             50                   50

why this happen?and What should I do؟
Posted 13-Sep-12 21:02pm
Updated 14-Sep-12 10:07am
Maciej Los252.8K
Kuthuparakkal 14-Sep-12 3:07am
Can you fix it in your Query ?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

The only way to achieve that is to change a query:
SELECT membershipid, billamount, SUM(transactionAmount) AS transactionAmount
FROM  membership m inner join bill b on
left outer join transaction t on
GROUP BY membershipid, billamount
ORDER BY membershipid, billamount

and remove groupping in the report.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 5,749
CHill60 3,380
Maciej Los 2,953
Jochen Arndt 1,935
ppolymorphe 1,820

Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 18 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100