SELECT DISTINCT ORDER ID'S

[Dausa67]

I have a report in CR XI that I want to pull only distinct order id's.

Example of results:

ORDER_ID
R00528871
R00528871
R00528873
R00528878
R00528871

I just want it to pull (not suppress) the following example:
R00528871
R00528873
R00528878




Clay

 

[crrighter]

Go to File>Report Options... Choose Select Distict Records
Click OK.

 

[Dausa67]

I already have it set to choose distinct records.

Clay

 

[Turkbear]

Hi,
Is there more than 1 table involved..What other fields are you selecting to return...If all are not Distinct tnen multiples of the Order-Id will be returned - If that is the case Group on the Order-Id and, if desired, supress the details..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[crrighter]

Yes. If the entire row of data returned is not distinct, then you will need to Group by Order_ID.