Format Multiple Columns Colour

[MadCatmk2]

Hi all

Crystal Reports 9
Access 97 Database

Hopefully a simple one to answer.
I have a report set up that has the details section split into columns. Is it possible to set the columns to different background colours similar to what can be done with groups. i.e. first column white, second grey, third white etc.

Any help is greatly appreciated.

Thanks

 

[Thadeus]

Why not just draw a grey colored box in the details section? This would definately achieve your desired result.

~Thadeus

 

[dpatrickcollins]

Got one for you, I think. Place a box on your report, extendiing it across the section just above to the section just below your multi-column report. Format the box with a color. The box should horizontally extend the width of one column. Repeat the process for each column.

 

[MadCatmk2]

Thanks for the suggestions people. This certainly gives me a grey box round the column. What happens is that this grey column repeats to the three columns. what i need is for the middle column to be a white box.

Thanks for your help so far, if anyone could suggest how to make the colour alternate for each column then that would be perfect.

Thanks again.

 

[lbass]

If you know the number of lines per column (using recordnumber or a variable for line count), you could go to format->section->details->color->background->x+2 and enter:

if recordnumber in [1 to 45, 91 to 135] then crGray else
crwhite //assuming 45 records per column

Adjust the numbers to reflect the number in your columns.

-LB

 

[MadCatmk2]

Thanks for all your help. I have the problem resolved now using a method similar to LB's

Cheers

 

[Thadeus]

Just to note, I mis-spoke when I said "draw a grey colored box in the details section"... It should have been more descriptive such as dpatrickcollins stated.

will work:
Drawing a box that extends outside the details section will give you the alternating color-columns. Then you do not need a formula.

won't work:
Drawing a box 'in' the details section will give you the same box repeated over and over in each column.

~Thadeus