Nested groups in Crystal Report

[New2CR]

is there such thing called nested groups in Crystal Report? If there is, how do i design one? Thanks in advance.

 

[FoxG]

Hi,

If you have fields:-

occupier, houseno, street, town, postcode,

then you could create a report which would group the details to be displayed by street within town

If you add all the fields to your detail section, and just run the report the records will just in database order.

If you insert a group based on the town, the records will be in database order within each town. By default, the town field value will be used as the header for each group.

If you insert another group based on street, the records will be in database order within each street, and all the streets for a given town will be grouped together.

You can then if you wish use the sort records feature to ensure the occupiers are in alphabetic order.

Hth,
Geoff

 

[New2CR]

Hi,
Thanks a lot for the reply. I've tried designing the nested groups using your example and it works really well. The result i get is something like this:

Occupier HouseNo Postcode
TOWN1
Street1-1
Occupier1 1 XXXXX
Occupier2 2 XXXXX

Street1-2
Occupier3 3 XXXXX
Occupier4 4 XXXXX

TOWN2
Street2-1
Occupier5 5 XXXXX
Occupier6 6 XXXXX

Street2-2
Occupier7 7 XXXXX
Occupier8 8 XXXXX

Anyway, I was thinking of doing something like :

TOWN1
Street1-1
Occupier HouseNo Postcode
Occupier1 1 XXXXX
Occupier2 2 XXXXX

Street1-2
Occupier HouseNo Postcode
Occupier3 3 XXXXX
Occupier4 4 XXXXX

TOWN2
Street2-1
Occupier HouseNo Postcode
Occupier5 5 XXXXX
Occupier6 6 XXXXX

Street2-2
Occupier HouseNo Postcode
Occupier7 7 XXXXX
Occupier8 8 XXXXX

Is this possible? Can you show me how?

-New2CR-