conditional help 1

[jomarelectric]

cr10


invoice invdate outvalue tax

C410947 12/21/06 621.73 87.04
C410949 12/23/06 66.60 9.33
C410960 12/29/06 -16.75 -2.35
X016120 12/08/07 -89.50 -12.53

my issue:

invoices w/ outvalues that begin w/ "-" and startwith "X" need to remain, but invoices w/ outvalues that startwith "-" and startwith "C" must be suppressed (so they're not part of my summary, etc).

these are grouped by salesrep.

i think that's straight forward, only i lack the experience to accomplish this.


as always, thank you.

 

[1973kk]

near the suppress section of the details or what ever place where u keep these values write a formula like this.
if ucase(left({invoicefld},1)) <> 'X' and
left({outvaluefld},1) <> '-' then true else false

here i am assuming out value field is a string. if its not then write as below
if ucase(left({invoicefld},1)) <> 'X' and
left(totext({outvaluefld}),1) <> '-' then true else false

 

[jomarelectric]

thank you, only this suppressed everything but invoices that startwith "X". i still neen to see invoices that startwith "C" where the outvalue dosen't startwith "-"

hope this is clear

 

[Madawc]

You want to show some details, but exclude them from the totals? You can do that with Running Totals. If you're not already familiar with them, the basics are explained at FAQ767-6524.

What you need to do is use the Evaluate / use a formula option and put your formula there.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Why not eliminate these records from the report? You could use a record selection formula like:

(
not({table.invoice} startswith "X" and
{table.outvalue} < 0)
)

If for some reason you need to retain these rows in your report, then use a detail section suppression formula like:

{table.invoice} startswith "X" and
{table.outvalue} < 0

Then as Madawc suggests, you would need to use running totals with an evaluation formula.

-LB

 

[jomarelectric]

yes, only i need to exclude (from the totals) the invoices that begin w/ "C" w/ and have an outvalue begining w/ "-".

three types of invoices:

0123456 - account type

C123456 - cash type (if the outvalue startswith "-", it's a canceled invoice & shoudn't be part of the total.

X123456 - this is a credit and should be included in the total. its outvalue will startwith "-"

hope i haven't over complicated a simple issue.

//frank

 

[jomarelectric]

i can't exclude it completly, it needs to be seen.

thank you

 

[lbass]

Sorry, I misread. The suppression formula should be:

{table.invoice} startswith "C" and
{table.outvalue} < 0

Then in your running totals you should use an evaluation formula like:

not(
{table.invoice} startswith "C" and
{table.outvalue} < 0
)

-LB

 

[jomarelectric]

ah, much better. thank you