Repeated section, please see detail message...

[srkk]

Hi,

I want to repeat a section on each page, this section (BroughtForwardFigure) need to appear once after group header section or before start of detail section on each page and end of detail section on each page(CarryForwardFigure).

This is something like Page Header and Page Footer, but this page header need to appeared after group header section and page footer need to be appeared before group footer section on each page. Please see the layout example.

By the way, i am using CR8.5

My report (customer account statement) is grouped according to Customer Code, my customer code start from AA001 to ZZ999,

Reports layout example:

AA001
address Page 1 (GroupHeader)
BroughtForwardFigure
1. xxx 1000
2. xxx 2000
.... ....
.... ....
CarryForwardFigure
(GroupFooter)

AA001
address Page 2 (GroupHeader)
BroughtForwardFigure
20. xxx 500
21. xxx 120
.... ....
.... ....
CarryForwardFigure
(GroupFooter)

AA001
address Page 3 (GroupHeader)
BroughtForwardFigure
30. xxx 700
31. xxx 1200
.... ....
.... ....
Total Balance
(GroupFooter)


AA002
address Page 1 (GroupHeader)
BroughtForwardFigure
1. xxxx 100
2. xxxx 2000
......
......
TotalBalance
(GroupFooter)

I face big problem to come out section like this.

Please help.

 

[hilfy]

Use the Group header for your first piece. You can add a second group header section and put your data there. If you want to show them on every page, modify the group and select "Repeat Group Header on Each Page". For the header section that you don't want to repeat, put the following in the suppress formula:

InRepeatedGroupHeader.

As for the footer piece, you might be able to use a page footer section to do this.

-D

 

[srkk]

Hi Hilfy,

I can get BroughtForwardFigure to be repeated on each page as i locate this formula in Repeated Group Header. But for Group Footer, there is no option for me to repeat it on every page. I need to show CarryForwardFigure once after detail section for each page, any clue?

Thanks

 

[lbass]

Group on {table.custcode}, and check repeat group header on each page, as hilfy suggested. Then create three formulas:

//{@grpsum} to be placed in the details section:
whileprintingrecords;
numbervar grpsum := grpsum + {table.amt};

//{@displaygrpsum} to be placed in the group header AND in group footer_a AND in the page footer:
whileprintingrecords;
numbervar grpsum;

//{@reset} to be placed in group footer_b (go to format->section->and insert a new group footer section to create this):
whileprintingrecords;
numbervar grpsum := 0;

Finally, format the {@displaygrpsum} that you placed in the page footer by right clicking on it->format->number->customize->check "suppress if zero."

This will give you a running total that will appear as your brought forward figure in your repeated group header, and as your carry forward figure in the page footer. If the group ends on the page, the group footer_a display formula will display the total for that group and the page footer will be suppressed, since it will be zero.

You didn't really indicate whether your brought forward/carry forward figures were sums, so I just made that assumption. If not, please provide more information about what that calculation is.

-LB

 

[srkk]

Hi LB,

BroughtForwardFigure on 1st page is directly call out from table.

CarryForwardFigure is sum of BroughtForwardFigure + each Figure in detail section. CarryForwardFigure need to be shown on each page but not last page.

BroughtForwardFigure on 2nd (or above) page will be CarryForwardFigure of previous page.

Thanks

 

[lbass]

Is the brought forward figure newly drawn from the database for each group?

Then my suggestion should work with the following changes:
Change {@reset} to:

whileprintingrecords;
numbervar grpsum := {table.broughtforwardfigure};

Instead of formatting the {@displgrpsum} that appears in the page footer to suppress when zero, right click on it->format field->common->suppress->x+2 and enter:

onlastrecord or
{table.custcode} <> next({table.custcode})

-LB