By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,835 Members | 1,391 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,835 IT Pros & Developers. It's quick & easy.

Report footer

P: n/a
Hi

I have a table with 4 fields Customer, Product, Price and Ares

As I want to create a report using sorting and grouping

I put Customer and I included group header and group footer
then i put all 3 other fields in details section

In the Customer's footer I put a textbox with a formula for the total
Price
Then in the Customer's footer properties On the force new page I put
After section so this way new page start with the next customer
Till then everytnig is ok
Finaly I put same formula (for total price) in the report's footer.
The question is
Is it possible to have the reports footer on the last page containing
data of the last customer instead of having the report footer alone at
the top of a new page (like just one line with the grand total)?
thanks

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Have you made sure that the 'force new page' property of the report footer
is set to 'None'?

David

<je*********@snclavalin.com> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...
Hi

I have a table with 4 fields Customer, Product, Price and Ares

As I want to create a report using sorting and grouping

I put Customer and I included group header and group footer
then i put all 3 other fields in details section

In the Customer's footer I put a textbox with a formula for the total
Price
Then in the Customer's footer properties On the force new page I put
After section so this way new page start with the next customer
Till then everytnig is ok
Finaly I put same formula (for total price) in the report's footer.
The question is
Is it possible to have the reports footer on the last page containing
data of the last customer instead of having the report footer alone at
the top of a new page (like just one line with the grand total)?
thanks

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.