views:

308

answers:

2

Does anyone have a slick way of adding filler dots to a table of contents page in RS?

This would not be a problem were it using proportional fonts.

e.g.

Monkey.........5
House..........1
Tree...........11
Underpants.....2

Obviously the example above sucks as the font is proportional

A: 

I'm not sure whether this is helpful or not, but since you have control over the TOC, rather than building it as a single field, do you have the option to set it up as a table with three columns (the title, the dots, the page number)?

Whilst this would give you white-space between the title and the start of the dots, it would at least mean that the padding would be of a consistent length.

In this scenario, you could alternatively generate the dots as a patterned line inside the table cell, rather than with repeated characters.

Ed Harper
I don't want dots of a consistent length, I want them to go all the way from the item in question all the way to the page number.
adolf garlic
@adolf - in which case, I think you'll have to write a custom function which calculates the actual length of each line of the string given its font and point size, and pads it with the necessary number of dots to give an equal length. I'm sure I've seen examples of this kind of code, but I don't have any links to hand.
Ed Harper
A: 

This does not appear to be possible in SQL Server Reporting Services 2008.

adolf garlic