CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5

Threaded View

  1. #1
    Join Date
    Feb 2011
    Posts
    57

    How to exclude combinations of certain lines?

    I have a report that is grouped twice.

    At job then at task. I am trying to excluded when two fields are zero. But I get a mess of results.

    A b c

    GF2 task1 5 6 0
    GF2 task2 0 2 0
    GF2 task3 8 0 1
    GF2 task4 0 7 2

    GF1 Total 13 15 3

    How would I excluded line only task2? When A and C are zero?

    I tried at the GF2 but task(s) 1, 2 and 4 would disappear if I did " (Sum ({vdvProjectLines.numJobTRXNActlCost}, {vdvProjectLines.chrTaskNumber}) > 0
    and Sum ({vdvProjectLines.numJobTRXNRvEstSal}, {vdvProjectLines.chrTaskNumber}) > 0)"


    Thanks for your advice.
    PN
    Last edited by PNorm; March 21st, 2011 at 02:19 PM.

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

Featured