I have a dataset that is filled bas

[smithbr]

I have a dataset that is filled based on the parameter of the invoice number entered. I want to to display the info from the dataset in a more concide fashion than it is generated. Below is a sample dataset.
COMM PRODUCT INV# BROKER TOTAL DATE
0.02 0074 30202 INSI (null) 5/2/2003
0.03 0072 30202 CHUC 15959 5/2/2003
0.03 0074 30202 CHUC (null) 5/2/2003
0.035 0071 30202 INSI (null) 5/2/2003
0.035 0072 30202 INSI 15959 5/2/2003

I want to display only the unique brokers and unique comm rates. Is there a way to set up a data table to display the unique reocrds.
Here is what I want ot display:
Broker COMM
INSI 0.02
INSI 0.035
CHUC 0.03

ANY suggestions?

 

[RiverGuy]

Change your query.

SELECT DISTINCT Broker, COMM FROM TABLE

.

If you also need it the original way, create a dataapter for the fashion that you want it in, and add it as another table in your dataset.