<p>Hello,</p>
<p> </p>
<p>I have the following problem: I would like to illustrate a table in an report, which says, who already paid for something, who hasn't paid yet, and who paid too late. So I have, for example, the following result from my data set (query on db):</p>
<p> </p>
<p><strong>Name Month DayPaid LastChance</strong></p>
<p>Lisa January 0 20150131</p>
<p>Laura January 0 20150131</p>
<p>Tim January 20150108 20150131</p>
<p>Lisa February 20150301 20150228</p>
<p>Laura February 0 20150228</p>
<p>Tim February 20150315 20150228</p>
<p> </p>
<p>If someone paid punctual, the cell should be green. If someone hasn't paid yet (DayPaid is 0), the cell should be red. If someone paid, but too late (DayPaid is higher than the LastChange mark), the cell should be yellow. </p>
<p> </p>
<p>This should be the result:</p>
<p> </p>
<p><strong>Name January February</strong></p>
<p>Lisa red yellow</p>
<p>Laura red red</p>
<p>Tim green yellow</p>
<p> </p>
<p> </p>
<p> </p>
<p>How can I do that? the problem is, that the range of month should be dynamically over report parameters, it can be 2 months, but it can also be 6 months (but not more than 12 months, i checked this before with a plausibility, otherwise the page would be to small). It depends on how the user tunes it. </p>
<p> </p>
<p>How can I implement the range of month above and underneath it the cells with the colors??</p>
<p>I am at a loss.</p>
<p> </p>
<p>Thanks already for your help!</p>
<p> </p>
