Repeat a group header field in every page

[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

[K.Babu]

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

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

[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

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

InRepeatedGroupHeader = False

[K.Babu]

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

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

[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 !!


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

Regards,
Rohini

[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

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

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

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

[malleyo]

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:

{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 ).

[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

[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

[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

[Madhi]

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

Madhivanan

[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

[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

[Madhi]

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

Madhivanan