Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design  
Message Icon Topic: Display value out of sequence Post Reply Post New Topic
Author Message
dax007
Newbie
Newbie


Joined: 17 May 2018
Online Status: Offline
Posts: 15
Quote dax007 Replybullet Topic: Display value out of sequence
    Posted: 08 Jun 2018 at 4:55am
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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.