Displaying Subtotal based on Condition

[sunianu]

Hi,

I have a cross tab with 2 row group . I am  getting all the details correctly lik

 

Customer A     10

Customer A      20

   Sub Total Customer A 30

Customer B   20

   SubTotal   Customer B 20

Customer C 40

Customer C 60

   SubTotal   Customer B 100

My Requirement is I need to hide the subtotal based on the number of items in that group. ie Subtotal  need to be displayed if the number of items in that group is greater than 1. In the abouve example subtotal is not requied for customer  B because customer B has only one item

 

How can i achive this in IReport

 

 

Many Thanks

Suni

 

 

 

 

 

 

 

 

[mdahlman]

The Print When expression for that band should let you achieve what you want. Define a variable that counts the rows in the group. Set the Print When Expression to print only when that variable is greater than 1.

 

Regards,
Matt

[sunianu]

Thanks for your reply

 

Let me try

[sunianu]

Hello,

That worked. Thank you very much

I have one more doubt.How can I achieve this in Cross tab ?

 

 

Thanks

Leena