Crystal Report Table of Content (TOC)

[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

 

[chelseatech]

What formula are you using to list the TOC now.

You might want to use a ReplicateString function to add a lot of "..." between the two values.

Editor and Publisher of Crystal Clear

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

 

[krisb14]

First its stored in an array and then we go back through and read the array. It's basically two large functions.

 

[AndrewBaines]

You can't just add a load of dots unless you're using a fixed space font like courier. Anything else and the letters will all bunch up differently.

All I can come up with is:
split the array into 2 arrays - one with the content name, the other with the page numbers.
Place the content formula inside a text object. Add loads of dots after the formula to more than fill the space.
Place the page number formula onto the form, over the text object, BUT not actually in the text object. You'll need to add it somewhere else in the same section, then move using the cursor keys. It needs to be above the text, covering the last few dots.
Change the formatting of the page number so it has a white background, and 'tight horizontal'. The page number will then hide any dots that aren't needed.
Not sure how well that will export, but should be fine on screen.

Andrew Baines

http://www.pursuittechnology.co.uk

 

[krisb14]

Thank you both very much!! We finally have everything working!!

 

[lbass]

krisb14, Please do not crosspost.

-LB

 

[krisb14]

I first thought I posted in the wrong area and wasn't sure how to remove. I appologize for cross-posting...