Indenting on some columns

[yehong]

CR8.5. I am using Hierarchical grouping options for an employee hierarchy report. I have 5 columns first column is FName+LName and there are four other columns. When I set the indent to .5, it indents all columns. All I want is to indent FName+Lname column and other columns should appear without any indent. I don't find any option in Crystal. Is there a way to do that?

 

[synapsevampire]

Right click the column and select format field->Paragraph formatting->Indentations.

I wasn't aware that one could set the indent for all columns at once.

BTW, since the column is always indented, why not just move it over a bit?

Or I'm not understanding your question...which seems likely.

-k

 

[yehong]

Let me post the current out put and the out put desired.

Name HireDate Salary
FLname1 04/02/03 $3500
FLname3 02/04/02 $2400
Flname4 01/02/03 $1300
Flname5 02/04/04 $2600
Flname13
FLname7 03/09/01 $1600

This is desired out put:
Name HireDate Salary
FLname1 04/02/03 $3500
FLname3 02/04/02 $2400
Flname4 01/02/03 $1300
Flname502/04/04 $2600
Flname13
FLname7 03/09/01 $1600

By going into Paragraph Formatting -->Indentations, I tried setting it to different values, but no effect.

 

[synapsevampire]

Current output doesn't help if I don't know which level this output is in, what the fields are in the table(s), plus formatting gets skewed when posting.

I'll take one last stab without technical information:

Group by the Manager ID
Place the name formula in GH 1

Group by the employee ID
Place the name formula in the GH 2 only shifted to the right a bit.

Align the hire date and salary fields in the GH1 and GH2

Should work.

Now if you'd like to post moire information, please post:

Crystal version
Database/connectivity used
Example data (not what you're currently outputting which is wrong, that doesn't do any good, what's actually in the tables)
Expected output (which you've done a reasonable job of so far).

-k

 

[yehong]

CR8.5. In the Hierarchical grouping options I have set the Group Indent to 0.5. Lets remove Date field and look at this current out put.

Name Salary
V.Thomas $3500
T.Jester $2400
S.Smith $1300
A.Fleming $2600
S.Alan $5500
T.Sharpe $1600
You would notice that both columns get indented.

Desired Output

Name Salary
V.Thomas $3500
T.Jester $2400
S.Smith $1300
A.Fleming$2600
S.Alan $5500
T.Sharpe $1600

You would notice that Name column is still indented, but Salary column is not. This is how the out put should be.

 

[chelseatech]

We published this in our newsletter back in Issue 28 (August 2002) of our Crystal Clear Newsletter.

You need to use variables to keep track of the levels.

I can send you the issue and the sample report if you email me at
bruce@chelseatech.co.nz

(Anyone else can have a copy as well)

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[yehong]

Bruce,
I have e-mailed you at your above e-mail address. I hope to get the sample soon.
Thanks,