Click here to Skip to main content
14,267,879 members
Rate this:
Please Sign up or sign in to vote.
See more:
Here is my data:

ndy #	Candy Desc	Store Number	Store Location	Tot1	Tot2	Tot3	Candy Type
668	 Apple Stick	5	Vancouver	NULL	NULL	80	Hard
668	Apple Stick	9	Vancouver	NULL	NULL	70	Hard
663	Orange Slice	5	Vancouver	NULL	NULL	60	Hard
710	Cinnamon stick	5	Vancouver	517	NULL	NULL	Hard
936	Chick-o-Stick	5	Vancouver	NULL	NULL	50	Hard
887	Blow Pop	2	Vancouver

When I group and subtotal by store location and candy type, I still get a separate line for store number 9. But not store number 2.

I have used the group feature in SSRS before and this has never happened. How can I get my output to group by store location so it shows a subtotal for all Vancouver stores instead of by store number?

What I have tried:

MSDN search, Google search, SSRS group by

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100