Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Reverse sign for display formula Post Reply Post New Topic
Author Message
quintonmartin
Newbie
Newbie


Joined: 09 Nov 2010
Online Status: Offline
Posts: 2
Quote quintonmartin Replybullet Topic: Reverse sign for display formula
    Posted: 09 Nov 2010 at 5:06am
Hi,
  I am using VS 2010 Pro, with CR for VS2010.  I am developing on Win7-64bit, but am developing a 32bit app using .NET 3.5 framework and c#.  I am trying to use the "Reverse sign for display", but using a formula instead of just checking the box, because I only want to reverse the sign on some records.  But no matter what I enter in the formula, it will not reverse the sign on any records.  The only way it will reverse the sign is if I check the box.
 
This if the formula I want to use:
 
({GLAccount.AcctType} = "1") or ({GLAccount.AcctType} = "8") or ({GLAccount.AcctType} = "9")    //this is what I really want to do..
 
but it has no effect.
If I change that formula to just be the word true, it still does not work.  It appears that whatever I enter in the formula is ignored, and it is only looking at the value of the checkbox.
 
Am I missing something?
 
Thanks for any help.
Quinton
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 23 Nov 2010 at 8:45am
I would have tried a formula something like:
 
if ({GLAccount.AcctType} = "1") or ({GLAccount.AcctType} = "8") or ({GLAccount.AcctType} = "9" then
  {table.field} * -1
else
  {table.field}
 
 
I believe you could also code this as:
if {GLAccount.AcctType} in ["1","8","9'] then .... I might be slightly off on the syntax, but Help should have it.
 
HTH
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.