Reset the row number

Mupagunaa

Hi All,<br />
<br />
I have grouped the data on the column "state" and set the pagebreak option to "Always Excluding First" so that I can see the data related to a particular state in a separate page.<br />
<br />
I'm <strong class='bbc'>trying to add a horizontal line after every 5 rows in the group</strong>. How can I do that??<br />
<br />
I tried to add a line and set the visibility property to "Hide Element", selected the radio button "For specific output" and wrote the expression " Birt.Math((row._rownum+1),5)!=0 ". At first, it looked like a solution, but for the next group, the rownum is not "zero". <br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/public/style_emoticons/'>http://www.birt-exchange.org/org/forum/public/style_emoticons/</a><#EMO_DIR#>/confused.gif How can I reset the "rownum" to zero for every first row in the group so that I can see the horizontal line after every 5 rows(starting from the first row in that group, but not the first row in the table) in the next groups? <br />
<br />
To say it more clear, if I have 2 groups and in the first group(which is in the first page) I have 17 rows. In the second group (which is in the second page), I have 18 rows. When I tried to add the expression for the visibility(mentioned above), I could see the horizontal line for every 5 rows in the first page. But in the next page, I can see the horizontal line after 3 rows(and not after 5 rows). This is because of the rows 16,17 in the first group and the rows 18,19,20 in the second group. I want to reset the rownum to zero for the first row of every group. <br />
<br />
<br />
Thanks for your time.

mwilliams

The best thing to do in this case is probably to initialize a variable to 0 in your initialize method, then increment this in the onCreate method of your detail row. You should then be able to add your horizontal line based on this new variable. To keep it working for each group, you'd just reset the variable in the group header's onCreate method.

Hope this helps.