Solved

Pentaho Reports

Posted on 2014-11-05
4
217 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
  • 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

ScreenConnect 6.0 Free Trial

Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
VB6 Compile Compatibility Issue 4 102
A string is required here error 20 19
SSRS - Image from DB has ugly blue border !? 8 32
Crystal Reports 2013 25 35
This article will show, step by step, how to integrate R code into a R Sweave document
A short article about problems I had with the new location API and permissions in Marshmallow
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

770 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