• 1 reply
  • Latest Post - ‏2013-12-20T18:12:36Z by OpherB
8 Posts

Pinned topic Prompts

‏2013-12-20T05:35:06Z |
In my Report page columns with cities (A, B, C, D, E, and F) are present. Using Value prompts (Static choices 1, 2), 
If I select 1, it should display A, B, C
If I select 2, it should display D, E, and F.
Could you send me the steps in Detail…



Updated on 2013-12-20T05:39:21Z at 2013-12-20T05:39:21Z by Sriiswathi
  • OpherB
    684 Posts

    Re: Prompts


    The challenge here is that the natural thing to do is to use "IF" in the report filter just like you used in your question. Remember this: NEVER use "IF" in a filter.

    The filter you want is this:

    (?prompt? = 1 and [City] in ('A', 'B', 'C')) or
    (?prompt? = 2 and [City] in ('D', 'E', 'F'))

    Good luck,