How to create sub report

Question

Hi,
i have a database table which contains multiple records i mean repeated records
looks like..

unitid-invoiecNo-itemdate
1 2 12-12-2012
1 3 12-12-2012
1 4 12-12-2012
1 5 12-12-2012
2 6 12-12-2012
2 7 12-12-2012
2 8 12-12-2012
2 9 12-12-2012

now i want in this view condition

unit: 1 total:4
invoice-itemdate
2- 12/12/2012
3- 12/12/2012
4- 12/12/2012
5- 12/12/2012
unit: 2 total:4
invoice-itemdate
6- 12/12/2012
7- 12/12/2012
8- 12/12/2012
9- 12/12/2012

means when second unit start it should create header for that unit and then record of that unit...

please help me

Prabhu Raja · Answer

Hi, Actually for this requirement, you don't need to include sub Report. You can do this from being in main Report Also. From my Point, 1) Use Group Name Field in Crystal Report, and Create a Group Based on UnitId. 2) use Running total Fields, to display total records in each Group. I have attached a Crystal Report , Hope this will be useful.

Prabhu Raja · Answer

Hi, Actually for this requirement, you don't need to include sub Report. You can do this from being in main Report Also. From my Point, 1) Use Group Name Field in Crystal Report, and Create a Group Based on UnitId. 2) use Running total Fields, to display total records in each Group. I have attached a Crystal Report , Hope this will be useful.

Pravin Ghadge · Answer

hi There r 2 ways to accomplish ur task. 1)U can add group in ur crystal report.(Group by unitid) 2)U can use subreport in ur crystal report. Subreport: U just have to insert the subreport in crystal report & then insert the invoiecNo & itemdate fields in ur subreport.