Results 1 to 2 of 2

Thread: Crystal* Formula help please

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2005
    Posts
    43

    Crystal* Formula help please

    I have a crystal report where I group by case number.
    The idea is to print a message beneath each group if there is a carton#

    Packing note print after every case the following;
    Qty Description Weight
    5 External Modems .3
    7 Keyboards .2
    6 Harddrives 1
    All above packed into Carton# 1

    4 Motherboards .4
    3 Internal Modems .2
    6 Boxes CD-R 1

    All above packed into Carton# 2

    The above is fine but if items are not packed into a carton then the following still prints but without the carton #

    2 Monitors 5.3
    1 HP Printer .9
    All above packed into Carton#

    How do I adapt my formula not the print the message if the Carton# fileld is empty?

    My formula currently is:
    "All above packed into Carton# " & {Details.caseno}

    Suppose should be some thing like:

    "All above packed into Carton# " & {Details.caseno} where {Details.CaseNo} > ""

  2. #2
    Lively Member
    Join Date
    Mar 2006
    Posts
    94

    Re: Crystal* Formula help please

    Code:
    if isnull({Details.caseno}) then
    
    ""
    else 
    
    "All above packed into Carton# " & {Details.caseno}
    or something similar. It also might be

    Code:
    if isnull({Details.caseno}) or {Details.caseno} = 0 then
    ""
    else 
    
    "All above packed into Carton# " & {Details.caseno}
    depending on that the field contains.

    HTH
    Energy can be neither created not destroyed. It can only be wasted.

    Red Green

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width