I have a stored procedure that returns the Store, Product Category, Units Sold, & Sales Dollars, but each is reported in different charts.
[pre]
StoreID ProductCategory FYQuarter Units Sold Sales Dollars
1198 Gloves 2013 - Q1 1 176
1198 Hats 2012 - Q4 18 4410
1198 Shoes 2013 - Q1 8 2460
1198 Gloves 2013 - Q2 1 199
1198 Gloves 2013 - Q4 1 142
1198 Shoes 2012 - Q4 31 9717
1198 Shoes 2013 - Q2 11 2988
1198 Shoes 2013 - Q3 9 2249
1198 Hats 2013 - Q3 7 2235
[/pre]
Almost everything is reported separately. Each ProductCategory gets its own chart for both for both Units and Amounts. So Hats, Gloves, Shoes for Units Sold makes 3 charts; Hats, Gloves, Shoes for Sales Dollars are another 3 charts.
The charts for Units Sold are in a tablix that should be one Product Category per page. (There is a page break between Categories.)
Up to this point, everything works very well.
Then the charts for Sales Dollars need to be displayed 4 per page (2 columns of 2 rows) and there are up to 8 categories, but it could be fewer. (I have the 4-per page charts are in a separate tablix from the 1-per page with a column group for Product Category.)
Two things I can't figure out:
1) This needs to be printable (landscape). How do I manage page-breaks? Should this be sub-reports?
2) Should all this be in the same tablix?
I still have costs to add in here (which may be a separate data set -- I'm not sure).
[pre]
StoreID ProductCategory FYQuarter Units Sold Sales Dollars
1198 Gloves 2013 - Q1 1 176
1198 Hats 2012 - Q4 18 4410
1198 Shoes 2013 - Q1 8 2460
1198 Gloves 2013 - Q2 1 199
1198 Gloves 2013 - Q4 1 142
1198 Shoes 2012 - Q4 31 9717
1198 Shoes 2013 - Q2 11 2988
1198 Shoes 2013 - Q3 9 2249
1198 Hats 2013 - Q3 7 2235
[/pre]
Almost everything is reported separately. Each ProductCategory gets its own chart for both for both Units and Amounts. So Hats, Gloves, Shoes for Units Sold makes 3 charts; Hats, Gloves, Shoes for Sales Dollars are another 3 charts.
The charts for Units Sold are in a tablix that should be one Product Category per page. (There is a page break between Categories.)
Up to this point, everything works very well.
Then the charts for Sales Dollars need to be displayed 4 per page (2 columns of 2 rows) and there are up to 8 categories, but it could be fewer. (I have the 4-per page charts are in a separate tablix from the 1-per page with a column group for Product Category.)
Two things I can't figure out:
1) This needs to be printable (landscape). How do I manage page-breaks? Should this be sub-reports?
2) Should all this be in the same tablix?
I still have costs to add in here (which may be a separate data set -- I'm not sure).