Symptom
Hierarchical grouping is needed for the left column to show
record dependencies within a group. (ie. Employee ID
2 has Employee 1 as a supervisor and Employee 3 has Employee 2
as a supervisor) However, the hierarchical grouping
option indents all columns in this section rather than 1
field only. This behavior is undesirable because
the columns, at different levels in the hierarchy, are no
longer left-aligned which makes it hard to read the data.
Cause
Shifting the entire section is the default behaviour for
hiearchical grouping when it is implemented in the following
manner:
-Under the Report menu select Hierarchical Grouping
Options.
-Under the Parent ID drop-down, select the hiearchy
field.
Resolution
It is possible to apply hierarchical indentation to specific
fields with the following steps:
1. Under the Report menu select Hierarchical Grouping
Options.
2. Under the Parent ID drop-down, select the hiearchy
field.
3. Also in the Hierarchical Grouping Options dialog set the
"Group Indent" attribute to 0 then click OK to set the
changes.
4. Right click the section and choose Section Export. In
the Section Expert dialog hilight the group where hiearchical
grouping is applied.
5. Uncheck 'Relative Positions' and click OK to set it and
close the dialog.
6. Right click the field to be indented and
choose "Object Size and Position". Press "X-2"
beside the X: field and enter the following formula in the Formula
Editor:
numbervar hLevel
:= HierarchyLevel
(GroupingLevel({hierarchicalGroupingField}));
numbervar deltaX
:= 0;
if (hLevel > 1)
then
deltaX :=
(hLevel - 1) * 0.4;
deltaX := deltaX *
1440;
7. Save and close the formula editor.
Any field where this size and position formula is entered
should show the data indented according to the level within the
hierarchy. However, all fields that do not have this formula
applied will remain in their original alignment.
Keywords
hierarchical grouping, alignment, left align, hierarchy, section,
entire section, one field only, shifts right, misaligned, crystal
reports, indent, indentation.
, 9229491 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
SAP Crystal Reports XI ; SAP Crystal Reports XI R2