Results 1 to 2 of 2

Thread: How to suppress a running total field

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2005
    Posts
    43

    How to suppress a running total field

    I need to suppress a running field total from showing if a datafield is empty


    The datafield is {ControlHeadA.package}
    and the runningtotal filed is #Qvalue and located in the report footer

    I have tried this formula

    if {ControlHeadA.package} > "" then
    formula = True 'suppress the value
    Else
    formula = False 'do not suppress the value
    End If

    but get error message a number , currency..... is expected here

    Can somebody please help

  2. #2
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: How to suppress a running total field

    It seems the package field is numeric. Try

    Formula = {ControlHeadA.package} = 0

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