iman.gharib

yes, that is really strange. I try just not to use it and make new page by creating groups, which is not always easy.

Hi, In our reports made by jassper 6.11 works the page break element as we want. We are trying to upgrade to 6.15, but almost all reports with page element have a problem. It will creats an empty page. Has there benn any change in this element? Should we avoid that and try to create new page by grouping all the times? I am facing the sam eproblem in 6.16 regards Iman

What has happend to the compile on a folder? Right click on a project has no more the compile option. It is very tedious if we have a folder with lots of jrxmls (without a report book) and need to compile all of them. Now I have to open and compile the files one by one! regrads Iman

Considering the uploaded example, in jasper 6.13 running the book leads to the following error: net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRException: Byte data not found at: styles.jrtx.[/code]Is there any changes regarding to the paths to a file from jasper 6.11. The same example works under 6.11. Running the example from java leads to the same problem. If I put the jrtx in an other folder and set the template reference path to that like (src/main/path/to/style/style.jrtx) it workes! Is it not possible to have the jrtx in the same folder as jrxmls anymore? regards Iman

Hi, can someone tell me when the new JasperStudio (6.7.0) will be published?

Hi, can we hope to see this feature in the Jasper API ?

Original question: http://stackoverflow.com/q/38720986/4262423 After being able to add custom data source from java bean to a report according to http://stackoverflow.com/a/38535589/4262423, I get to the second point of my reporting with jasper. I have a main report which uses a data base as its data source. Then I add a bean.xml data source to the report and add a table to the main report which uses this bean.xml data source to get java beans. My goal is to get a field value from the main report and manipulate its value, then fill the beans with these values and at last fill the table with the beans. For doing that I have written 3 classes which I use as Scriptlet in the table data set: This is an illustration of what I need to do: http://i.stack.imgur.com/9Ro1F.jpg The problem is in FillTable class, when I us `String kNFormelGG = (String) this.getParameterValue("gg");` the created bean.xml fails the test connection with `java.lang.reflect.InvocationTargetException` Caused by: java.lang.NullPointerException at net.sf.jasperreports.engine.JRAbstractScriptlet.getParameterValue(JRAbstractScriptlet.java:95) at net.sf.jasperreports.engine.JRAbstractScriptlet.getParameterValue(JRAbstractScriptlet.java:86) at org.iqtig.reporting.dataSource.bean.dataSourceXML.FillTable.fillTable(FillTable.java:45) at org.iqtig.reporting.dataSource.bean.dataSourceXML.JRDataSourceFactory.createCollection(JRDataSourceFactory.java:27) ... 34 more If I assign a fix value like `String kNFormelGG ="Test me"` the bean connection encounters no error and after assigning bean.xml as the value for Default Data Adapter in Dataset1 it fills the table with static values. How can get the data from a parameter or a value dynamically from the main report data source and use it in beans? I have this assumption that at the time of calling the static factory class from my adapter, the fields are still empty. Maybe I am wrong but I do not find any other declaration for this problem. **BeanFactory Class** import java.util.Collection; import net.sf.jasperreports.engine.JRDefaultScriptlet; import net.sf.jasperreports.engine.JRScriptletException; /** * Factory for TableCellsBean Klasse * * @author iman.gharib */ public class JRDataSourceFactory extends JRDefaultScriptlet { /** * @return collection der TableCellsBean Objekten * @throws JRScriptletException */ public static Collection<TableCellsBean> createCollection() throws JRScriptletException { FillTable ft = new FillTable(); Collection<TableCellsBean> reportRows = ft.fillTable(); return reportRows; } }[/code]Bean Class public class TableCellsBean { private String fieldName; private String keyFormel; private String mK; private String notation; private String item; /** * Constructor. * * @param fieldName * @param keyFormel * @param mK * @param notation * @param item */ public TableCellsBean(final String fieldName, final String keyFormel, final String mK, final String notation, final String item) { this.fieldName = fieldName; this.keyFormel = keyFormel; this.mK = mK; this.notation = notation; this.item = item; } /** * Constructo Leer */ public TableCellsBean() { } public TableCellsBean getme() { return this; } // getter and setters }**Class for preparing and creating beans** public class FillTable extends JRDefaultScriptlet { @Override public void afterColumnInit() throws JRScriptletException { fillTable(); } public ArrayList<String> splitGGArray(final String kNFormelGG) { ArrayList<String> fieldNames = new ArrayList<>(); String[] array = (kNFormelGG.split(" ")); for (String sub : array) { fieldNames.add(sub); } return fieldNames; } public Collection<TableCellsBean> fillTable() throws JRScriptletException { // gg is a parameter for table dataset. It is mapped to KN_FormelGG // which comes from the main report data base String kNFormelGG = (String) this.getParameterValue("gg"); List<TableCellsBean> listTableCells = new ArrayList<>(); // TableCellsBean tableCell = new TableCellsBean(); for (String fn : splitGGArray(kNFormelGG)) { listTableCells.add(new TableCellsBean(fn, fn, fn, fn, fn)); // listTableCells.add(tableCell); } // JRBeanCollectionDataSource tableCellJRBean = new JRBeanCollectionDataSource(listTableCells); // Map<String, Object> parameters = new HashMap<>(); // parameters.put("FieldDataSource", tableCellJRBean); return listTableCells; } }[/code]JRXML <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.0.final using JasperReports Library version 6.3.0 --> <!-- 2016-08-08T14:30:03 --> <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="main" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="4f1480cf-f8f9-420f-96b4-7fc1e41e791b"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="QIDBReport"/> <style name="Table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="Dataset1" uuid="5677929d-813b-4d39-828c-de966a9d7689"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="bean.xml"/> <property name="net.sf.jasperreports.data.adapter" value="bean.xml"/> <scriptlet name="Scriptlet_1" class="org.iqtig.reporting.dataSource.bean.mapBeanAsDatasource.JRDataSourceFactory"/> <parameter name="gg" class="java.lang.String"/> <field name="item" class="java.lang.String"> <fieldDescription><![CDATA[item]]></fieldDescription> </field> <field name="fieldName" class="java.lang.String"> <fieldDescription><![CDATA[fieldName]]></fieldDescription> </field> <field name="me" class="org.iqtig.reporting.dataSource.bean.dataSourceXML.TableCellsBean"> <fieldDescription><![CDATA[me]]></fieldDescription> </field> <field name="keyFormel" class="java.lang.String"> <fieldDescription><![CDATA[keyFormel]]></fieldDescription> </field> <field name="mK" class="java.lang.String"> <fieldDescription><![CDATA[mK]]></fieldDescription> </field> </subDataset> <parameter name="LB_ID" class="java.lang.Integer"> <defaultValueExpression><![CDATA[62]]></defaultValueExpression> </parameter> <parameter name="KN_OffeziellGruppe" class="java.lang.Integer"> <defaultValueExpression><![CDATA[3]]></defaultValueExpression> </parameter> <parameter name="FieldDataSource" class="net.sf.jasperreports.engine.data.JRBeanCollectionDataSource" isForPrompting="false"/> <parameter name="KN_FormelGG" class="java.lang.String" isForPrompting="false"/> <queryString> <![CDATA[select * from "KennzahlReferenz2015_QIBericht", "Images" where LB_ID = $P{LB_ID} and KN_OffiziellGruppe = $P{KN_OffeziellGruppe} and IMG_ID = 1]]> </queryString> <field name="QI_Praefix" class="java.lang.String"/> <field name="KN_Id" class="java.lang.Integer"/> <field name="bewertungsArtTypNameKurz" class="java.lang.String"/> <field name="refbereich" class="java.lang.String"/> <field name="refbereichVorjahres" class="java.lang.String"/> <field name="KN_GGAlleinstehend" class="java.lang.String"/> <field name="erlaueterungDerRechregeln" class="java.lang.String"/> <field name="teildatensatzbezug" class="java.lang.String"/> <field name="mindesanzahlZaeler" class="java.lang.Integer"/> <field name="mindesanzahlNenner" class="java.lang.Integer"/> <field name="KN_FormelZ" class="java.lang.String"/> <field name="KN_FormelGG" class="java.lang.String"/> <field name="verwendeteFunktionen" class="java.lang.String"/> <field name="idLb" class="java.lang.String"/> <field name="LB_LangBezeichnung" class="java.lang.String"/> <field name="LB_ID" class="java.lang.Integer"/> <field name="nameAlleinstehend" class="java.lang.String"/> <field name="KN_BezeichnungAlleinstehendKurz" class="java.lang.String"/> <field name="QI_ID" class="java.lang.Integer"/> <field name="IMG_ID" class="java.lang.Integer"/> <field name="Name" class="java.lang.String"/> <field name="Image" class="java.lang.Object"/> <group name="id" isStartNewPage="true"> <groupExpression><![CDATA[$F{KN_Id}]]></groupExpression> <groupHeader> <band height="44"/> </groupHeader> <groupFooter> <band height="50"/> </groupFooter> </group> <background> <band splitType="Stretch"/> </background> <title> <band height="44" splitType="Stretch"/> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="34" splitType="Stretch"/> </columnHeader> <detail> <band height="149" splitType="Stretch"> <componentElement> <reportElement x="170" y="20" width="350" height="100" uuid="38d917fb-dfc2-4c08-890a-09cfe6e2214d"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/> <property name="net.sf.jasperreports.export.headertoolbar.table.name" value=""/> <property name="com.jaspersoft.studio.components.autoresize.proportional" value="true"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail"> <datasetRun subDataset="Dataset1" uuid="1b3548f6-7d6b-4070-bb8e-aaefbabdc7c9"> <datasetParameter name="gg"> <datasetParameterExpression><![CDATA[$F{KN_FormelGG}]]></datasetParameterExpression> </datasetParameter> </datasetRun> <jr:column width="70" uuid="048812d7-0ed1-4db8-a09a-e6242f77c6ce"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:tableHeader style="Table_TH" height="30" rowSpan="1"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="70" height="30" uuid="c5aaea84-1367-41df-be8d-7f71e3ea5153"/> <textFieldExpression><![CDATA[$F{item}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="70" uuid="11b85ada-c9fe-42b6-a646-8bd1697cdec2"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <jr:tableHeader style="Table_TH" height="30" rowSpan="1"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="70" height="30" uuid="728ff44d-1dbd-404c-b8b3-7cc0e1f07f60"/> <textFieldExpression><![CDATA[$F{fieldName}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="70" uuid="892f30cb-fb41-444f-889b-1e005484c35e"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <jr:tableHeader style="Table_TH" height="30" rowSpan="1"/> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="70" height="30" uuid="e38ac951-71bc-45a6-8ed2-313805a77050"/> <textFieldExpression><![CDATA[$F{keyFormel}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="70" uuid="7d0d700a-5a75-4c26-94c0-9ef7c53bd719"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> <jr:tableHeader style="Table_TH" height="30" rowSpan="1"> <textField> <reportElement x="0" y="0" width="70" height="30" uuid="68577007-0344-406c-8aa2-3127d1da1c65"/> </textField> </jr:tableHeader> <jr:detailCell style="Table_TD" height="30"> <textField> <reportElement x="0" y="0" width="70" height="30" uuid="873d63c1-1b91-4441-b7bd-f67db7729e7f"/> <textFieldExpression><![CDATA[$F{mK}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="70" uuid="cf5a1a2f-594d-429f-8925-62d001e1dd00"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> <jr:tableHeader style="Table_TH" height="30" rowSpan="1"> <textField> <reportElement x="0" y="0" width="70" height="30" uuid="7fb46eb8-d0e1-44ab-89f9-ec31d49b8109"/> <textFieldExpression><![CDATA[$P{gg}]]></textFieldExpression> </textField> </jr:tableHeader> <jr:detailCell style="Table_TD" height="30"/> </jr:column> </jr:table> </componentElement> <textField> <reportElement x="20" y="80" width="100" height="30" uuid="b89cd04c-2569-43ef-9730-445b874855dd"/> <textFieldExpression><![CDATA[$F{KN_FormelGG}]]></textFieldExpression> </textField> <staticText> <reportElement x="20" y="32" width="100" height="30" uuid="e91b4461-5e53-4f85-8992-14e69a1aa05f"/> <text><![CDATA[KN_FormelGG]]></text> </staticText> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"/> </summary> </jasperReport>[/code]

