t_pin0245

Hi all, for the reports I published into JasperServer, it always print "null" instead of actual string value of VARCHAR data type column. No such problem to print TIME/DATETIME data type column as I observed. Report was fine if print from editor JasperSoft Studio. I had tried to check on the properties/configuration files, but couldn't find any solution. Anyone know what's the cause of the problem and the solution to it? Much appreciated if anyone could help. Thanks in advance!

Hi zh3ntil, your suggestion is working fine for me! thank you! but there's another special case comes in, in my table, there are some record but with spacing as value. hence, if i use the (select count(*) ... where ...) as checkfield, which seems not applicable anymore since there's record selected. so how can i control it in this case? your help is much appreciated.

Hi manohar, but in my case, i wish to write the condition based on table in the detail band. for clearer view, please refer to the image below. what to do if i want to hide the band if the table(orange highlighted box) fetching empty record? Thanks TP

Good day, in my main report, there are numerous detail bands with table respectively. currently, the empty record band leaving a blank space in between, which doesn't look good at all. How can i hide or not showing the band whenever the table fetching empty record? Thanks TP