Pentaho Reports

Please find attached screenshot of my report requirement.
I need to create the same in the pentaho report with data and label been made invisible if data is not available.
Please let me know how to handle this in a smart way.
Thanks All.
Capture.PNG
Star79Asked:
Who is Participating?
 
Daniel WilsonConnect With a Mentor Commented:
Your data and label have a Visible property.  Put a formula in there ... something like

If(strlen(datafield)>0,True,False)

I'm a bit rusty on the syntax, but that's the basic idea.
0
 
Star79Author Commented:
I did that but when we preview and the data is empty it leaves the empty spaces without deleting those spaces
0
 
Star79Author Commented:
solved a part of the question
0
 
Anthony CarterCommented:
Hi,

I know this might be a bit late, but you could put each data/label inside a band and use the visible property on the band rather than on the object.  That way the whole band gets hidden.

There is also the option to remove whitespace property (can't remember of the top of my head) that would then collapse any gaps.
0
All Courses

From novice to tech pro — start learning today.