Display Record Result From Fomula??

[pcollins1]

I have a report that is displaying the detail for items sold vs available quantity. I have a running total formula that tracks when Item sold exceeds Qty_ON_HAND. This is based on a formula:
{IMINVLOC.QTY_ON_HAND}-{@RunningTotal}>=-1.

This gives me a True/False response sorted by ship date. I would like to only display the detail for all the orders = True, but I cannot figure out a way to make it work?

Is there a way to do this?

Thanks,

 

[dgillz]

Your formula will be a true/false result, because

{IMINVLOC.QTY_ON_HAND}-{@RunningTotal}>=-1

Either will or will not be greater than or equal to -1. You most likely want this to be a record selection formula instead of a formula on the report canvas.

Also, it looks like you are a Macola user. If so why is the field name IMINVLOC.QTY_ON_HAND as opposed to IMINVLOC[red]_SQL[/red].QTY_ON_HAND?

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[pcollins1]

Right, it is Macola using the older Pervasive Databases.
How can I make a record selection formula to show this. It will not let me create record selection using the formula. The message I receive is cannot use formula in formula, it must be evaluated later!

Any other ideas?

 

[dgillz]

Please show the formula for{@runningtotal}.

It does not matter if you are using the Pervasive version of Macola, you should ALWAYS, 100% of the time use the _SQL table names. They stopped updating the non _SQL tables in 2000 or 2001. Also, this is here to facilitate a conversion to SQL when the time comes. Without doing this you have a ton of crystal rewrites to do.

I quite using the non _SQL table names in 1998.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[pcollins1]

{@runningtotal)
RT ("Amount","Sum",{OEORDLIN.QTY_ORDERED},{IMINVLOC.ITEM_NO})

 

[dgillz]

Where on the report is the field {@running total} placed? What version of Crystal?

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[dgillz]

I had to look up the RT() function. Why are you not using a running total field? You must be on an old version of crystal as well.

At any rate, you won't be able to perform a record selection to do this, because as soon as you limit your record selection in any way - say specific to one customer - you change your running total field results. So in my example the single customer could show that all items are available when in reality they are not.

So you will have to use the same formula you currently have to conditionally suppress the records you don't want to see.

If you have any questions, please post back.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[pcollins1]

SLSID ITEM_NO PROMISE_DATE QTY_ON_HAND ORDER# Line# Bill_TO
BC 1.5S1432 20070906 51,500 134576 1 ABC Co.
BC 1.5S1432 20070906 51,500 134576 2 ABC Co.
DK 1.5S1432 20070910 51,500 136240 1 XYZ Co.


@READY_TO_SHIP QTY_ORDERED RUNNING_TOTAL
TRUE 28,800 28,800
TRUE 22,500 51,300
FALSE 10,500 61,800

 

[dgillz]

Did you try the conditional suppression formula I mentioned?

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[pcollins1]

Thanks, that seems to be working. I am just checking some values to compare against.

 

[dgillz]

As a sidebar: You know how to convert those Macola YYYYMMDD dates into real dates don't you?

NumberToDate({YourMacolaDateField})

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[pcollins1]

I do! Thanks for the help.