so first one is the dataset i have. i grouped it by loantype, now i want the distinct count of SSN and loan (an ssn can have more than one loan). i want to achieve this on SSRS. i don't want query. suggest please.

try this one =CountDistinct(Fields!yourfieldName.Value) http://msdn.microsoft.com/en-us/library/ms155923(v=sql.90).aspx Hope this will help you !!! Sanjeewan

that doesn't help me... okay, i want to add a column to right and use your function , do i need to select inside group or outside group ? what dosit mean. adn why am i not able to remove the last column?

Check http://www.sqlservercentral.com/Forums/Topic608689-150-1.aspx CountDistinct Function (Reporting Services) CountDistinct Function (Report Builder 3.0 and SSRS)

but can some one tell me y i am not able to delete the last column?

what error are u getting when u r trying to delete the last column? what's the structure of u table or matrix?

tablix body must contain at at least one column. just a tablix matrix.

How many rows and columns do u have apart from that last column?

How many rows and columns do u have apart from that last column? You will have to keep atleast one row and one column in that matrix for it to qualify as a matrix....You cannot have only rows or only colmns in a matrix...

so at least can i hide it?

u gotta try it once as i can't try it now... i am at home and don't have SSRS installed on my laptop :( but i think u can hide it provided u have included a data field in it.

i tried iif( "test" = "test" , false, true ) in visibility but it hides the whole table

u want to hide the column permanently or based on a condition?

permanently.