jasperreport how to jump to next line

Posted on January 23, 2019 at 10:47pm

hey,there

I have a problem 

https://drive.google.com/file/d/17eG2s8iGk66L-Av2Pw3vlW0dEa_BVmCR/view

this is my report

it have 18 columns(9x2)

I have use mysql 

every column has show a name

but when I show 10 name

it will jump to next page

but I hope I can jump to column10

how can I do to jump column10

please help me 

thanks

 

 

iReport Designer
JasperReports IO
cool3690's picture
cool3690
90
Joined: Sep 18 2018 - 12:52am
Last seen: 4 years 1 week ago

4 Answers:

Posted on January 24, 2019 at 3:05am

Hello,

You can turn off pagination with Ignore Pagination proeprty of report. It will generate one page report and all rows will be displayed on one page

Regards, Alex

akovach's picture
akovach
3098
Joined: Apr 25 2018 - 2:25am
Last seen: 3 years 3 months ago
Posted on January 24, 2019 at 4:26pm

hello Alex  akovach

https://drive.google.com/open?id=1IXuZos3Yo2W90hlaudpnQ0Z0k19UKU_S

I have check  Ignore Pagination

but  name only show in column 1

column 2-18 name,all disappear

and also not show in next page 

how I can slove the problem

thanks

cool3690's picture
cool3690
90
Joined: Sep 18 2018 - 12:52am
Last seen: 4 years 1 week ago
Posted on January 24, 2019 at 5:42pm

Check the height of the text field. Just tried with Jaspersoft Studio by setting "Columns" to "5 "and "Print Order" to "Horizontal" in "Page Format" dialog and didn't get any page breaks between rows.

hozawa's picture
hozawa
171413
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 years 9 months ago
Posted on January 24, 2019 at 6:55pm

hello  hozawa:

 

I have try your advice

"Print Order" to "Horizontal" in "Page Format" .

but still fail

it only show name in column 1-9

but cant show 10-18 column

what step I lost?

 

this is my xml code

..
 
<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="null" language="groovy" columnCount="9" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="90" columnSpacing="1" leftMargin="10" rightMargin="10" topMargin="10" bottomMargin="10" uuid="0dd970d6-f806-4840-b94d-1fa72ac4eb5f">
    <property name="ireport.zoom" value="1.0"/>
    <property name="ireport.x" value="0"/>
    <property name="ireport.y" value="13"/>
    <queryString language="SQL">
        <![CDATA[select* from send]]>
    </queryString>
    <field name="name" class="java.lang.String">
        <fieldDescription><![CDATA[]]></fieldDescription>
    </field>
 
    <group name="name">
        <groupExpression><![CDATA[$F{name}]]></groupExpression>
    </group>
    <detail>
        <band height="276" splitType="Stretch">
            <textField>
                <reportElement x="14" y="11" width="14" height="252" uuid="3bb01f3c-dbe2-4d34-b9de-a1bc9df7f1a1"/>
                <textElement>
                    <font fontName="標楷體" size="18" pdfFontName="MHei-Medium" pdfEncoding="UniCNS-UCS2-V" isPdfEmbedded="true"/>
                </textElement>
                <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
            </textField>
        </band>
        <band height="276"/>
    </detail>
</jasperReport>
..

thanks

cool3690's picture
cool3690
90
Joined: Sep 18 2018 - 12:52am
Last seen: 4 years 1 week ago
Feedback