Show single results from duplicate results 1

[pgrice]

Using CR 10 and Oracle DB.

I have a column that returns duplicate values (see below). I have been able to 0 out the duplicates, but I don't know how to remove the 0's from my returned list.

Here is my formula that 0's out duplicate values:
if {ADDRESS.ADDR_TYPE_CDE} = 127 then {CMB_CMPTMT.CMBC_NUM}

There are only two values for ADDR_TYPE_CDE - 127 and 128. I only want to display those that have the value of 127. Another field is dependant on this as well.

thanks...

 

[Turkbear]

Hi,
Why not use a record selection formula:
{ADDRESS.ADDR_TYPE_CDE} = 127

That way only records with that value will be returned..

Am I missing something in what you want to do?

 

[pgrice]

Hey Turkbear,

I will state that I am really new to CR and you might have to take me a step back!

I entered the simplified formula like you mentioned, dropped it on the report, and I get a True/False value returned on my report. I still want to see the {CMB_CMPTMT.CMBC_NUM} when {ADDRESS.ADDR_TYPE_CDE} = 127.

Is there something I need to change so that I display the data in the field and not the True/False?

 

[pgrice]

That is all that was needed. I just found out where to find the Record Selection function. Missed it before!

Thanks for the help!
Geoff