Linking an excel worksheet to an oracle table

[huytonscouser]

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"

 

[IanWaterman]

You can group report by common field, then place all data fields in group footer, suppress details and group header.

You will not be able to use standard summaries and use Running Totals instead which evaluate on change of Group.

Ian

 

[huytonscouser]

I am trying to get a count for the group, so i have a summary(count) which i add to the group header.
It is always two or three times larger than the unique(distinct) count, due to the duplicate(same names) in the linked table.

 

[huytonscouser]

this is what the "show sql " shows :-

C:\Crystal Reports\Input Files\Cluster\new cluster.xls
SELECT `'Phoenix_VMAX_'`.`Tier +Shared List`, `'Phoenix_VMAX_'`.`Dev Size GB`, `'Phoenix_VMAX_'`.`ARRAYTYPE`, `'Phoenix_VMAX_'`.`ARRAYSERIALNUMBER`, `'Phoenix_VMAX_'`.`Site Name`, `'Phoenix_VMAX_'`.`Sorted Share List`, `'Phoenix_VMAX_'`.`Tier Level`, `'Phoenix_VMAX_'`.`Array + Lun`, `'Phoenix_VMAX_'`.`Host`
FROM `'Amex House$'` `'Phoenix_VMAX_'`
EXTERNAL JOIN 'Phoenix_VMAX_'.Host={?StoreageScope - Amex House: SRMHOST.HOSTALIAS}


StoreageScope - Amex House
SELECT "SRMHOST"."HOSTOS", "SRMHOST"."HOSTALIAS"
FROM "EMCSTS"."SRMHOST" "SRMHOST"
WHERE "SRMHOST"."HOSTALIAS"={?C:\Crystal Reports\Input Files\Cluster\new cluster.xls: 'Phoenix_VMAX_'.Host}

 

[Kim296]

I agree with IanWaterman. Try grouping by the nameid or a unique id. This should work for what you need.