Skip to Content
avatar image
Former Member

How to show and hide group header in Crystal Report

groupby.png

Hi,

I have sample report that I attached would like to know how to recreate in crystal report.

I have part of the report that requires grouping and another part that does not require grouping.

I tried suppressing the header with formula but that did not work.

Any help will be greater appreciated. I have been working on this all day.

Thanks

groupby.png (29.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 13, 2017 at 01:42 PM

    You will need to use a formual to define group.

    This assumes that Sugars and Metals have another group which defines group.

    Formula will be something like

    If Groupield in [''METALS', 'SUGARS' then Groupfield else DetailField

    If you do not have a group field then you will need to define group manually in a formula

    If DetailField in [ Sugars list} then 'SUGARS

    else

    If DetailField in [ Metals list} then 'METALS'

    Else DetailField

    Insert a group using this formula

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2017 at 03:20 PM

    Thanks Ian for your reply

    I am not sure which data will need to be grouped since it is data from the database.

    Is there a way to count the column and if it is more than one, group it otherwise shows the detail.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 13, 2017 at 04:07 PM

    Not that i know of.

    Can only suggest you get to understand your database, use a simple query tool like SQL Developer for Oracle or MS management Studio for MS SQL server.

    Ian

    Add comment
    10|10000 characters needed characters exceeded