I am doing crystal reporting. I would like to set a particular field in my report for example Product_ID to unique in Crystal report so that it won't display the same ID many times even if it detect that my database table has more than one occurence of that ID. Product_ID is foreign key in the table that I am retrieving data. That is why it can detect many repetition of ID. Please helps, any helps will be appreciated.

Thanks