Problem with crosstab again

21 Views

I have a report based on a table:

DayInfo(Date date, name varchar, NeedWork boolean, CanWork boolean)

The report is grouped by months (a date grouping).

X-coordinate is NeedWork.Date

Y-coordinate is NeedWork.Name

Cells have DayInfo.NeedWork

I want to make a cell color depended on CanWork flag.

I do it this way:

<code>if {DayInfo.CanWork} then

(

Color(255,0,0)

)

else

(

Color(0,255,0)

)

</code>

The problem is: CanWork has the same value always, though the table has different values.

Even if I use not a color, but value output instead, the data appeared on report is the same:

02.02.3909 03.02.3909 04.02.3909 05.02.3909

Ivan 02.02.3909 02.02.3909 02.02.3909 02.02.3909

I want to see different dates:

02.02.3909 03.02.3909 04.02.3909 05.02.3909

Ivan 02.02.3909 03.02.3909 04.02.3909 05.02.3909

Question: Why it doesn't work and what to do?