Question?

[metalteck]

I am currently using crystal 8.5. I have no problem with the data that the field gives me.

Ex. QTY
5
5
6
7
7
7

What I'm trying to figure out is how I can eliminate the values that only appear once. I was trying to create an if statment, but don't know how to word it. My desired output would look like this:

QTY
5 (2)
7 (3)

Please help. Thank you

 

[lbass]

Insert a group on quantity, and right click on the quantity in the detail section and insert a count at the group level. If you want the result in parens, you could drop the summary in a text box, adding the parens. Or you could create a formula:

"(" + totext(count({table.qty},{table.qty}),0,"")+ ")"

Then go to report->selection formula->GROUP and enter:

count({table.qty},{table.qty}) > 1

-LB