display records that contain particular value from field as prompted

[Former Member]

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

[abhilash_kumar]

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