Solved

Pentaho Reports

Posted on 2014-11-05
4
231 Views
Last Modified: 2015-05-20
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
0
Comment
Question by:Star79
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 32

Accepted Solution

by:
Daniel Wilson earned 500 total points
ID: 40430251
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
 

Author Comment

by:Star79
ID: 40433061
I did that but when we preview and the data is empty it leaves the empty spaces without deleting those spaces
0
 

Author Closing Comment

by:Star79
ID: 40448473
solved a part of the question
0
 
LVL 4

Expert Comment

by:Anthony Carter
ID: 40787899
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

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an explanation of a simple data model to help parse a JSON feed
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
Introduction to Processes

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question