Re: Count Distinct
Posted in 1996
Louis DeLongchamp — — source: Informix-list mailing list archive (1991-1998)
arcieri@pilot.njin.net (Joseph Arcieri) wrote: snip >I'm having trouble using the count function to get a total of the labels I >just printed. I get a number much larger than what was printed. I know the >number includes duplicate rows but haven't been successful using count distinct >or unique. snip You need to create your own variable to handle the count. Add the following code to your report... define variable cnt integer end format after group of company stmts... let cnt = cnt + 1 on last row print "Total Labels Printed: ",cnt end