When i link an excel worksheet to an oracle table, i do not have the ability to "select distinct records", the option is grayed out. Hence my report returns double/triple...... rows.
Anyway around this ? there is only 1 common link between the 2 tables, a string field for "name"
i'm using cr11