CODEWITHSUNDEEP
crystal-reports
DareDevil
DareDevil

Reputation: 5349

Crystal Report, Grouping Rows into single Row on the basis of Criteria

I have a crystal report, which shows different fruits data on the basis of Fruit Name Group.

I am attaching a screen shot which tells the clear requirement, I want to group same type of fruits merge all into one rows and sum of their values as well.

I need help, can someone suggest a better idea? Screenshot

Upvotes: 2

Views: 3076

Answers (3)

DareDevil
DareDevil

Reputation: 5349

I have done with other way, calculated these fruits values as a separate row, sum up all the values and then applying union , In union I have concatenated the fruit names using COALESCE function

Upvotes: 1

Siva
Siva

Reputation: 9101

I am  not able to understand completely you problem.. but try below solution: If it is useful use it else discard

Concatenate Fruit Names: Create one formula @Fruit

Local StringVar orange;
Local StringVar Lemon;
Local StringVar Grape;

if <<databasefield.fruitname>>="Orange"
then orange:=<<databasefield.fruitname>>
else if <<databasefield.fruitname>>="Lemon"
then Lemon:=<<databasefield.fruitname>>
else  if <<databasefield.fruitname>>="Grape"
then Grape:=<<databasefield.fruitname>>;
orange+Lemon+Grape;

Summing the values: Create one formula @Weight

Local NumberVar orange;
    Local NumberVar Lemon;
    Local NumberVar Grape;

    if <<databasefield.fruitname>>="Orange"
    then orange:=<<databasefield.Weight>>
    else if <<databasefield.fruitname>>="Lemon"
    then Lemon:=<<databasefield.Weight>>
    else  if <<databasefield.fruitname>>="Grape"
    then Grape:=<<databasefield.Weight>>;
    orange+Lemon+Grape;

Edit:------------------------------------------------------------------------------------ you need to have grouping something like below.

Fruit name  Fruit Type
Orange       a
Grape        a
peach        b
apples       c

now when you group by fruit type and apply the formula I have provided then you can get desired results

Upvotes: 1

Emanuele Greco
Emanuele Greco

Reputation: 12721

1) Add a Formula Field

This formula field, should return
- real FruitName for the cases you don't want to group,
- a fake FruitName for the rows you want to group together.

Something like this (drag'n drop fields into Formula editor): 

if {commandname.FruitName} <> 'Orange' AND  FruitName <> 'Lemon' 
   AND  FruitName <> 'Grape Friut' then  {commandname.FruitName}
else   'Orange, Lemon, Grape Friut'

2) use Group Expert to create a Group based on the new Formula Field

3) suppress details and show in Group Header or Group Footer Totals for each field

Upvotes: 1

Related Questions