Repeat a group header field in every page

Hi madhi,
This did not work out becaz i cannot use running total field there

Code:

---

Just Have a look at this sample data

Name Debit Bal Credit Bal
----------------------------------------------------------------------------------
1.XYZ 1000 --  always this will not be 200+500+300..it can be also 0 or it can be a derived formula field..that is opening or closing balance...
ggdgfdfgd gfsdg 200
shfghfghfgh 500
gjgsdftdf 300


2.ABC 2000
sfggfsdfsd 1500
hngdfgdf 500


3............

---

sorry for no replying u.
Regards,
Rohini

Hi madhi,
This did not work out becaz i cannot use running total field there

Just Have a look at this sample data again

Name Debit Bal Credit Bal
----------------------------------------------------------------------------------
1.XYZ 1000 -- always this will not be 200+500+300..it can be also 0 or it can be a derived formula field..that is opening or closing balance...
ggdgfdfgd gfsdg 200
shfghfghfgh 500
gjgsdftdf 300


2.ABC 2000
sfggfsdfsd 1500
hngdfgdf 500


3............




sorry for no replying u.
Regards,
Rohini

Hi Rohini,
Actually there is no need to worry about the result of the running total. Just create a running total field having any one of the fileds of the table.select type of summary as count, Evaluate for each record and reset on change of group. Then place that running total in the details sections. Now right click on Debit Bal ,select format field and in the suppress option write the formula as

If RunningTotalField > 1 then True

Do the same for Credit Bal also

If you dont want to display the running total suppress it.

I tried this and it worked well. The running total field will not generate any sum as the type selected is count.

Madhivanan

Hey, Sorry for asking such a dumb quest...where is this option of repeating group header on each page???

I have 3 group headers ...2 are suppresed...I want to repeat the unsupressed group header on each page. Please give me the steps to do that.

Thank you
Shruti

hi sruti,
right click the group header and go to the 'change group' option
In that General and Options will be there...click 'Options'..and then select the 'Repeat Group Header On Each Page' check box

Try this & revert back..

Regards,
Rohini R :)