Re: Crystal isnull hell!

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

nafelloyd <nafelloyd@xxxxxxxxx> rambled:
>
> I think there is a really simple answer to this question, but it's
> beyond me! I'm trying to create a formula to see whether or not a
> field isnull before adding it to the report:
>
> if isnull({ProductGroupInvoiceLines.ChargePer}) then
> {CustomerInvoiceLines.ChargePer}
> else ({ProductGroupInvoiceLines.ChargePer})
>
> if it's null then return the other value, if it's there then return
> it.

It's not working for you? Is there an error message?

If it's "not working", perhaps {CustomerInvoiceLines.ChargePer} is also
NULL. Try replacing that with a string, like "NULL TEST" or something. This
will tell you if your formula is working or not.

--
KB

MCNGP #26
www.mcngp.com is real.


.

Relevant Pages

  • Re: AND/OR Statements
    ... hmmm....seems to get an error message using that string. ... what do the brackets represent? ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Why String is Immutable?
    ... >> Could we have a discussion on why String is Immutable? ... > Why replacing any digit in number will create another number (not ... the syntax sugar of operators can be applied ... Prev by Date: ...
    (comp.lang.java.programmer)
  • Re: index out of bounds of the array ?
    ... > I get an "index out of bounds of the array" error message re the line ... You're creating a string array called results, ... Prev by Date: ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Need help with simple class
    ... Can you provide some code and the error message? ... > Public Class Document ... > Public Property TitleAs String ... Prev by Date: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Error Message when trying to run System Restore
    ... I receive the following error message when I try to run System Restore on my ... System Restore Application has encountered a problem and needs to close. ... I have already tried replacing the srrstr.dll and rstrui.exe file ... Prev by Date: ...
    (microsoft.public.windowsxp.help_and_support)