Click here to Skip to main content
12,401,628 members (57,343 online)
Rate this:
 
Please Sign up or sign in to vote.
Dear,

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 b.membershipid=m.id
left outer join transaction t on t.billId=b.id
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 Los221.8K
v2
Comments
Kuthuparakkal 14-Sep-12 3:07am
   
Can you fix it in your Query ?

1 solution

Rate this: bad
 
good
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 b.membershipid=m.id
left outer join transaction t on t.billId=b.id
GROUP BY membershipid, billamount
ORDER BY membershipid, billamount
and remove groupping in the report.
  Permalink  

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


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 18 Sep 2012
Copyright © CodeProject, 1999-2016
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