Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Change Signs on Numbers Post Reply Post New Topic
Author Message
bucky7199
Newbie
Newbie
Avatar

Joined: 17 Feb 2008
Location: United States
Online Status: Offline
Posts: 30
Quote bucky7199 Replybullet Topic: Change Signs on Numbers
    Posted: 19 Feb 2008 at 8:53am
I have created an income statement in a cross tab report in Crystal and have flipped the signs of the expense accounts so they all appear positive in the reports. I have 2 revenue accounts that I want to flip the signs on. Can someone give me the Crystal code to do that? I tried this:
 
{GLChart.Chart} = "701000", "701200"
 
It didn't work. Said the remaining text didn't appear to be part of the formula.
 
Thanks.
Dan S.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Feb 2008 at 10:54am
Try one of these:
 
{GLChart.Chart} in ["701000", "701200"] (I don't know if I have the syntax right on this - you may have to tweak it.)
 
or
 
{GLChart.Chart} = "701000" or {GLChart.Chart} = "701200"
 
-Dell
IP IP Logged
bucky7199
Newbie
Newbie
Avatar

Joined: 17 Feb 2008
Location: United States
Online Status: Offline
Posts: 30
Quote bucky7199 Replybullet Posted: 19 Feb 2008 at 11:00am
Thanks Dell, I will give it a go.
Dan S.
IP IP Logged
bucky7199
Newbie
Newbie
Avatar

Joined: 17 Feb 2008
Location: United States
Online Status: Offline
Posts: 30
Quote bucky7199 Replybullet Posted: 19 Feb 2008 at 11:10am
That's the right syntax Dell. I checked it for errors and it is error free.
 
However, it's still not changing the signs on my revenue numbers. I am right clicking in my cross tab chart on the row and going into format editor, custom style, number and clicking on the formula button and entering my formula there.  Any idea what I am doing wrong?
 
 
Dan S.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 19 Feb 2008 at 11:57am
Which formula button are you using? Is it the Reverse Sign For Display property?

Also, rather than using the field name directly, I would use the cross-tab function that returns the field value:
GridRowColumnValue ("GLChart.Chart") IN ["701000", "701200"]

Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
bucky7199
Newbie
Newbie
Avatar

Joined: 17 Feb 2008
Location: United States
Online Status: Offline
Posts: 30
Quote bucky7199 Replybullet Posted: 19 Feb 2008 at 12:51pm
Hi Brian,
 
By the way, bought your book Crystal Reports Encyclopedia, and it has helped me a bunch in making this income statement.
 
Yes, it is formula button for the Reverse Sign for Display Property.
 
Thanks,
 
Dan S.
IP IP Logged
bucky7199
Newbie
Newbie
Avatar

Joined: 17 Feb 2008
Location: United States
Online Status: Offline
Posts: 30
Quote bucky7199 Replybullet Posted: 19 Feb 2008 at 1:34pm
Brian,
 
That worked!!!! Thanks man.
Dan S.
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 19 Feb 2008 at 2:13pm
Great!




Edited by BrianBischof - 19 Feb 2008 at 10:14pm
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
bucky7199
Newbie
Newbie
Avatar

Joined: 17 Feb 2008
Location: United States
Online Status: Offline
Posts: 30
Quote bucky7199 Replybullet Posted: 19 Feb 2008 at 3:06pm

I'd be happy to do it Brian. I'll do it when I get home tonight.

 

Thanks.

Dan S.
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.016 seconds.