Group Totals in RDLC C# Report

Question

Hi there

I have created a report which consists of 2 Groups; Accounts and Divisions. I have Totals on both Group levels.

The problem is when an Account does not have any Divisions within it, I have a total line with the same values just before the Account totals. How can I get rid of this line of "duplicate" values.

When an Account has divisions within, I wish to see the totals for each Division, and the Grand Total for the Account. But when the Account has NO divisions within, I only want to see the Account total.

Is this possible? and if so, how?

Many thanx.

---

It's not the blowing of the wind that determines your destination, it's the set of the sail. J Rohn

Answer 1

Say your Grand total textbox named textboxGroundTotal.

Try setting your account total textbox:
 iif(textboxGroundTotal.value=sum(account).ToString(),"",sum(account)).

Good luck,

Long

Answer 2

Thanx Long.

What I am actually aiming for, is in the scenario when an Account does not have any Divisions within it, the line with Division Totals must not be visible.

It should not be a blank line, there should be no line.

Thanx again

---

It's not the blowing of the wind that determines your destination, it's the set of the sail. J Rohn

Answer 3

OK, would the following work for you?

1. set Grand total textbox ( named textboxGroundTotal )
2.
set Division's  Visibility-->Hidden
 iif(textboxGroundTotal.value=sum(account).ToString(),true,false).


Long

Answer 4

Thanx Long

I have used the following statement,

=IIf(TotHedgAmnt.ToString() = DivHedgAmnt.ToString(), True, False)

and received the following error,

"The Value expression for the textbox ‘textbox42’ refers to the report item ‘textbox40’.  Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope.".

Thanx.

---

It's not the blowing of the wind that determines your destination, it's the set of the sail. J Rohn

Answer 5

Hi, Excalibur7 ,
for the structure :
Group1 -----
   Group2 ---

  DivHedgAmnt   Group2--end
Group 1 ---end
TotHedgAmnt

You can Not refer to DivHedgAmnt.ToString(), it's out of scope.
You can
1.Refer to the TotHedgAmnt (Grand Total Shown Below).
2. Use sum(account) instead of DivHedgAmnt.ToString(),


Good Luck,
Long

 

Answer 6

Thanx Long

The problem is not with the Div field, but with the Tot field. I can access DivHedgAmnt without a problem, but I am unable to access TotHedgAmnt.

I also cannot use sum(account), since I use this for the Div-totals and report-totals. Therefore sum(account) will always be equal to DivHedgAmount.

Any other suggestions?

Many thanx

---

It's not the blowing of the wind that determines your destination, it's the set of the sail. J Rohn

Answer 7

Hi, Excalibur7,
Please refer to the structure I mentioned above at July 14, that should work.



 If not, please show your structure.

Thanks,
Long 

Answer 8

hi i have column oatotal. coloum has repeated values for oasrno i wanted sum at bottom of the column such that it takes

oasrno oatotal

1      3000
       3000 
       3000
2      5000
       5000
3      2000
       2000
       2000 
       2000
  
      (sum)

i wanted sum such that (3000+5000+2000)=10000
ie. single value from group oasrno

 sum(3000+7000+5000) that is unique values or Groupby oasrno value single time i have tried =sum(oatotal,(groupname)oasrno) but it doesnot work gives error please help

Answer 9

Please give the solution as soon as possible. i am also having the same problem.

Answer 10

I have a similar issue; With two levels of grouping, I would like to have just the numbers in the first level's footer summed up for the second level's footer; I don't want to add all the table's values.

Any ideas are welcome

---

Chris