Quote:I can't figure out how to suppress repeating values that I've sorted and am doing a "count" of. If I have 10 records with "Texas", I get 10 lines in my report showing "TX" and then in the next column, my value of 10. HELP (anyone!) - how do I suppress the 10 lines of "TX"?
TJ,
I just started to experiment with reports yesterday, so I may not have the best solution.
[Erika, please tell me there is an easier one.]
The best I have come up with, is to do it with programming within the REPORT design, like this:
///// Global Code /////
stat CurrentCopy as string
stat DelayedCopy as string
///// Place this code in the element programming for the "Group Body" value that you want to suppress. /////
CurrentCopy = Category
if CurrentCopy = DelayedCopy
clear([Name of LE that you want to suppress])
DelayedCopy = CurrentCopy
This was designed to work with TEXT values. I'm sure it would need some modification to the variable declarations to work with other data types.
Let me know how you make out.