repeated data in a data grid

[bripoin]

I'm now working on a way to only show the data that is repeated (i.e. Permit Number, PRU ID, Location, ect.) in the datagrid for the project that I was having trouble with a couple of weeks ago. I've got the code working so that the information is pulled based on the permit number that is entered by the user, but a few fields carry the same information all the time. Is there a way to only show that information once and not repeat it for every line of data that is displayed in the output?

[Puiu]

If you are using a select query, than you should use a "Select distinct..." syntax

[bripoin]

Tried that. I still get repeated data.

[Puiu]

Maybe you could post the query...so i get an ideea of what it is about..