Group Footer Positioning

[racer25]

Guys,

I have searched for the solution to this and while I have seen the odd hint, nothing concreate or really anything I could get working.

My problem is I right reports in Crystal and there is a simple option for Group Footer - display at bottom of page.

My project requires that I use Access for the report and I am trying to exactly the same thing display a Group Footer at the bottom of the page.

It would make some of the summing and definitions easier and would appreciate if anyone could guide me on this.

Cheers,

R

 

[rainman89]

Theres a grouping option that will allow u to make a group footer.
View> grouping and sorting

 

[racer25]

I have the Group Section there just want it at the bottom of the page.

 

[boblarson]

Sorry, but Access is unable to fulfill your request. Unlike Crystal Reports it is not a full-featured report writer. It does about 80% of what you might want to do, but a professional report writer like Crystal Reports is about the only way to get the other 20% of what you want to do.

 

[rainman89]

Bob Says no
but did u try turning on group footer option?

 

[boblarson]

Bob Says no
but did u try turning on group footer option?

Rainman - The group footer will appear at the end of each group and not at the bottom of the page.

 

[rainman89]

Oh oh oh... misread what he wanted to do. my apologies

 

[racer25]

Bob,

Thanks for that

I found one or 2 very clumsy workarounds on the web - but nothing anywhere close to Crystal.

How about I address this a different way.

I have a client code a client branch and a client currency which all look at a query and create this fairly average statement in Access.

What we are trying to do is email a statement to each client, nothing more nothing less.

All information is stored in one table, could I use this table to send parameters to a Crystal Report which will print to a PDF based on a formula in query and then cycle though the recordset.

Or is there a smarter solution I should be a looking at.

Thanks for taking the time to read this.

 

[GaryPanic]

having look at this - surely grouping is the answer

you need a total for each branch and each currency

I have to do a report
by contract , by currency and by tax
example
contract A
Sterling
Tax 5%
all on one report
and
contract A
Sterling
Tax N/A


I run one report that splits this out onto 2 pages (or more depending )

I can also do Euros
Contact A
Currency Euro
Tax 5%

its the same report just grouping to sepearate

 

[racer25]

But I do have the grouping by each section.

Just want the totals due at the bottom of the page.

Crystal seems to have much better reporting functionality. Multiple Group section under the same group where they appear if they appear on page X etc.

 

[rainman89]

y not just cut and past the group footer into the page footer? that way its at the bottom of the page

 

[boblarson]

You can set a "force new page," or insert a page break, after a group so that at least you would have each group on a separate page(s).