report design

[Danny]

Hello,
I have a crosstab query based report, which I would like it to be similar to the attached word document.

1. Is it possible to make every other row to shade in a report (like the attached word document ) in Access 2000?

2. How do you add graph/chart or percent based on the result of the query in the report?

Thanks,
DD

 

[dcx693]

You didn't attach a Word document, so I don't know what the document will need to look like.

In general, the easiest way to shade alternate lines of a report is to place code into the OnFormat event of the report detail to tell it to set Me.Section(acDetail).BackColor to one of two colors, depending on what the current color is. You will need to set the Back style of your report detail controls to "Transparent" for the background color of the detail section to show through.

However, if you're doing a crosstab report, not sure what will need to be done. I don't usually do those.