Hi All, In my ssrs report, in a tablix, in one of the column I am using below expression in order to get the values 1,2,3,4,5,... =RunningValue(Fields!EMPLOYEE_NAME.Value, CountDistinct, Nothing) so this will give numbering 1,2,3,... now the question is that how can i get the max. of this values. i.e. if there are 10 records then this numbering will be 1,2,3..,10 and i want max of it i.e. value 10 hope its clear. any idea?? thanks

Hi, Use this to get the max number. =CountDistinct(Fields!EMPLOYEE_NAME.Value,"DataSetName") Note: Replace "DataSetName" with the dataset which contains Emploee_Name column Hope its clear & helpful.... Pavan Kokkula Tata Consultancy Services.

using, COUNT(Fields!EMPLOYEE_NAME.Value,"DataSetName") solved the problem. additionally, i had to set the property of that textbox "HideDuplicates" assigning the above dataset name to it.