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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Daniel WilsonCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.