3 Replies - 401 Views - Last Post: 14 September 2018 - 09:56 AM

#1 andrewsw   User is offline

  • never lube your breaks
  • member icon

Reputation: 6798
  • View blog
  • Posts: 28,091
  • Joined: 12-December 12

SSRS hiding duplicates across groups

Posted 14 September 2018 - 06:08 AM

Not strictly about .NET but the MS world, is anyone a whiz with SSRS Reporting?

I have data like this first image,

Posted Image

where for each id there can be more than one letter, and all the other columns are just repeating the same information. (Excuse the crudeness of my image.)

My aim is to get a report in the report designer like this:

Posted Image

I have a table with all the columns as nested row groups.

The first id column, because it is a group, shows the id's in large (across rows) boxes. However, foo, bar, etc., all show individual cells, with grey borders. The cells are not merging.

I understand the behaviour, kind of, because the letters in the previous columns are individual, not a grouped collection.

If I were to reorder the columns it would work but I cannot do this; they must appear in the original order. Nor does Hide Duplicates work because the are not duplicated across a letter.

Can you suggest how I might get the desired output?

Is This A Good Question/Topic? 0
  • +

Replies To: SSRS hiding duplicates across groups

#2 andrewsw   User is offline

  • never lube your breaks
  • member icon

Reputation: 6798
  • View blog
  • Posts: 28,091
  • Joined: 12-December 12

Re: SSRS hiding duplicates across groups

Posted 14 September 2018 - 07:21 AM

I thought I was making progress with an expression like

=IIf(Fields!Headline.Value=Previous(Fields!Headling.Value),"None","Solid")

on border bottom/top style but no joy.
Was This Post Helpful? 0
  • +
  • -

#3 modi123_1   User is online

  • Suitor #2
  • member icon



Reputation: 15106
  • View blog
  • Posts: 60,395
  • Joined: 12-June 08

Re: SSRS hiding duplicates across groups

Posted 14 September 2018 - 07:57 AM

Give me a few to see about setting something up to test. Pretty sure I've done this before.
Was This Post Helpful? 0
  • +
  • -

#4 andrewsw   User is offline

  • never lube your breaks
  • member icon

Reputation: 6798
  • View blog
  • Posts: 28,091
  • Joined: 12-December 12

Re: SSRS hiding duplicates across groups

Posted 14 September 2018 - 09:56 AM

Thank you. Here is a clearer example of what I mean:

Posted Image

I'd look Lookback to be in a merged cell as the id is, even though it is to the right of the codes.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1