I try to wrap my text around an Image. I have tried using table which did not succeed. I tough of using text field as html and passing image to it and set the alignment to left, but I found out that it is not possible to pass the image in text field. I started to solve the problem using jaspersoft Studio pro and with its html element. However I could not figure out how to pass the image field from data base as the html source. The expression in the html element is: "<img src= '$F{Image}' align='left'/> <p>"+$F{KN_Zusatzinfo_DV_Einleitungstext} +"</p>"[/code]This code does not show the image, but a box instead of the image. And the text which is printed is not stretched. The page style which I use is two column. The out put is as the picture bellow: The structure I need to create is as in the picture bellow: http://i.stack.imgur.com/hfRZx.png How can I wrap the text around the picture the best?

I had some problem with my query wich gave me back null. I got the right solution regarding this link: http://stackoverflow.com/questions/38006907/data-will-not-shown-at-jaspersoft-studio-6-2-2-data-set-dialog

I am trying to get a value from a field in a data base and use it in scriptlet in order to make a pie chart in jasperStudio There are two ways I thought about: First: create a variable in jasperStudio and assign it with its expression to a field of a data base Second: get fields value in scriptlet and use it. But non of this procedures work for me and the value of testVb remains 0.0 and it takes no space in pie chart The Scriptlet is: @Override public void afterReportInit() throws JRScriptletException { Double testVb = new Double(0.0); DefaultPieDataset dataset = new DefaultPieDataset(); //** non of these two bellow lines of codes work for me **// // testVb = (Double) this.getVariableValue("vVisual"); testVb = (Double) this.getFieldValue("KN_Perzentile"); dataset.setValue("Java", new Double(43.2)); dataset.setValue("Visual Basic", testVb); dataset.setValue("C/C++", new Double(17.5)); dataset.setValue("PHP", new Double(32.5)); dataset.setValue("Perl", new Double(1.0)); JFreeChart chart = ChartFactory.createPieChart3D( "Pie Chart 3D Demo 1", dataset, true, true, false); PiePlot3D plot = (PiePlot3D) chart.getPlot(); plot.setStartAngle(290); plot.setDirection(Rotation.CLOCKWISE); plot.setForegroundAlpha(0.5f); plot.setNoDataMessage("No data to display"); /* */ this.setVariableValue("Pie", new JCommonDrawableRenderer(chart)); } and this my jrxml: <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="JFreeReport" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1edc4d15-06d0-46cf-8d57-179fd0bed566"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="QIDBReport"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <scriptlet name="BoxPlotScript" class="testProjektIman.toc.JFreeChartScriptlet"/> <queryString> <![CDATA[select KN_Perzentile from "Kennzahl" where KN_ID = 215 and KN_RefWert1 = 8.3]]> </queryString> <field name="KN_Perzentile" class="java.lang.Double"/> <variable name="Pie" class="net.sf.jasperreports.engine.JRRenderable" calculation="System"/> <variable name="vVisual" class="java.lang.Double" calculation="System"> <variableExpression><![CDATA[$F{KN_Perzentile}]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <title> <band height="79" splitType="Stretch"/> </title> <detail> <band height="290" splitType="Stretch"> <image scaleImage="Clip" hAlign="Center"> <reportElement x="60" y="50" width="440" height="215" uuid="60c9de91-e7ad-4ffb-81fd-109a381532b6"/> <imageExpression><![CDATA[$V{Pie}]]></imageExpression> </image> </band> </detail> <summary> <band height="42" splitType="Stretch"/> </summary></jasperReport>[/code]

I have faced suddenly the following issues with jasperstudio data set dialog: First: After running the first query "select KN_Perzentile..." and clicking the refresh preview data the jasper shows that 2 fields are read (which should be one in fact), but the data will not shown at all! Second: Running the second query "select top..." encounters an error, saying that the field KN_Perzentile is not found! This field is not asked in the second query at all! both queries are tested against Database and correct. I did not have these issues till today

I need to have some charts in my report which are not in basic elements, such as box plot. I know that the jasper lets implementing new visualization using JavaScript via Custom Visualization element. Because I am not familiar with JavaScript , I thought maybe it is possible and feasible to create java jars for Jasperstudio which create those charts and get the data at runtime from parameters or database. But I am not sure, whether or not I will come to dead end by doing that. So I wanted to ask, if it is an good idea to create the extra elements such as some charts, and add them as Jar to the Jasperstudio? regards Iman

Well, I have found the problem reason. It happens when I add the report book and write a query for that. Why should I write a new query in report book, although I add the compiled jasper report to it? If I do not write a query for report book the report will not compile and says document is empty.

It did not work in my case using the default java settings of jasperstudio. But the link is informative. thanks

I used the above construction with driver 4.2 and it worked

I had connection error until I followed this link: http://community.jaspersoft.com/questions/951061/sql-server-connection-integrated-authentication-jaspersoft-studio

How connect to a ms SQL server using windows authentication in jasperstudio without having jasper server? All the tutorials that I have found are declaring the connection between a ms SQL server and jasper server. But need to set my data adapter so that I can connect to the SQL server from jasperstudio using windows authentication

thanks for the link. I will give it a try

I took yours and put each static text with a text field in a band and set print repeated values to rue. Now it works. thanks

Is it possible to create a structure like you see in the picture using table element? At the time i am using a combination of static text and text fields.

I have changed the sturcture and I have one detail now. But the problem with redundant data is still there! When i go to Dataset and query dialog and then data preview, after refreshing the data I see two times more data fields as there are! And my report book has double pages more than the report itself!

I have created a basic element which contains a static text and text field in a band. I have set 8 pieces of them after each other like rows of a table in a band and put them on one detail. The problem is that on the first page all elements are get filled and printed correctly. On the second page the 2 last elements wont printed. On the last page the last element wont be printed! I have no Idea why it faces such a problem. Here is the shortened code: <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.2.2.final using JasperReports Library version 6.2.2 --><!-- 2016-06-14T15:56:16 --><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="direktRechrDV" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="d12b4217-cf22-4ec4-857b-9cb1b2b406a8"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="KennzahlReferenz2015_QIBericht"/> <property name="net.sf.jasperreports.print.create.bookmarks" value="true"/> <group name="id" isStartNewPage="true" isReprintHeaderOnEachPage="true" keepTogether="true"> <groupExpression><![CDATA[$F{KN_Id}]]></groupExpression> <groupHeader> <band/> </groupHeader> <groupFooter> <band splitType="Immediate"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </band> </groupFooter> </group> <group name="LBgroup" isStartNewPage="true" isReprintHeaderOnEachPage="true" keepTogether="true"> <groupExpression><![CDATA[$F{LB_ID}]]></groupExpression> <groupHeader> <band/> </groupHeader> <groupFooter> <band splitType="Immediate"/> </groupFooter> </group> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="62" splitType="Stretch"> <staticText> <reportElement x="8" y="2" width="409" height="26" uuid="37a242c0-b352-42e1-b287-42350a5e2090"/> <textElement markup="html"/> <text><![CDATA[statistische Basisprüfung - Auffälligkeitskriterien: Verstetigung und Vollzähligkeit 2015<br>]]></text> </staticText> <textField isStretchWithOverflow="true"> <reportElement x="7" y="16" width="322" height="19" uuid="f28c3fc0-6d00-4437-a185-febccf94e91f"/> <textElement markup="none"/> <textFieldExpression><![CDATA[$F{idLb} +" - "+ $F{LB_LangBezeichnung}]]></textFieldExpression> </textField> <textField> <reportElement x="8" y="32" width="321" height="20" uuid="705007c1-4bfa-483a-a113-887cf7fd6488"/> <textFieldExpression><![CDATA[$F{KN_Id}+": "+$F{KN_BezeichnungAlleinstehendKurz}]]></textFieldExpression> </textField> <image hAlign="Center"> <reportElement x="480" y="6" width="50" height="50" uuid="3f5fe998-e94e-4280-af71-7f7163878156"> <printWhenExpression><![CDATA[$F{IMG_ID} == 1]]></printWhenExpression> </reportElement> <imageExpression><![CDATA[$F{Image}]]></imageExpression> </image> </band> </pageHeader> <columnHeader> <band splitType="Stretch"/> </columnHeader> <detail> <band height="345"> <printWhenExpression><![CDATA[new Boolean($V{id_COUNT}.intValue()==1)]]></printWhenExpression> <frame> <reportElement positionType="Float" stretchType="RelativeToTallestObject" isPrintRepeatedValues="false" x="8" y="40" width="501" height="270" uuid="55ca2869-dd02-48a5-a9bf-90b538ea22a6"/> <frame> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="0" width="280" height="21" printWhenGroupChanges="id" uuid="255952d3-ed97-4615-926f-e7e89560d64a"/> <textField isStretchWithOverflow="true"> <reportElement key="" positionType="Float" isPrintRepeatedValues="false" x="99" y="0" width="181" height="21" printWhenGroupChanges="id" uuid="83851dcf-a0b2-44df-9117-0c5487b16260"> <property name="net.sf.jasperreports.export.json.path" value="AK.id"/> <property name="net.sf.jasperreports.export.json.repeat.value" value="true"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <paragraph leftIndent="1"/> </textElement> <textFieldExpression><![CDATA[$F{KN_Id}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="99" height="21" printWhenGroupChanges="id" forecolor="#FFFFFF" backcolor="#005051" uuid="168d731e-09c0-4b1e-ac6f-c86168fe1286"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <text><![CDATA[AK_ID]]></text> </staticText> </frame> <frame> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="21" width="280" height="21" printWhenGroupChanges="id" uuid="0879346c-a263-431d-8e2d-8d2a1cd0e67c"/> <staticText> <reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="99" height="21" printWhenGroupChanges="id" forecolor="#FFFFFF" backcolor="#005051" uuid="75c8f9aa-47d6-4869-b8b2-a16ca58e11db"/> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <text><![CDATA[Präfix]]></text> </staticText> <textField isStretchWithOverflow="true"> <reportElement key="" positionType="Float" isPrintRepeatedValues="false" x="99" y="0" width="181" height="21" printWhenGroupChanges="id" uuid="f38998f8-8dc7-4ccc-8066-0cfe5e7ab876"> <property name="net.sf.jasperreports.export.json.path" value="qi.praefix"/> <property name="net.sf.jasperreports.export.json.repeat.value" value="true"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <paragraph leftIndent="1"/> </textElement> <textFieldExpression><![CDATA[$F{QI_Praefix}]]></textFieldExpression> </textField> </frame> <frame> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="42" width="280" height="30" printWhenGroupChanges="id" uuid="92186cbd-4a98-4c6e-9b51-0dfe52d5ff21"/> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" isPrintRepeatedValues="false" x="99" y="0" width="181" height="30" printWhenGroupChanges="id" uuid="4818fc44-cde3-40ed-8d77-a6dd71b89f79"> <property name="net.sf.jasperreports.export.json.path" value="begruendung.relevanz"/> <property name="net.sf.jasperreports.export.json.repeat.value" value="true"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement markup="html"> <paragraph leftIndent="1"/> </textElement> <textFieldExpression><![CDATA["<b>Relevanz</b><br>" +($F{KN_Zusatzinfo_DV_Relevanz} !=null ? $F{KN_Zusatzinfo_DV_Relevanz} : "-")+"<br><b>Hypothese</b><br>" + ($F{KN_Zusatzinfo_DV_Hypothese} !=null ? $F{KN_Zusatzinfo_DV_Hypothese}: "-")]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="99" height="30" printWhenGroupChanges="id" forecolor="#FFFFFF" backcolor="#005051" uuid="a93eb1cf-015c-442a-afac-68c7f9a30cb5"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <paragraph lineSpacing="Single"/> </textElement> <text><![CDATA[begründung für die Auswahl]]></text> </staticText> </frame> <frame> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="72" width="280" height="27" printWhenGroupChanges="id" uuid="91d6b54a-bcd4-4737-8208-7dcd9e388ea4"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" isPrintRepeatedValues="false" x="99" y="0" width="181" height="27" printWhenGroupChanges="id" uuid="883db6cf-5cc6-4e32-a4cd-54bdf86b97df"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement rotation="None"> <paragraph leftIndent="1"/> </textElement> <textFieldExpression><![CDATA[($F{KN_Zusatzinfo_DV_Indikatorbezug} !=null ? $F{KN_Zusatzinfo_DV_Indikatorbezug} : "-")]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Opaque" x="0" y="-1" width="99" height="27" printWhenGroupChanges="id" forecolor="#FFFFFF" backcolor="#005051" uuid="61373b56-22c7-4097-8da1-ebcd702bc410"> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <text><![CDATA[bezug zu anderen Indikatoren]]></text> </staticText> </frame> <frame> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="99" width="280" height="27" printWhenGroupChanges="id" uuid="be213a60-4cd9-4f4a-972b-edfbf7b408c9"/> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" isPrintRepeatedValues="false" x="99" y="0" width="181" height="27" printWhenGroupChanges="id" uuid="261644b6-bbdb-4528-9f25-7fb23e98bf99"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <paragraph leftIndent="1"/> </textElement> <textFieldExpression><![CDATA[$F{bewertungsArtTypNameKurz}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="99" height="27" printWhenGroupChanges="id" forecolor="#FFFFFF" backcolor="#005051" uuid="d338843f-2f88-4d1b-b355-e7757acacf8e"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <text><![CDATA[bewertungsart]]></text> </staticText> </frame> <frame> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="127" width="280" height="27" printWhenGroupChanges="id" uuid="626fe004-8942-4655-8c64-4022728e65e9"/> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" isPrintRepeatedValues="false" x="99" y="0" width="181" height="27" printWhenGroupChanges="id" uuid="3ea786ed-6ce2-4ce7-84af-b4b7d29cc3b7"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <paragraph leftIndent="1"/> </textElement> <textFieldExpression><![CDATA[$F{mindesanzahlZaeler}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Opaque" x="0" y="-1" width="99" height="27" printWhenGroupChanges="id" forecolor="#FFFFFF" backcolor="#005051" uuid="284779f8-692b-45b1-a535-62f1a4ce124b"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <text><![CDATA[Mindestanzahl Zähler]]></text> </staticText> </frame> <frame> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="154" width="280" height="27" uuid="f2f30758-914b-4990-b508-644cabb06f3f"/> <textField isStretchWithOverflow="true"> <reportElement positionType="Float" isPrintRepeatedValues="false" x="99" y="0" width="181" height="27" printWhenGroupChanges="id" uuid="77c50b2a-a9ec-4225-8361-4daa6dc9d97e"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <paragraph leftIndent="1"/> </textElement> <textFieldExpression><![CDATA[$F{KN_Vergleichbarkeit_Vorjahr}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Opaque" x="0" y="0" width="99" height="27" printWhenGroupChanges="id" forecolor="#FFFFFF" backcolor="#005051" uuid="4f5650a6-9330-444b-bfec-0c1cd03d254f"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <text><![CDATA[Vergleichbarkeit mit Vorjahr]]></text> </staticText> </frame> <frame> <reportElement positionType="Float" isPrintRepeatedValues="false" x="0" y="182" width="280" height="27" uuid="3a70786a-ab1b-4193-8087-bcf9f363116a"/> <textField isStretchWithOverflow="true" isBlankWhenNull="false"> <reportElement positionType="Float" isPrintRepeatedValues="false" x="99" y="-1" width="181" height="27" printWhenGroupChanges="id" uuid="0d48b38a-07e8-42e7-89e8-e0580651028e"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.y" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement> <paragraph leftIndent="1"/> </textElement> <textFieldExpression><![CDATA[$F{mindesanzahlNenner}]]></textFieldExpression> </textField> <staticText> <reportElement positionType="Float" stretchType="RelativeToBandHeight" isPrintRepeatedValues="false" mode="Opaque" x="0" y="-1" width="99" height="27" printWhenGroupChanges="id" forecolor="#FFFFFF" backcolor="#005051" uuid="fc8232c6-dfb5-482a-9fef-a9ac1f75861a"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.x" value="pixel"/> </reportElement> <box> <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <text><![CDATA[Mindestanzahl Nenner]]></text> </staticText> </frame> </frame> <textField isStretchWithOverflow="true" hyperlinkType="" hyperlinkTarget="" bookmarkLevel="1"> <reportElement isPrintRepeatedValues="false" mode="Transparent" x="0" y="4" width="340" height="6" printWhenGroupChanges="id" uuid="56a6e5f3-fd57-436e-8acb-8dbc1acbb220"> <printWhenExpression><![CDATA[1==0]]></printWhenExpression> </reportElement> <textElement markup="html"/> <textFieldExpression><![CDATA[$F{KN_Id}+":"+$F{nameAlleinstehend}]]></textFieldExpression> <anchorNameExpression><![CDATA[$F{KN_Id}+":"+$F{nameAlleinstehend}]]></anchorNameExpression> <hyperlinkReferenceExpression><![CDATA[]]></hyperlinkReferenceExpression> </textField> <staticText> <reportElement x="11" y="14" width="78" height="16" uuid="17d269d4-d7fa-44ef-8b00-d1abe0ecb92c"/> <textElement> <font size="12" isBold="true"/> </textElement> <text><![CDATA[berechnung]]></text> </staticText> </band> </detail> <columnFooter> <band splitType="Stretch"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </band> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"> <staticText> <reportElement x="0" y="20" width="410" height="20" uuid="0744ba3c-69d3-4220-b201-72dabdeb5038"/> <textElement> <font size="8"/> </textElement> <text><![CDATA[ins]]></text> </staticText> <textField evaluationTime="Master"> <reportElement x="481" y="18" width="69" height="24" uuid="5789c6a7-2ca2-4ba9-bd13-1b56ddcb7091"/> <textFieldExpression><![CDATA["Seite "+$V{MASTER_CURRENT_PAGE}+" von"+$V{MASTER_TOTAL_PAGES}]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band height="52" splitType="Stretch"/> </summary></jasperReport>[/code]

I set sub frames and text fields like this: Position type float, stretch type: no stretch, stretch with overflow to true for text fields. stretch with overflow to true for text fields. main frame wich contains all other frames : float, relative to tallest object

since I guess there is no way to rotate a table by 90° I started to simulate one by wrapping static text and text fields together in band. I enclose each static text to its text field which suppose to have the value for that static text and then enclose all rows (combination of static and text fields) in one band. But I can not adjust the stretch type in a way that all these components play together. Each text field has a different value and should be expandable to its content. For example field text for static text 3. All fields are set to stretch by over flow, position float, stretch type relative to band height. the structure is like this: static1field with value1static2field with value 2static3field with value33333 static4Field with value4And this is how it looks like with text fields fading in each other:

I changed the font size in table of contents from pre defined size number 16 into 8 and it worked