Hierarchical Reports

[sixtoesofdean]

I'm trying to convert an existing report to show data hierarchically. After looking at other examples of hierarchical reports it seems to me that in order to get crystal to report in this manner I have to:

group on the child key - eg 'orgID'
order on the child key - 'orgID'

in the hierarchical grouping options I then set parentID to the parent id of 'orgID' - lets say 'ParentOrgID' (noting that the 'orgID' field is available in the 'Available Groups' list).

However, when I try this Crystal simply crashes. Joy. Is there a reason for this - perhaps a subtley in the way I build up the query ? Presently there are 3 tables in the query, of which the table I'm trying to view hierarchically IS NOT the main table (though I wouldn't have thought this would matter)

Tbanks in adavance.

 

[IdoMillet]

Make sure that in your data, no OrgID is the parent of itself...

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[sixtoesofdean]

Data seems fine. I've got round the problem for the timebeing by creaing a view so that everything comes from one place. Though this works its still giving me gried though I'm sure this isn't Crystals fault

Cheers.