|
Hello,
I'm on Crystal Report X11 and have a report for that i need to display one of the value out of sequence.
So This is a normal report,
CurMon
AAA
A111 30
A112 20
A113 70
BBB
B111 60
B112 33
B113 48
CCC
C111 54
C112 77
C113 49
C114 55
DDD
D111 40
D112 55
D113 33
But I need it in following way
CurMon
AAA
A111 30
A112 20
A113 70
BBB
B111 60
B112 33
B113 48
D112 55
CCC
C111 54
C112 77
C113 49
C114 55
As you can see that I wanted to display only D112 value before CCC
So I created a sub section before CCC and add a Text Object with Label "D112"
Then created a RT (D112Tot)
Field of Summarize = command.curMon
Type of Summary = Sum
Evaluate:
Use a Formula = {Command.col} = ["D112"]
Now I put this RT (D112Tot) in my report before the "CCC" then it give me "0.0"
But if I put the same RT (D112Tot) after "DDD" -> D112 (Created same sort of setup means setup a sub section) Then it give me correct value
D112 55
So is there any way I can display this D112 value before CCC?
Any help would be appreciated.
Thanks
|