Skip to Content
avatar image
Former Member

Suppress previous group footer

Hi,

I have to compare 2 group footers to eachother.

When some values in the group footer are the same both group footer must be suppressed.

- I can put the values from group footer 1 into some variables.

- Compare the variables with the values in group footer 2.

- suppress group footer 2 when the values are the same.

But how can i suppress the first group footer?

With records i can use previous and next, but is it also possible with group footers?

Maybe there is someone who can help me with this. The only thing i think i can do is add the groupings to a sql-command and handle it like records, but when we do this the whole report must be rebuild.

Joris

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Sep 30, 2008 at 02:46 PM

    Joris,

    Unless the objects in GF6a are database fields then I don't think you are going to be able to compare the values within a single report.

    You could insert a subreport in the Report Header that duplicates the structure of the main report and hold the GF6a values in an array that is then passed back to the main report. Set up a counter in GF6a that you can use to reference the elements of the array and compare say array[x] to array[x+1]. If they are equal then suppress.

    You can suppress all of the sections in the subreport, set the subreport to suppress when blank, and set the section the subreport is in to suppress when blank as well to keep it from appearing but still allowing it to process.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Oke,

      But the problem is when we have 2 group6's.

      We must see them both or we must see nothing.

      We not compare the group6's on all the fields, so there is difference between the 2 rows.

      So moving the field in group5 is no option, because after that there is no option to see both rows.

      If there is any option to suppress a whole group including subgroups the problem is solved.

      Edited by: Joris Stoop on Oct 1, 2008 9:26 AM

  • avatar image
    Former Member
    Sep 30, 2008 at 01:50 PM

    I'm unclear as to the report structure

    Do have something like example 1

    detail

    detail

    GROUP #2 totals

    more detail

    detail

    GROUP #2 totals

    GROUP #1 totals

    or something like example 2

    detail

    detail

    GROUP #1a

    GROUP #1b

    detail

    detail

    GROUP #1a

    GROUP #1b

    As far as I know next and previous will not work in group totals

    Thanks

    Richard

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 30, 2008 at 02:01 PM

    The report looks something like this:

    GROUP #6a

    GROUP #6a

    GROUP #6a

    GROUP #6a

    GROUP #6a

    GROUP #6a

    GROUP #4

    GROUP #2

    The problem is that i want to compare the GROUP #6a to each other.

    When two of them are the same, suppress both

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Tricky one.

      Only thing I can think of is to create a formula field based on a concatenation of the values that you need to compare to each other in Group #6a.

      E.g. your totals in the group might contain an Account Name and a Sort Key. So create a formula called @group5 which would be Account Name + Sort Key . You would need to pad out the Account name and sort key to their max lengths with spaces.

      Then insert another group into the report grouping on the @group5 formula field.

      Copy the field values you were displaying in group 6 into the group 5 footer section.

      Hide the Group#6a group footer completely and use the group5 one instead.

      So now you should only see unique report footer sections.

      I'm kind of thinking aloud but does this work?

      Thanks and good luck

      Richard

  • avatar image
    Former Member
    Sep 30, 2008 at 02:29 PM

    Oke, that's clear to me, but when i do that how can i suppress both group footers.

    Can i do this with previous and next?

    And can I use strings within running totals?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 30, 2008 at 02:42 PM

    I think I understand your theory, but after that you have all unique footers.

    The problem is when two footers are the same, I want to suppress them both.

    Not one of them.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi..

      For each footer you need to check the running totals and apply the suppress condition.

      Regards,

      Sastry