Total count of the Group

[jawwadfarooq1]

Hi All,

 

I want to have a total count of the group in a variable. It is possible to display that as a Text Field and making its evaluation type to 'Report', but I dont know how to have that in a variable or use that in calculations.

 

Kindly reply,

 

Jawwad

[mvw]

Define a variable for count the first record of the group. Two options:

 

1) Count value only for first record of the group

Name: G2_NUMBER

Variable Class:  java.lang.Integer

Calculation: Count

Reset type:  Report

Increment type: None

Variable Expression: ($V{G2_COUNT} != null && $V{G2_COUNT} == 1) ? "" : null

 

2) Count value once time by group

Name: G2_NUMBER

Variable Class:  java.lang.Integer

calculation: Count

Reset type:  Report

Increment type: Group

Increment group: G2

Variable Expression: $F{<field_name_not_null>}

 

[mvw]

I'm using Groovy for expressions.

 

Good Luck!