sql server reporting services: Matrix Duplicates -- sql server reporting services

Re: Matrix Duplicates

Robert Bruckner [MSFT]
10/13/2005 7:25:15 PM

Most likely, in one case the label field has a contents like "Pants", and in
the other case there is some whitespace at the end, such as "Pants ".
Try changing the grouping expression to e.g. =Trim(Fields!Label.Value)

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Matrix Duplicates

FL Jim
10/14/2005 5:26:02 AM

I tried this and now I'm getting a blank label for the duplicate row, but
it's still there. I did a Len(Label) for these rows in SQL and they are the
exact same length. Quite strange.

Label Job#1 Job#2
Shoes 10 15
Shirts 50 45
Pants 25
40

[quoted text, click to view]

Re: Matrix Duplicates

FL Jim
10/14/2005 5:31:07 AM

I realized it's now blank becuase the 'hide duplicates' toggle was on for the
group in the matrix; however, it doesn't explain why it recognizes the row as
a duplicate, but doesn't just display the data together in one row.

[quoted text, click to view]

Re: Matrix Duplicates

Robert Bruckner [MSFT]
10/15/2005 7:24:28 PM

There may be something else in the query or the report design that results
in that behavior. Can you post a small report (e.g. based on Northwind data)
that reproduces the issue you are experiencing?

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.