Formatting the Group Footer

[skalina]

I'm trying to recreate an invoice reprint and everything seems to be fine...However, I've got the subtotals in the group footer for the Table and want to format so that the footer always prints at the bottom of the page...

Is there any easy way of doing this? I wasnt able to include the totals in the page footer which seemed like the ideal solution...

Thanks in advance.

 

[SgtJarrow]

You could try setting the visible property of the footer to be hidden. Then in the footer, you can use ReportItems!textboxname.Value - replacing textboxname with the name of the textbox in the footer (not this field name)

That might work.


=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[skalina]

that worked when on screen - but as soon as I print it, the value's dont apepar...

 

[SQLBI]

Use the ReportItems! collection and reference the footer textboxes in the in the Page Footer.

Assuming you have cells in your report footer called Net_Total, Tax_Total and Grand_Total, in your footer, add 3 text boxes and reference the table footer cells

=ReportItems!Net_Total.Value

=ReportItems!Tax_Total.Value

=ReportItems!Grand_Total.Value

Then by setting the Table Footer Hidden property to True, your totals will always appear in the page footer and not in the Table.

Hope this helps, let us know how you get on.


Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip?" - Eminem