Crystal Reports 10 Need Formula

[mcole22]

I need a formula like below, just not sure what to put after the else.

if {IMRECHST_SQL.qty_received} is <=0 then 0 else (in this I want the actual amount received {IMRECHST_SQL.qty_received}

What I am getting in the received qty is, if the qty was received it is showing -450 and if it hasn't been received it is showing 450 and I want this latter part to show 0.

I tried it like this - if {IMRECHST_SQL.qty_received}<= 0 then 0 else {IMRECHST_SQL.qty_received}. But it came up with this error - The formula result must be a boolean

 

[synapsevampire]

Where are you placing this formula (the obvious question)???

Posting thesoftare used,database and connectivity always helpsaswell.

if {IMRECHST_SQL.qty_received} is <=0 then
0
else
IMRECHST_SQL.qty_received}

Place this as a conventional formula and it will work in lieu of your received field(Detailssection).

-k

 

[mcole22]

When I put this formula in it gives me an error saying the keyword "then" is missing. I am using Progessive Explorer database and Crystal Reports 10

 

[groundclutter]

Make sure you are using "Crystal Syntax" and take out the 'is'...

if {IMRECHST_SQL.qty_received} <=0 then
0
else
IMRECHST_SQL.qty_received}

 

[dgillz]

The application you are using Progression Explorer, there is no such thing as Progressive Explorer.

I happen to make my living with this particular product.

The database is either Pervasive/Btrieve or MS SQL.

I also need to know - like in the original post - where this formula is located. How did you create it?

If you are going to report, selection formulas (as I suspect) this is the wrong place to do this.

You need to create a new formula field. Do you know how to do that?



Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mcole22]

I am working with Progression Series 7.6.400 SQL
I created a new report field in alerts not in report select
also using CRYSTAL SYNTAX

this is how I put it in.

if {IMRECHST_SQL.qty_received}is >= 0 then 0 else
{IMRECHST_SQL.qty_received} Got error keyword then is missing and then I also tried it without the (is) and got error formula result must be a boolean.

I do not understand what I am doing wrong???

 

[Turkbear]

Hi,
If this is actually intended to be a Report Alert then the condition MUST result in TRUE or FALSE ( a boolean)...

If just a regular formula, it does not belong in an Alert but in the report body somewhere ( like in the details)..

In which case it would be:
@ThisFormula

if {IMRECHST_SQL.qty_received} >= 0 
then 
0 
else 
{IMRECHST_SQL.qty_received}

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[dgillz]

Get rid of the word "is".

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[dgillz]

Sorry I just re-read your post. If you are making a report alert the yes this must be a boolean, that is to say it must evaluate to true or false.

Your formula evaluates to 1 or 0.

If you want this formula to show on your report somewhere, you should be creating a new formula field, not creating an alert.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry