Can I filter a field with formula (to show only Yes)>

[netchie]

Hi,

I'm using CR 2008. I created a formula to show Yes and No on the report. Now that I successfully show them, I only wanted to show all data with Yes on the report but I'm having a hard time to do it. Can you please help me? Here is the formula (@Duplicate) that I've created.

if ({PR.id} = next({PR.id})
or
{PR.id} = previous({PR.id}))
then
"YES"
else
"NO"

Thanks in advance,
netchie

 

[pmax9999]

Given the nature of the formula, the simplest approach would be to use conditional formatting to suppress the Details rows where:

{@Duplicate} = "NO"

Cheers
Pete

 

[netchie]

Hi Pete,

Thanks for your reply. When I tried to create a new formula that you've given, it's not accepting it. It says the field (@Duplicate) as field does not exist.

 

[BettyJ]

Please check if you are using curly brackets as in pmax9999's code.

 

[pmax9999]

I used he formula name {@Duplicate} because that's what you referred to it as in your first post. As BettyJ says, it must be within {}, not (). You also need to watch for trailing spaces in the formula name.

To be on the safe side, but just pick it from the formula list.

Cheers
Pete

 

[netchie]

Thanks for your reply. Much appreciated