Report that breaks at month end (1 Viewer)

I

inspmike

Guest
How do I get the report to page break at the end of each month with a sub total, then to give me a grand total at the end of the report?
 

dennyryan

Registered User.
Local time
Today, 18:47
Joined
Dec 21, 1999
Messages
45
Add a caclulated field to your query:

Month:month(DateField)

Then in your report make this new field one of your grouping fields with a footer. You add the sub-total fields in the Footer section. You can also chnage the Format Property for the Footer to Force New Page: After section

Denny
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 14:47
Joined
Feb 19, 2002
Messages
42,971
You don't need to add a field to the query. If you choose the date field in the sorting and grouping options, you will have a choice of grouping by month. If you choose to add a calculated month field to the query, you would also need to add a calculated year field unless your data source contains only one calendar year.
 

Users who are viewing this thread

Top Bottom