Skip to Content
avatar image
Former Member

display records that contain particular value from field as prompted

Hello ,

I have a CR 2013. Im working on a report that contains 10 detail section. In the 10th detail section I have forecast years from 1 to 5 . If the static prompt field prompts year 1 as input filter then it needs to display records that have only Frct yr 1's value & rest of them as zeros. similar with the Frct yr 2,3,4,5, & NA all the records that contain zeros .In similar fashion I have few sections with long text also. Pls help me with a solution.

Frct yr 1 Frcst yr 2 Frcst yr3 Frcst yr 4 Frcst yr 5

234000 0 0 0 0

Thanks ,

Vidya

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 21, 2016 at 08:15 AM

    Hi Vidya,

    Try this please:

    1) Create a formula @Yr1 with this code:

    If {Static prompt} = 'Year 1' then

    {Year 1 database field}

    else 0

    2) Create a second formula @Yr2 with this code:

    If {Static prompt} = 'Year 2' then

    {Year 2 database field}

    else 0

    Go ahead and create formulas for each year using the same technique above.

    3) Drag and drop all formula fields on the 10th Details Section.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded