Space fillers

[darrylmoore]

I'm trying to create a table of contents report. I'm reading in the topics from an access database that will be listed on my report. How can I format the topic items to inlcude periods that will act as space fillers on my report. Please see the example below:

1. Topic #1........................... page 1
2. Topic #10.......................... page 11
3. Topic #100..........................page 23

Is there a special format command that I can use?

Thanks for any help,
Darryl

 

[synapsevampire]

Here's a whitepaper on building a TOC, however the version of Crystal is important to post.

http://support.businessobjects.com/library/kbase/articles/c2011950.asp

Assuming that you're using a formula, and that the intent is to make the page x all align, determine the length you wish to have for this and then use something like:

replicatestring(".",60-(len({topicformula})+len({pagenumberformula})))

This would build 60-the number of characters used in the text portion of the displayed line.

-k

 

[darrylmoore]

-K,

The example you provided worked like a charm. Thanks for your help.

Darryl