How to show and hide group header in Crystal Report

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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