Trouble using filtered groups RRS feed

  • Question

  • I am using Report Dsigner for 2005 in local mode.  I am trying to use filters on nested groupings and having trouble when the inner group filters results in no records.  It appears that the reneder inserts some king of null record.  Consider the following data set

    FieldA    FieldB  FieldC
    X                       0
    Y                       0
    Y           Test      1

    In  a table control I add two groups.  The outer group is grouping on Field A.  The inner group is grouped on field B and filters out records where Field C requals 0. I also set the visibility of the group to hide the group where the first record=0 though this should be unnecessary.

    I would expect to get three lines rendered; two for the outer group and one for the inner group (the 3rd record of the data set.  Instead I get four lines.  In other words the inner group renders a line for when FieldA=x even though no records meet that condition. 

    Has anyone run into this and perhaps has a work around.
    Monday, March 30, 2009 3:03 PM

All replies

  • I found a way.  I removed the filter and used a sum of field c for the scope of the second group on the visibility.

    Monday, March 30, 2009 3:57 PM