Howto generate Sequence No and to reset group

[ktrinad]

By: Harish - harishhebbar

Howto generate Sequence No and to reset group

2004-01-15 04:03

i am facing problem reseting group sequence no.

 

i am generating sequence no , but i am not able

to reset by group .

 

<variable name="SerialNo" class="java.lang.Integer" resetType="Group" resetGroup="ProjectSubGroup" calculation="System">

<initialValueExpression><![CDATA[($V{SerialNo} != null)?(new Integer($V{SerialNo}.intValue() + 1)):(new Integer(1))]]></initialValueExpression>

</variable>

 

once seq is increased to say 10 , and when group reset is done,

sequence no remains as 10 forever.

 

<group name="ProjectSubGroup">

<groupExpression><![CDATA[$F{projecttype}]]></groupExpression>

 

whenever projecttype is changed sequence no should reset to 1 and should start incrementing as long as projecttype remains same.

 

 

 

By: Vinod Kumar Singh - vinodsingh

RE: Howto generate Sequence No and to reset g

2004-01-15 21:05

You can use inbuilt variable groupname_COUNT.

 

Where group name the name of group, in your case ProjectSubGroup.

 

It works just like REPORT_COUNT, but it reset to 1 when group changes.

 

 

By: Harish - harishhebbar

RE: Howto generate Sequence No and to reset group

2004-01-18 22:12

Thanks it works fine.