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

Said
Said 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_Schou
    Tommy_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
  • RobertMo
    RobertMo 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           
    ¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯
  • Said
    Said Member Posts: 20
    Thanks a lot guys. That really helped me. It's all working now. Thanks again...

Categories