Details on first page

[mak101]

There might be a solution but I can't find it. Any help/suggesion will be appreciated.

I want simple report which show % of sale of one item by each month (12 month) for all my 6 regions. Our management team would like to see all regions sales by month on first page with line chart of total sales in each month. In following pages they would like to see each region sale on line chart and one page for each region. May be below example would clear the picture.

Page 1:

July August September October November December January February March April May June
Region 1 22.84 21.9 21.71 23.18 22.98 22.88 24.37 25.16 24.96 24.54 23.67 24.12
Region2 20.45 20.17 20.68 21.33 21.98 23.67 24 21.65 22.05 22.53 23.89 23.04
Region 3 12.64 14.44 14.66 16.32 15.88 11.84 12.54 13.96 14.89 13.99 12.05 12.23
Region 4 15.94 17.57 17.77 17.28 16.6 17.7 17.21 16.63 17.37 16.86 16.67 15.04
Region 5 28.84 26.83 27 26.78 26.73 25.26 25.13 23.59 23.97 24.12 23.17 20.26
Region 6 23.46 23.32 21.85 23.66 22.16 22.05 22.27 22.31 20.78 19.44 19.6 18.38

Total by all Region 24.94 24.6 24.73 25.58 25.46 25.41 25.97 25.49 25.28 24.74 24.09 23.49


Chart: Display line chart for sale by all region by month

Page 2:

July August September October November December January February March April May June
Region 1 22.84 21.9 21.71 23.18 22.98 22.88 24.37 25.16 24.96 24.54 23.67 24.12


Chart: Display line chart for sale by region 1 by month



Page 3:

....



Hope I have explained it clearly. I would appreciate if someone can point me the direction.



Thanks.

 

[MrBillSC]

I think you will need to use a subreport to do this. I suggest you place the subreport in the report header as page 1. It can probably be done with a crosstab report. Select the "new page after" option for the report header section. The main report will group on region, month and display the data and line chart in the region group footer with a "new page after" in the region group footer.
I hope this gets you going in the right direction.

MrBill

 

[lbass]

I agree with MrBill except that I don't think you need a subreport. Insert a crosstab and chart in report header sections (RHa and RHb). Then insert a group by region in the main report, and add a crosstab and chart in group header sections a and b.

-LB