Hi all ,
I have the following table :
       Item    Vendor No.
        003      003
        003      002
        003      002
        003      002
        003      010
i use the DistinctCount for the Vendor No . but i want also to display the records in a group footer .
example : DistinctCount = 3
          Display Records = 003,002,010 .