-1

I've seen how to's on how to display combined data however, I would like to keep all data separate in their own rows and columns. It seems to have to do with grouping, but when I attempt to delete the grouping, the report has an error when trying to run. I would like to prevent the cells from combining like in this

d0nut
  • 3
  • 2
  • It's usually easier to start with a new table than try to fix an old one. When adding columns, use the Insert Column -> Left (or right) rather than Add Group. – Hannover Fist Mar 31 '16 at 21:14
  • @Hannover I've been using the table wizard in order to build these tables as I'm new to SSRS. Any idea how I can change it? – d0nut Apr 04 '16 at 16:26
  • What's the error when you run the report? – molleyc Apr 04 '16 at 18:37
  • @molleyc - there's no error - the OP doesn't want the grouping that the wizard was creating. – Hannover Fist Apr 05 '16 at 15:42
  • Sorry - this line copied from your original question was misleading then: "It seems to have to do with grouping, but when I attempt to delete the grouping, the report has an error when trying to run." – molleyc Apr 05 '16 at 18:49

1 Answers1

0

When you are creating a report in the wizard, any items that are set in the red Group section will create a new grouping.

You want to place all the fields you want to see in the blue Detail section of the wizard. There is no grouping in the details. If you have a group

Putting fields in the orange Page section will cause a new page to be created for every new value.

Example wizard

In this example, the wizard will create a report that will Page based on the Region. Each region will have it's own section that includes a Vendor group and each vendor group consists of member claims (it's in health care). It will create a new page for each region then group each vendor's members claim within that region.

Hannover Fist
  • 10,393
  • 1
  • 18
  • 39