patricia.williams Posted April 7, 2016 Share Posted April 7, 2016 I have a text field defined<textField isStretchWithOverflow="true" isBlankWhenNull="true"><reportElement x="30" y="0" width="120" height="20" uuid="dc57d609-c89f-444c-815f-5bad95e2d1e9"/><textElement verticalAlignment="Middle"><font size="10" isBold="true"/></textElement><textFieldExpression><![CDATA[$F{filer_persent_type_cd} == "ENTITY" ? $F{name} : $F{name}+", "+$F{filer_name_first}]]></textFieldExpression></textField> My query returns 1473 rows and out of all those rows only 1 row gets split into two seperate rows. The value for $name = Kkkkkkk $filer_name_first=Amanda Ssssssss When you see it in the pdf, Sssssss part is on a line all by itself. Same is true if I export to xlsx, it gets its own row. Does it have to do with the lenght of filer_name_first? I have some $name that are bigger than this length but they are all in name and not name+,+first. Here are the properties I have in my xml:<property name="com.jaspersoft.studio.data.defaultdataadapter" value="TECInternal"/><property name="ireport.jasperserver.url" value="http://10.10.10.32:8082/jasperserver-pro/"/><property name="ireport.jasperserver.user" value="jasperadmin"/><property name="ireport.jasperserver.report.resource" value="/public/StaticLists/RegisterdLobbyistsByYear_files/main_jrxml"/><property name="ireport.jasperserver.reportUnit" value="/public/StaticLists/RegisterdLobbyistsByYear"/><property name="net.sf.jasperreports.export.xls.remove.empty.space.between.columns" value="true"/><property name="net.sf.jasperreports.export.xls.remove.empty.space.between.rows" value="true"/><property name="net.sf.jasperreports.export.xls.ignore.cell.background" value="true"/><property name="net.sf.jasperreports.export.xls.ignore.anchors" value="true"/><property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/><property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.1" value="title"/><property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.2" value="pageHeader"/><property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.3" value="pageFooter"/><property name="net.sf.jasperreports.export.xlsx.exclude.origin.band.4" value="columnHeader"/><property name="net.sf.jasperreports.export.xls.show.gridlines" value="true"/><property name="net.sf.jasperreports.export.xls.ignore.graphics" value="true"/><property name="net.sf.jasperreports.export.xls.collapse.row.span" value="true"/> Link to comment Share on other sites More sharing options...
patricia.williams Posted April 8, 2016 Author Share Posted April 8, 2016 when name=Kkkkkkkkkkand first_name=Deanna Rrrrrrit doesn't split the line into 2 rows!When it split the other one the Ssssssss part was on a line by itself in the excel. In the pdf it looks like it is on a line by itself but maybe not because it is right where there is a page break. I don't think you can actually tell in the pdf, one page has the Kkkkkkk, Amanda and the next page has the Ssssssss. Link to comment Share on other sites More sharing options...
patricia.williams Posted April 8, 2016 Author Share Posted April 8, 2016 when name= "Merrill Lynch, Pierce, Fenner & Smith, Inc." it does not split into 2 rows. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now