on 11-18-2016 6:32 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.