Print Page | Close Window

Display value out of sequence

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22619
Printed Date: 25 Apr 2024 at 4:18pm


Topic: Display value out of sequence
Posted By: dax007
Subject: Display value out of sequence
Date 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



Print Page | Close Window