Skip to Content
0
Former Member
Aug 10, 2016 at 06:51 AM

Crystal reports - Multiple groups from same dataset

1844 Views

Hi Experts,

I have the following issue. I am working on a report that contains both regional and country information in the same result set.

Country

Amount

Asia pacific

1000

China

500

Indonesia

250

Philippines

250

Europe

2000

France

750

Germany

1000

Poland

250

I would like to create 2 separate groupings that contain the overview of regions and the overview of countries by also taking the suppression into account of one of the countries.

Expected result:

Group1

Country

Amount

Asia pacific

1000

Europe

2000

Group2

Country

Amount

China

500

Indonesia

250

France

750

Germany

1000

Poland

250

Currently happening:

  • Created 2 group headers
  • Created formula to suppress country and added to group header 2:

if trim({Country}) = "Philippines" Then true else false

Result:

Country

Amount

GH1

Asia pacific

1000

GH2

China

500

GH2

Indonesia

250

GH1

Europe

2000

GH2

France

750

GH2

Germany

1000

GH2

Poland

250

I am unable to split the data in 2 groupings. I hope you are able to provide some advice


Thank you, Kr-