Skip to Content
0
Former Member
Sep 08, 2009 at 06:09 AM

Dynamic filtering

17 Views

Hi Experts,

I'm trying to filter report data based on the prompt value and am unable to get it right. Need your suggestions.

Here is the requirement:

I have a prompt {?Activity} with the values as Y or N

In the report I have the columns with values as below:

CrCount DbCount TotalPayment

0 1 10000

1 0 2000

0 0 40000

3 4 50000

0 7 80000

I have to filter the above records based on the below condition

if {?Activity} = "Y", then display only the rows where (CrCount <>0 or DbCount <>0) else display all the rows

I've created a formula field {@Activities} = (CrCount <>0 or DbCount <>0)

In the Select Record Expert, I've used the formula field as {@Activities} = {?Activity}

This works fine if {?Activity} = "Y". If {?Activity} = "N", this condition fails and doesn't fetch any data.

Please help me return all the data when {?Activity} = "N"

Thanks a lot in advance.

Naresh