Hiding Group Headers

Question

Hiding Group Headers

dtheri1

Newbie

Points: 5
More actions
March 6, 2009 at 10:12 am

#201999

I have a report that has three levels of grouping. The users do not want to see duplicates in the headers. I've been able to figure that part out. However, I now want to suppress the blank line that shows where the group header used to be.
Example
Full-Time
Filled
Detail 1
Detail 2
Full-Time (this becomes a blank row when the duplicate is hidden)
Vacant
Detail 1
Detail 2
Part-Time
....
In the above example, I am hiding duplicates on Full-Time. Is there a way to get rid of the blank line that appears instead of the second Full-Time row?

Viewing 9 posts - 1 through 9 (of 9 total)

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

Luke L SSC-Dedicated Points: 35547 More actions · Answer 1

Can you give a bit more info on how you're "hiding" the duplicates?

Perhaps you just need to take a bit better look at how you're grouping the information. Are you using a Matrix of table to make this happen?

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

dtheri1 Newbie Points: 5 More actions · Answer 2

I am not using a matrix. I added a table to the report and some groupings. To hide the duplicates, I went into the properties of the cell and chose hide duplicates and chose the group from the drop down where this field appears on the report.

dtheri1 Newbie Points: 5 More actions · Answer 3

And in response to how I am grouping the information... Unfortunately I do not have a choice for the groupings. This is a report that will be sent to the governors office and it has to be exact.

Luke L SSC-Dedicated Points: 35547 More actions · Answer 4

So when you are talking about a header, are you actually dealing with the header row or just a row that has the top level of your information?

What I mean by better define your groups is that you may need to group on more or less columns to remove your duplicates

It would seem to me that you'd Want a static header defining your columns,

Then you'd need 3 groups,

1 would be Grouped on Fulltime/PartTime

Next would be grouped on Filled/Vacant with a parent group of group 1

And the details row would be the third group.

This should eliminate the repetition of the 1st group. You should not have to do it as hide duplicates from within the cell itself.

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]

dtheri1 Newbie Points: 5 More actions · Answer 5

This is basically how I have it. Only when the position status changes from Filled to Vacant, I do not want to repeat the Full-Time header. I need to have this as a group header so it will show when the employee status changes from Full-Time to Part-Time.

Luke L SSC-Dedicated Points: 35547 More actions · Answer 6

It shouldn't need to repeat itself if the grouping is set up correctly. Perhaps, I may have miss stated the grouping you'd need...

(-1 Would be Group On: =Fields!(whatever Full-Time/PartTime is)

(-2 Would be Group On: =Feilds!(Filled/Vacant) (the extra group I had specified earlier may be causing the repeating issue)

Details No Group On Expression.

Also on group 1 and 2 make sure you have Repeat Group Header unchecked.

Give that a go and see what happens...

To help us help you read this[/url]For better help with performance problems please read this[/url]

dtheri1 Newbie Points: 5 More actions · Answer 7

I figured it out. I had the full/part time field in the positions status group header. Once you started questioning my groupings, I tried to create a new report using the wizard and looked at the design. Looking at that I was able to modify my report to get what I needed.

Thanks for your help.

Derek

Luke L SSC-Dedicated Points: 35547 More actions · Answer 8

Glad you were able to get it sorted.

Cheers,

-Luke.

To help us help you read this[/url]For better help with performance problems please read this[/url]