Hidden Lines

[digimortal]

I'm using a matrix;
Row=Name,Surname
Cols=Site
Data=DateTime

The problem is when two or more names match it only shows 1 name and hide the others like this
--------------------
Name Surname
--------------------
Surname
--------------------

I want to make the other lines (Names) visible... BTW I did not check Hide Duplicates option...

 

[GShort]

I would either adding the first name to the grouping or modify your SQL qery to to add Lastname + Firstname.

(nametable.Surname + ', ' + nametable.Firstname) AS Name

This should keep it from grouping the names together.

 

[Catadmin]

You could also play with nesting a table within the Matrix, or create a table and nest a Matrix within it. These are both neat methods for displaying data that RS thinks is duplicated or grouped, so messes up.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???