Crosstab header and conditional formatting

[SF]

I have the following query from 3 tables (tblTimeSheet, tblTimwSheetDetail
and Employee)


Employee Dates WorkHours
AAA 12/1/06 7.5
AAA 12/2/06 8
.....

BBB 12/1/06 7.5
BBB 12/2/06 8
.....

from this query I can generate a crosstab for the report for each employee.
Normally, my organization pay schedule is from 20th of this month to 19th of
next month.

1 - my problem is to generate a sorting order on report header from 20th
December to 19th January

20 21 22 23 24 25 26 27 28 29 30 31 1
2 3 4 .....18 19

2 - I need to change the background color in saturday and sunday to grey,
how can I do this through code


SF

 

[Duane Hookom]

1- when you create a report, you have the ability to place text boxes and
labels where ever you want. I don't understand why you are concerned about
something that you should be determining.
2- You may need to write code in the on format event of a section to look at
the control source or whatever to see if the date is saturday or sunday and
set the background property accordingly.