Page Footer in Subreport

[nicoll]

I have a subreport on which I need to print some text at the bottom of each page. Normally I would use a page footer, however, being a subreport, page footers are not available.

Is there any way to 'simulate' a page footer on a subreport?

Many thanks,

New to Crystal.

 

[Ngolem]

sure....

create a fake group...suppress the header and in the footer check the "Print at the bottom of the page".

to create the fake group you might try a formula like

@FakeGroup

if 1 = 1 then
"1"
else
{table.stringfield};


I tried just using only a constant once and that didn't work. this formula will always evalute to 1 so the the grouping will always be on a constant which won't affect your report.

Hope this works for you

 

[nicoll]

Thanks for the technique.

This seems to work fine except when the number of detail lines exceeds the number of available lines on the page.

I am printing purchase orders. I have a group on the purchase order number, and the FakeGroup. The layout is as follows:

GH - PO
GH - FakeGroup
Detail (PO)
GF - FakeGroup
GF - PO

If there are too many PO details to print on one page, the PO spills over onto a second page. When this happens, the FakeGroup footer does not print on the first page.

Any suggestions?

Thanks.

 

[Ngolem]

ok...so far so good

you have the wrong order

Make the fakegroup first....not in the middle

 

[Ngolem]

I took a look at that again and see that my fake group isn't really the answer to the problem...as it only gives one footer no matter what.

Can you predict the number of lines per page?

If it is consistant, add a subsection to the details. Put your message there and in the Section expert check off the "print at the bottom of the Page"

now put a line counter in the main detail section.

in the conditional part of "New Page After" of the detail subsection put the formula:

{@linecounter} = someNumber;

also to the "print at the bottom of the Page" add

{@linecounter} = someNumber or onlastrecord;


that might work better...Jim

 

[nicoll]

This works much better. Thanks very much!