Hello,

I'm using the distinct attribute on columns for a report I'm creating, and it's working like a charm although there is one side-effect I'm not a fan of. The word "DISTINCT" is printed within each and every column header. Is there a way to get rid of this?

I've search the forum etc. and haven't come across anything. I thought perhaps it was some sort of SET command, but didn't have any luck finding it there in the SET list. Hopefully this is an easy fix and I'm just not using the proper search terms.

Thanks for any help.
JC

This message has been edited. Last edited by: jcannavo,

You can use AS 'Column Title'.

TABLE FILE CAR
SUM CNT.DST.MODEL AS 'My Model'
BY COUNTRY
END

Thank you BabakNYC, that was it. I knew it was probably something easy. Been a long week, I should have thought of that. Is it Friday yet?

Thanks again.

JC

It is now

Thank goodness!

And here I thought this would be a topic on daylight saving time! Lol.