Am trying to recreate an access report in Crystal. I thought of using a command in designing a report.The only hinderance is am not sure how to modify the access query. I have a DISTINCTROW in the previous ACCESS query.Is DISTINCTROW equal to DISTINCT.Whats the equivalent for DISTINCTROW in oracle. Can anyone throw some light on this.for reference the Access query is below

 

SELECT DISTINCTROW "CUBS SNAPSHOT"."TYPE",
       "CUBS SNAPSHOT"."SUBTYPE",
       "CUBS SNAPSHOT"."LOB",
         Client.Client_Name,
       "CUBS SNAPSHOT"."CLIENT" AS ClientCode,
       "CUBS SNAPSHOT"."EVENT_ID" AS filenum,
       "CUBS SNAPSHOT"."EVENT_ID",
      "CUBS SNAPSHOT"."ASSIGNDATE",
       "CUBS SNAPSHOT"."Other Carrier",
       "CUBS SNAPSHOT"."OC Subscriber Name",
       "CUBS SNAPSHOT"."OC Member ID",
       "CUBS SNAPSHOT"."OC Effective DATE",
       "CUBS SNAPSHOT"."DEBTORID",
       "CUBS SNAPSHOT"."Debtor Name",
       "CUBS SNAPSHOT"."Orig-Clm",
       "CUBS SNAPSHOT"."Orig-ClmLn",
       "CUBS SNAPSHOT"."HMG Flag",
       "CUBS SNAPSHOT"."TRACKING",
       "CUBS SNAPSHOT"."BEGINDOS",
       "CUBS SNAPSHOT"."ENDDOS",
       "CUBS SNAPSHOT"."DUP-Orig-CHECK-NUMBER",
       "CUBS SNAPSHOT"."DUP-Orig-CHECK-DATE",
       "CUBS SNAPSHOT"."CHECK_NUMBER",
       "CUBS SNAPSHOT"."CHECK_DATE",
       "CUBS SNAPSHOT"."GROUPNUMBER",
       "CUBS SNAPSHOT"."PROVIDERNAME",
       "CUBS SNAPSHOT"."MBU",
 
  FROM "CUBS SNAPSHOT",Client
 WHERE ((("CUBS SNAPSHOT".LOB) = 'MEDICAL') AND (("CUBS SNAPSHOT".PRORATED_TRANAMT) != 0))
    OR ((("CUBS SNAPSHOT".LOB) = 'MEDICAL') AND (("CUBS SNAPSHOT".PRORATED_TRANAMT) = 0) AND
       (("CUBS SNAPSHOT".PRORATED_FEEAMT) != 0))
    OR ((("CUBS SNAPSHOT".LOB) = 'MEDICAL') AND ("CUBS SNAPSHOT".Client = Client.Client_code) AND (("CUBS SNAPSHOT".PRORATED_TRANAMT) = 0) AND
       (("CUBS SNAPSHOT".PRORATED_DIRECTPAY) != 0))
    OR ((("CUBS SNAPSHOT".LOB) = 'MEDICAL') AND (("CUBS SNAPSHOT".PRORATED_TRANAMT) = 0) AND
       (("CUBS SNAPSHOT".PRORATED_FEEPAID) != 0))