Skip to Content
0

How to show and hide group header in Crystal Report

Sep 13, 2017 at 12:04 PM

29

avatar image
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

groupby.png (29.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ian Waterman Sep 13, 2017 at 01:42 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 13, 2017 at 03:20 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Ian Waterman Sep 13, 2017 at 04:07 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded