Skip to Content
author's profile photo Former Member
Former Member

Dynamic filtering

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2009 at 06:37 AM

    Hi,,

    Is CrCount and Dbcount are Database field or summary??

    If it is DB field.Why you go with additional formula,

    Right this formula in the selection expert formula editor. .(You will get this formula editor from selection expert itself.)

    if {?Activity} = "Y" then
    CrCount= 0  or  DbCount = 0

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Salah,

      Thanks for the suggestion. The CrCount and DbCount are debit fields.

      I've tried your suggestion. But, when {?Activity} ="N", then report is not fetching any data.

      I've added this condition to the above and it's working fine:

      if {?Activity} = "Y" then ( notequalto 0 or notequalto 0) else if {?Activity} = "N" then ( greaterthanequalto 0 or greaterthanequalto 0)

      Thanks a lor for your help.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.