grouping of fields based on a unit price in a subreport of crystal report

[shil123]

In the below picture I have two items,whose cost values are different and the respective unit of the cost is also different

I want the output , like I have shown in the below picture

The detail part should split based on the cost unit,how can i do this ?

I am trying to do in subreports and i am not getting how to insert group inside of subreports?

[former_member280812 · Accepted solution]

Hi,

Try to make a 2 group.

1. Group by item no.

2. Group by unit

And then make a summary for the cost and the summary location is in the group footer of the 2nd group. And then drag that summary field going to the header of the 2nd group and place all your necessary field in this area. And then suppress all section except the header of the 2nd group.