Formatting Crosstab report

[acessn]

Using CR 9.0, Microsoft sql server 2000.

I've created a crosstab report displaying names, date, week number and shift start and stop times. Viewable here:

http://intime.no/temp/crosstab.pdf

What I would like to do is to format the vertical borders to be double when there's a new week. All I've managed to do is to double them on every day, and that's no good.

Any ideas?

Thanks,

Bjorn

 

[lbass]

As you probably have noted, format grid lines->line options->style does not have a double line option. As a workaround, you could copy the crosstab object and in the second crosstab, suppress all fields, labels and totals, and then overlay the second crosstab on the first, positioning it in a slightly different position horizontally, so that double lines result. You can then eliminate any unwanted lines in the second crosstab by selecting the line in the format grid lines section and unchecking "draw".

-LB

 

[acessn]

Thanks.

I'll give that a try.

-Bjorn