Repeat a group header field in every page

Printable View

June 27th, 2004, 11:27 PM
RohiniR

Repeat a group header field in every page

I want a field in a group header to be repeated in every page. I have 3 fields in the group header - they are Account Name,Debit Balance and Credit Balance.

When i use the option repeat group header on each page...it repeats all the 3 fields..but i wanted to repeat only the account name on all the pages...
Can any one help me out..
Urgent.
Thanks in advance
Rohini R
June 28th, 2004, 07:03 AM
K.Babu

Re: Repeat a group header field in every page

Hi,

Split the group as two (Create two groups), GroupOne is Account name Group Two is debitbalance and credit balance.

now you can make "repeat group header" for individual group.

yours friendly,
K.Babu

Quote:

Originally posted by RohiniR
I want a field in a group header to be repeated in every page. I have 3 fields in the group header - they are Account Name,Debit Balance and Credit Balance.

When i use the option repeat group header on each page...it repeats all the 3 fields..but i wanted to repeat only the account name on all the pages...
Can any one help me out..
Urgent.
Thanks in advance
Rohini R
June 28th, 2004, 10:25 PM
RohiniR

But this is in 2 ...

Thank U.

This is wat i have done for now.

But this makes a line waste.

I have group by account name and that particular account name's credit and debit balances..so i have to create 2 groups,both group by account name...place the balances in one group and account name in one group..repeat only the group with acc name.
But it makes one line extra for each acc name.

Is there any other solution.?

Regards,
Rohini

:p
June 29th, 2004, 08:12 AM
malleyo

You can use a Conditional Suppress to hide the fields on the 2nd (3rd, 4th, etc) page.

(This uses CR 8.5 and RDC to create the reports) --> Right-click the field you only want to appear on the first page, Click Format. On the Common tab, click the box labeled 'x-2' next to Suppress. In the formula editor that comes up, type:

Code:

InRepeatedGroupHeader = False
June 30th, 2004, 07:18 AM
K.Babu

Re: But this is in 2 ...

Hi,

1. account name aligned left corner of the first group.

2. Credit and Debit Balances aligned right corner of the second group.

3. right click the group one select the "section format", then check the underlay following section:

Note: make sure the group one and group two section height be same for good view.

a line saved :thumb:

Quote:

Originally posted by RohiniR
Thank U.

This is wat i have done for now.

But this makes a line waste.

I have group by account name and that particular account name's credit and debit balances..so i have to create 2 groups,both group by account name...place the balances in one group and account name in one group..repeat only the group with acc name.
But it makes one line extra for each acc name.

Is there any other solution.?

Regards,
Rohini

:p
July 1st, 2004, 01:30 AM
RohiniR

malleyo,
Thank U.
I tried as u said...but the credit & debit balances get supressed for full of the page except for the first time...
i. e . the balances appear in the group header only once for a page... for the rest of the group headers the balance does not appear.. Can u Help me out !! :blush:

Babu,
I tried to underlay the following section but the detail section overlaps on the group header..??What to do?

Regards,
Rohini
July 1st, 2004, 04:02 AM
K.Babu

Where you set the overlaps

you should set the overlaps option in the top of the groupone, so it overlap at bottom grouptwo

Code:

Group#1 (set here overlap) AccountName Group#2 Credit and Debit now group#1 overlap to group#2 output look like this. AccountName Credit and Debit

------------

Quote:

Originally posted by RohiniR

Babu,
I tried to underlay the following section but the detail section overlaps on the group header..??What to do?

Regards,
Rohini
July 1st, 2004, 08:26 AM
malleyo

Quote:

Originally posted by RohiniR
I tried as u said...but the credit & debit balances get supressed for full of the page except for the first time...
i. e . the balances appear in the group header only once for a page... for the rest of the group headers the balance does not appear.. Can u Help me out !!

Set the Suppress for ONLY the fields that you DO NOT want repeated after the first page. Set the Suppress for the Debit Balance and Credit Balance, but don't set anything for Account Name. Make sure you have Repeat Group Header on every page turned on. Your results wil be as follows:

Code:

{Page1} Account Name DebitBalance Credit Balance {Page2} Account Name {Page3} Account Name {Page4} Account Name ... etc ...

For this, you would put all the fields into the same Group Header and you wouldn't need the overlay as KBabu suggested (although the overlay would work too ;) ).
July 2nd, 2004, 05:05 AM
RohiniR

malleyo,
This option did not work well. Thanks for ur idea..

Babu,
This worked out well for other reports..But not for my particular report...I dont know why..i shd study over it.......
Thank U

Rohini
July 7th, 2004, 05:06 AM
Madhi

Hi Rohini,
Try the following.
Right click on Debit Balance field, select format field. In the suppress option, write the formula as given below
If GroupNumber>1 then True
Do the same for Credit Balance field also

Madhivanan
July 7th, 2004, 07:06 AM
RohiniR

Thanks for ur suggesstion
No this did not work well.

The balance displays for the first group..in a page and is suppressed for the others.
There may be more than one group in a page itself..

Rohini
July 7th, 2004, 08:43 AM
Madhi

Hi Rohini,
Can you post the expected outcome with some sample data?

Madhivanan
July 12th, 2004, 02:25 AM
RohiniR

Hai Madhivanan,

Just Have a look at this sample data

Name Debit Bal Credit Bal
----------------------------------------------------------------------------------
1.XYZ 1000
ggdgfdfgd gfsdg 200
shfghfghfgh 500
gjgsdftdf 300

2.ABC 2000
sfggfsdfsd 1500
hngdfgdf 500

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

This is the way the report goes..
The name XYZ,ABC are in a group header.
The other details are in detail section.
the balance for XYZ is 1000..the transactions exist for that 1000 rs are shown here.If it extends to the next page...Then the name XYZ should be displayed on the next page too... But not the balance 1000.i.e. 1000 should not be displayed in next page/

Now did u follow my problem?

Thanks ,
Rohini
July 12th, 2004, 04:01 AM
Madhi

Hi Rohini,
Now I clearly understand what the problem is. To overcome this problem use running total, 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 think this will give you a solution

Madhivanan
July 27th, 2004, 10:39 AM
Madhi

Hi Rohini,
Did you get the solution? Let me know.

Madhivanan
July 28th, 2004, 05:55 AM
RohiniR

No...this is a problem

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
July 28th, 2004, 05:56 AM
RohiniR

No...this is a problem

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
July 28th, 2004, 11:13 PM
Madhi

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
August 25th, 2004, 10:39 AM
shrutz

Re: Repeat a group header field in every page

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
August 25th, 2004, 10:33 PM
RohiniR

Re: Repeat a group header field in every page

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 :)

All times are GMT -5. The time now is 09:44 AM.