Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Single dataset, multiple layouts, same report

Single dataset, multiple layouts, same report

Single dataset, multiple layouts, same report

I have a stored procedure that returns the Store, Product Category, Units Sold, & Sales Dollars, but each is reported in different charts.

	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

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).

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close