How to unhide(?group) control in the footer() band only on the last page of the report?

1

Hello everyone!
How to unhide(?group) control in the footer() band only on the last page of the report?

Improving the request:
I need that, if the report has more than 1 page, whatever is in ?Footer is printed only on the last page.

If there is one, print it in its ?Footer, if there are two, print it in the ?Footer of the second, if three, in the ?Footer of the third…

Thanks.

2

Hi !
You need to know the tag of the last line report or the number of records to print.

  ReturnValue = PARENT.TakeRecord()
  ! [Priority 5001]
     CurrentRow += 1
     If CurrentRow = AllReportRow then UnHide(?GroupTotal).    ! Show the total on the last 
  PRINT(RPT:detail)
3

Hi!
How do I get the value of AllReportRow ?

Thanks!

4

This value must be calculated before printing the report, taking into account all filters.

1 Like
5

The way the Print Engine outputs pages is somewhat a black box.

A few pages are buffered while the Engine resolves widow/orphan features of WithNext(), WithPrior(), Together etc. So after all the Details print you could Unhide your Footer controls. That Unhide will happen on the Buffered Pages so the unhid footer could end up rendering on more than just the Last Page.

Instead of a Footer I would put those controls on a DETAIL that you Print Last. Specify the ABSOLUTE attribute with the AT(X,Y) down at the bottom of the page in the Footer position.

3 Likes
6

Assume it’s ABC? Then in the embed for TakeRecord, After the parent call…

IF ReturnValue ! Report has finished
  SETTARGET(Report)
  UNHIDE(?FooterString)
  SETTARGET
END
1 Like
7

You can use a Grand Total band for this and print it only at the end of the report…
Look at Clarion’s help for “Grand Totals” on how to use it.
Hope this help you

8

I’ll do the tests!
Thanks everyone!

9

Even you don’t use the Grand Total approach, in the Clarion’s help about Grand Totals you’ll find the correct embeds to use…

10

On line help How to Print Grand Totals on a Report

Help on ABSOLUTE that will allow AT(x,y) positioning a Detail in the Footer area of the Report.

2 Likes
11

Ok!
The implementation worked as suggested by CarlBarnes:
→ I inserted a new ?Detail
→ in Extra I selected Absolute
→ I set the height/length/x and y to the same as the ?Footer

image
image1121×625 50.3 KB

→ I set its filter to false
image
image989×543 25.8 KB

→ I called it as the last to be printed before the EndPage where the client inserts images
image

Peteleco_Sonia_CITODOIS_00026.pdf (748,3,KB)

12

Thank you very much everyone!!!

13

Que bom!
Precisando, entre em contato…