How do I exclude lines with zero values in every column?

SaidSaid Member Posts: 20
edited 2004-05-04 in Navision Attain
How do I exclude lines with zero values in every column in my report?
I've tried to set PrintOnlyIfDetail Property to Yes but that didn't work...

Thanks in advance...

Comments

  • Tommy_SchouTommy_Schou Member Posts: 117
    If I understand correctly then you want to skip a line in your report where all fields containing a value is zero.

    The way to do this could be to enter code on the OnAfterGetRecord - trigger that reads something like this....

    If (field1 = 0) and (field2=0) etc. etc. then
    currreport.skip.

    That will skip the line in your report.
    Best regards
    Tommy
  • RobertMoRobertMo Member Posts: 484
    Property PrintOnlyIfDetail means that if set to Yes,
    the section of a dataitem is printed only if subdataitems also have at least one record.

    If you use it like this:
    -Item
    --Item Ledger Entry

    If you set PrintOnlyIfDetail=Yes Then items without ILE will not be printed, if PrintOnlyIfDetail=No also Items without ILE are printed.
    (Item2 is printed or not)
    Item1
      Entry7
      Entry12
      Entry43
    Item2
    Item3
      Entry34
      Entry56
    
               ®obi           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • SaidSaid Member Posts: 20
    Thanks a lot guys. That really helped me. It's all working now. Thanks again...
Sign In or Register to comment.