Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Single dataset, multiple layouts, same report

Status
Not open for further replies.

AndyInNC

Programmer
Sep 22, 2008
76
US
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).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top