Crystal Reports Table of Contents

[krisb14]

Does anyone know how to create the "Leading Dots" for a Table of Contents within Crystal? I have successfully created the TOC but need to know how to add in the "....."
Any assistance would be GREATLY appreciated, thanks!

Example:

Dr. Jason Smith...........67
Dr. John Doe..............45
Dr. Alvin Chip.........23,67

The current TOC is just
Dr. Jason Smith 67
Dr. John Doe 45
Dr. Alvin Chip 23,67

 

[CRCRCR]

You are going to have to use the string functions.

Length

and

ReplicateString


find the length of your string, for example the "23,67" would be five 5.

then figure out how long you want you "........23,67" to be.
say 12
then do something like

replicatestring(".",(12-(length({field}) ) ) & {field}

field being whatever creates the "23,67" string

If the Doctors name is part of the string your gonna have to deal with the whole string, using functions, its going to be a bit more complicated.

Its difficult to tell the case from your question.

Hope that helps.

K.