Formula query for crystal report

Yahoo Archive
1
Rodney,
If the InvoiceHead.InvoiceAmt is indeed blank as opposed to zero, then you could use a formula that says:

if isnull(InvcHead.InvoiceAmt) then 0 else InvcHead.InvoiceAmt

For your second part of the question, you could then do a running total or summary operation on the above formula and place that new running total in the Group Footer section of the Sales Order Group.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Rodney Warwick
To: 'e-Manufacturing User Group'
Sent: Friday, May 17, 2002 3:11 AM
Subject: [Vantage] FORMULA QUERY FOR CRYSTAL REPORT



I've created a Crystal Report that lists Jobs and corresponding Sales Orders
for a specified Customer. It also lists the Invoice Amount that relates to
that
Job/Sales Order using the "InvcHead.InvoiceAmt" field. If no invoice exists,
the field is blank. I'd like to insert a formula that would produce a "0.00"
as opposed to a blank space. I would also like to insert a formula that
accumulated invoice amounts, if there was multiple Invoices relating to the
one Sales Order (for example in an Advance Billing situation). Does anyone
know how to write such formulae?

Kind Regards

Rodney Warwick
The Signcraft Group
Melbourne, Australia

Yahoo! Groups Sponsor
ADVERTISEMENT




Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
2
I've created a Crystal Report that lists Jobs and corresponding Sales Orders
for a specified Customer. It also lists the Invoice Amount that relates to
that
Job/Sales Order using the "InvcHead.InvoiceAmt" field. If no invoice exists,
the field is blank. I'd like to insert a formula that would produce a "0.00"
as opposed to a blank space. I would also like to insert a formula that
accumulated invoice amounts, if there was multiple Invoices relating to the
one Sales Order (for example in an Advance Billing situation). Does anyone
know how to write such formulae?

Kind Regards

Rodney Warwick
The Signcraft Group
Melbourne, Australia