hi,
i am very new to IMR reports. my requirement is to create a month wise sales report.
one page for each month and one page (final page) for cumulative sales.
Example
Page 1
April
sales reg sales Qty
South 100
North 200
Page 2
May
sales reg sales Qty
South 120
North 130
.
.
.
.
.
Last Page
Total
sales reg sales Qty
South 1120
North 1130
how to format like this?
Thanks and regards
Sasikumar M.
Hello Forsasi,
To insert a page break after each Month (or any column that is grouped):
1.) Click on the month column, and then click the 'Group' icon (or click on Report, Query, Group using the menus).
2.) After the month column is group, select the list frame that contains your data (to do this: click on any field in your list frame, and hit Ctrl-L).Ã, This should high-light the entire list frame.
3.) Now click on Format, Properties, and then select the Layout tab.
4.) You should see the Month field listed in the box twice.Ã, One will say "Month" Header, and the other will say "Month" Footer.Ã, On the right hand side is a little box with some black lines, and a red line.Ã, If you hold your mouse over it, it will say "Page Break After: off".Ã, Just click on that button and the report will have a page break after each Month.Ã,Â
5.) Your grand totals will show up on the last page (assuming that you have North & South sales in two different columns, and you have a sub-total running for them).Ã, You might need to add a text box on the last page that says "Grand Total" or something like that.
This same method can be used for any column that you have grouped.Ã, I hope this helps.