ed4becky

This may be simple of impossible... I want to create a narrative report, which means its not a cell based excel like table based report, but one that has 1-n paragraphs of unknown size. The data is text. So one time I run the report I might have a 100 word, 10 line block of text todisplay. The next time it might be 500 words, 50 lines. An I don't know how to caluclate the lines. So, can jasper reports handle a fluid block of text, growing/shrinking as needed?

... or string concatenation. if ${P1} = 3, is the query: select type from hospital where id = ${P1} resolved to: select type from hospital where id + ${P1}.toString() or select type from hospital where id = ? with ${P1} bound to ? at run time.

I have done something simliar before: Select type from user where (type = $P{typeParam} OR $P{typeParam} IS NULL)

I have a conditional style that sets the background to red if a column field is above a certain threshold. Works fine. But I would like to generalize it - right now I have a style customized for each column (if $F{col1} < 0, if $F{col2} < 0…) How can I set a variable $V{temp} = $F(col1) before evauluating the style for col1, then $V(temp) = $F{col2) before setting the style for column 2, etc, So that I can generalize the consition to if($V{temp} < 0… Where would the setting of the $V value be put? I need it to potentially be reset as I process each (of 13) columns. Ed