jasperoily
-
Posts
8 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Everything posted by jasperoily
-
Print When Expression - when (field data) != (field data)
jasperoily replied to jimh_1's topic in Products
You are welcome, All the best for the rest. -
Print When Expression - when (field data) != (field data)
jasperoily replied to jimh_1's topic in Products
Good to hear that the Lag function is working. Since you want only new item to be displayed, that is if the current row is not equal to previous row. So all you need to do is put the condition for the details band. It should work. -
Print When Expression - when (field data) != (field data)
jasperoily replied to jimh_1's topic in Products
WOW if it is Oracle Database then you can use the Lag function to compare the previous value with the current value. For example with lag you will end up getting rows as below Previous Row Current Row NULL B B C C C C D so in jasper in the print expression compare Previous Row != Current Row with an additional condition for handling the first row which will have no previous value -
Print When Expression - when (field data) != (field data)
jasperoily replied to jimh_1's topic in Products
Ideally that should be done in the query itself. Which is the database that is being used ? -
Print When Expression - when (field data) != (field data)
jasperoily replied to jimh_1's topic in Products
Are you trying to compare the previous row value with the current row and show it only if they are not the same -
We are using openoffice 3.3 and facing a formatting issue.On ODT preview of a Jasper report (version 3.7.5) it is found that content in the ODT table is not growing dynamically. That is content gets cut off when it exceeds the width of the table column. This happens only for ODT preview. PDF preview is fine.As an example, I have attached two screenshots. Image ODT depicts the cutoff on preview in ODT format and Image PDF depicts no cutoff on preview in PDF format.Thanks in advance.
-
Have two parameters as a workaround for this. For example, get the list of values into Param1 Create another Parameter , Param2 In the Param2 'Default Value Expression' create the WHERE clause like below " where columnName IN(" + $P{Param1} + ")" Param 2 should not have "Use as a prompt" checked In the filter construct the WHERE clause as below SELECT * FROM $P!{Param2} Do not forget to use ! while referring to Param2 in the filter.
-
We are previewing Jasper reports (version 3.7.5) in openoffice (ODT format).Wherever the report contains UTF-8 content, openoffice is defaulting to font size 12. The rest of the content is displayed as per the font size set in the report.Even if the text fields in the report has been set with either less than or greater than 12, the font size in the ODTis defaulting to 12. The fonts being used is Arial Unicode MS.We also tried with other UTF fonts like Dejavu Sans and Lucida Sans, but the behavior is the same.Basically it is overriding all settings for fonts in either Jasper or in openofficeand setting the size to 12 only for UTF content.This issue has been encountered for OO version 3.3 on Windows and 3.2 on Linux.Any suggestions or workarounds to prevent the font size overriding for UTF content is welcome.Thanks in advance.
