Create a report with a group header and details under the group header?!

Question

Create a report with a group header and details under the group header?!

WebTechie

SSChampion

Points: 11405
More actions
October 6, 2010 at 11:36 am

#230083

Hello,
I've been developing reports for years in Crystal Reports. I am quite good at it.
Now, because of departmental and managerial requirements, I am trying to convert some reports to SSRS.
I need a report that has a group header with the detail data under the group header. I usually placed a narrow box under the group header title to look like a think underline. I then show the detail data.
With SSRS, it is creating things as a crosstab format.
1) I created a report and dataset
2) I inserted a table
3) I created a row group (facility)
4) I then added another group row (department)
5) I then added the employees detail fields
I have one tall row that has the facility, then smaller for the departments and then the detail. That is a crosstab format.
I don't want a crosstab format report table.
This is pretty straight forward in Crystal Reports. A no brainer. How do I do this in SSRS? I hope I have clearly conveyed what I am trying to create. It is probably a no brainer also, but unfortunately, I don't see it. My reports aren't looking the same as in Crystal Reports.
Thanks,
Tony
Things will work out. Get back up, change some parameters and recode.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

From your description, that is pretty much how I would do it. Getting a crosstab is strange indeed because that is usually the domain of a matrix style table.

WebTechie SSChampion Points: 11405 More actions · Answer 2

This is what I'm getting:

North Facility Employeea

____________Employeeb

____________Employeec

What I need is

North Facility

Employeea

Employeeb

Again, this is pretty straightforward in Crystal Reports. I don't see how in SSRS.

Any ideas?

Thanks.

Things will work out. Get back up, change some parameters and recode.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 3

Interesting I would think you would get

North Facility

____________EmployeeA

____________EmployeeB

____________EmployeeC

Where the Facility is a parent group to the Employee Detail.

Try a slightly different approach:

1. Add your table/tablix

2. Add your employee detail

3. Right click on the employee detail row and choose Add Group>>Parent Group

4. Add your facilty

Does that look the way you want?

WebTechie SSChampion Points: 11405 More actions · Answer 4

Thanks for trying to help.

No. I get the same thing.

One big row on the left for the facility and then the employees on the right.

-----------------------------

-facility___-employee -

- ________-employeea -

- ________-employeeb -

-----------------------------

Am I doing something wrong? Is there a trick to this? LOL!

Tony

Things will work out. Get back up, change some parameters and recode.

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 5

Sorry. I forgot one important bit of info.

When adding the parent group put a check the "Add group header" checkbox.

Bex SSCrazy Points: 2437 More actions · Answer 6

I have the same problem - could do it fine in Crystal and SSRS 2005, but not SRS 2008.

Ok, I've had a play around and you could try this (it seems a bit clumsy to me, sorry!)

Add tablix

Add your employee detail

Add parent Group, showing header row, for facility

in the row above your employee detail, choose your facility field from the drop down list of fields.

Delete the entire column that was created when you added the group for facility (left most column)

that should give you

Facilty..

Employee..

I'm sure there must be a smarter way, and I would be glad to learn it.

WebTechie SSChampion Points: 11405 More actions · Answer 7

Thanks, that worked.

The field was wrapped into three rows depending on how long the name of the facility was. I merged the cell next to it and now it spans one row and the detail records are on the next row.

Perfect.

I am now getting

North facility

========

employee_firstname, employee_lastname

South facility

========

employee_firstname, employee_lastname

It is a lot more straight forward in Crystal Reports, but I got it now.

Thanks a lot. I appreciate you pointing me in the right direction. I'm off and running now. Thanks again.

Tony.

Things will work out. Get back up, change some parameters and recode.

WebTechie SSChampion Points: 11405 More actions · Answer 8

Old Hand,

Hello. I just wanted to round out this thread.

I've created a couple of reports now. It appears that deleting the left most column takes away the cross tab look.

Then you can add the group fields as needed and it works well.

I've never read that in any of the blogs, but it gives me the exact look I need by deleting that column.

Thanks again.

Tony

Things will work out. Get back up, change some parameters and recode.

Bex SSCrazy Points: 2437 More actions · Answer 9

Hi Tony

Thanks for the update, much appreciated.

hor_netuk

stephen.redman Valued Member Points: 70 More actions · Answer 10

Thanks for this, been struggling with it myself, easy in SSRS 2005. I can't believe that there isn't an easier way!