Print when expression question

[ozrebel]

Hi there

I posted this a week or so ago, but so far no luck, so I thought I would try again. Does anyone have any idea on the issue below?  Thanks in advance.

I am tring to achieve a couple of things with a table I have in a report.

The first is if a field in a record exceeds a particular value I want to print another row below that row with some warning text in one field, and another value in another field.  I have tried to achieve this using groovy, and have tried the following without any luck:

AND($F{Stats_Days}>=250)||"305 days due"

The second thing I want to achieve might not be possible, but again, if a field exceeds a particular value I want to add another row with some different data.

Any help or advice would be gratefully received.

Cheers

Tony

 

[hozawa]

Have you tried using sub-reports with print when expression?

[ozrebel]

Thanks for the reply.

 

I probably also should have said that I am using a table.

 

In the end it was easier to create a query in sql to get exactly the data I needed. Thanks for taking the time to reply :-)

 

Tony