nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Overflowing table in fixed layout

JayaSingh

<p><span style="font-size:medium;">I have recently started working on BIRT.</span></p><p><span style="font-size:medium;">My issue is, I have chosen a fixed layout to display my grid. </span></p><p><span style="font-size:medium;">The dataset fetch the data, is getting too many columns as in attachment</span></p><p> </p><p><span style="font-size:medium;">The number of columns in the table is dynamic . </span></p><p><span style="font-size:medium;">Is it possible to divide a single table into as many additional tables as are required, based on no. of columns . </span></p><p> </p><p><span style="font-size:medium;">Ex. Can I specify that one table should have 10 columns extra columns to move in second table etc.</span></p><p><span style="font-size:medium;">Main issue is no. of columns is dynamic. So I can not decide how many tables I'll get in output.</span></p><p> </p><p><span style="font-size:medium;">Its urgent, please respond soon.</span></p>

Find more posts tagged with

Comments

kclark

<p>I'm not sure if this approach will work for you or not. I created one table and then created a dummyGroup column in the table to count by 3's and made that column invisible. Then I merged the footer cells and placed a second table inside. Then I placed the additionl data that I wanted to display in that and set the page break to 3 and set page break after to always. This will display like there are two tables of data each page. I've posted my rptdesign. Sorry for the xml</p><pre class="_prettyXprint"><?xml version="1.0" encoding="UTF-8"?><report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1"> <property name="createdBy">Eclipse BIRT Designer Version 4.3.0.v201306041519 Build <4.3.0.v20130604-1520></property> <property name="units">in</property> <method name="initialize"><![CDATA[reportContext.setPersistentGlobalVariable("counter", "0");reportContext.setPersistentGlobalVariable("group", "0");]]></method> <property name="iconFile">/templates/blank_report.gif</property> <property name="bidiLayoutOrientation">ltr</property> <property name="imageDPI">96</property> <data-sources> <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="7"> <list-property name="privateDriverProperties"> <ex-property> <name>contentBidiFormatStr</name> <value>ILYNN</value> </ex-property> <ex-property> <name>metadataBidiFormatStr</name> <value>ILYNN</value> </ex-property> </list-property> <property name="odaDriverClass">org.eclipse.birt.report.data.oda.sampledb.Driver</property> <property name="odaURL">jdbc:classicmodels:sampledb</property> <property name="odaUser">ClassicModels</property> </oda-data-source> </data-sources> <data-sets> <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Data Set" id="8"> <list-property name="computedColumns"> <structure> <property name="name">dummygroup</property> <expression name="expression">0;</expression> <property name="dataType">integer</property> </structure> </list-property> <list-property name="columnHints"> <structure> <property name="columnName">CUSTOMERNUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">CUSTOMERNUMBER</text-property> <text-property name="heading">CUSTOMERNUMBER</text-property> </structure> <structure> <property name="columnName">CUSTOMERNAME</property> <property name="analysis">dimension</property> <text-property name="displayName">CUSTOMERNAME</text-property> <text-property name="heading">CUSTOMERNAME</text-property> </structure> <structure> <property name="columnName">CONTACTLASTNAME</property> <property name="analysis">dimension</property> <text-property name="displayName">CONTACTLASTNAME</text-property> <text-property name="heading">CONTACTLASTNAME</text-property> </structure> <structure> <property name="columnName">CONTACTFIRSTNAME</property> <property name="analysis">dimension</property> <text-property name="displayName">CONTACTFIRSTNAME</text-property> <text-property name="heading">CONTACTFIRSTNAME</text-property> </structure> <structure> <property name="columnName">PHONE</property> <property name="analysis">dimension</property> <text-property name="displayName">PHONE</text-property> <text-property name="heading">PHONE</text-property> </structure> <structure> <property name="columnName">ADDRESSLINE1</property> <property name="analysis">dimension</property> <text-property name="displayName">ADDRESSLINE1</text-property> <text-property name="heading">ADDRESSLINE1</text-property> </structure> <structure> <property name="columnName">ADDRESSLINE2</property> <property name="analysis">dimension</property> <text-property name="displayName">ADDRESSLINE2</text-property> <text-property name="heading">ADDRESSLINE2</text-property> </structure> <structure> <property name="columnName">CITY</property> <property name="analysis">dimension</property> <text-property name="displayName">CITY</text-property> <text-property name="heading">CITY</text-property> </structure> <structure> <property name="columnName">STATE</property> <property name="analysis">dimension</property> <text-property name="displayName">STATE</text-property> <text-property name="heading">STATE</text-property> </structure> <structure> <property name="columnName">POSTALCODE</property> <property name="analysis">dimension</property> <text-property name="displayName">POSTALCODE</text-property> <text-property name="heading">POSTALCODE</text-property> </structure> <structure> <property name="columnName">COUNTRY</property> <property name="analysis">dimension</property> <text-property name="displayName">COUNTRY</text-property> <text-property name="heading">COUNTRY</text-property> </structure> <structure> <property name="columnName">SALESREPEMPLOYEENUMBER</property> <property name="analysis">measure</property> <text-property name="displayName">SALESREPEMPLOYEENUMBER</text-property> <text-property name="heading">SALESREPEMPLOYEENUMBER</text-property> </structure> <structure> <property name="columnName">CREDITLIMIT</property> <property name="analysis">measure</property> <text-property name="displayName">CREDITLIMIT</text-property> <text-property name="heading">CREDITLIMIT</text-property> </structure> </list-property> <structure name="cachedMetaData"> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">CUSTOMERNUMBER</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">2</property> <property name="name">CUSTOMERNAME</property> <property name="dataType">string</property> </structure> <structure> <property name="position">3</property> <property name="name">CONTACTLASTNAME</property> <property name="dataType">string</property> </structure> <structure> <property name="position">4</property> <property name="name">CONTACTFIRSTNAME</property> <property name="dataType">string</property> </structure> <structure> <property name="position">5</property> <property name="name">PHONE</property> <property name="dataType">string</property> </structure> <structure> <property name="position">6</property> <property name="name">ADDRESSLINE1</property> <property name="dataType">string</property> </structure> <structure> <property name="position">7</property> <property name="name">ADDRESSLINE2</property> <property name="dataType">string</property> </structure> <structure> <property name="position">8</property> <property name="name">CITY</property> <property name="dataType">string</property> </structure> <structure> <property name="position">9</property> <property name="name">STATE</property> <property name="dataType">string</property> </structure> <structure> <property name="position">10</property> <property name="name">POSTALCODE</property> <property name="dataType">string</property> </structure> <structure> <property name="position">11</property> <property name="name">COUNTRY</property> <property name="dataType">string</property> </structure> <structure> <property name="position">12</property> <property name="name">SALESREPEMPLOYEENUMBER</property> <property name="dataType">integer</property> </structure> <structure> <property name="position">13</property> <property name="name">CREDITLIMIT</property> <property name="dataType">float</property> </structure> <structure> <property name="position">14</property> <property name="name">dummygroup</property> <property name="dataType">integer</property> </structure> </list-property> </structure> <method name="beforeOpen"><![CDATA[phone = new java.util.ArrayList();address = new java.util.ArrayList();city = new java.util.ArrayList();reportContext.setPersistentGlobalVariable("phone", phone);reportContext.setPersistentGlobalVariable("address", address);reportContext.setPersistentGlobalVariable("city", city);]]></method> <method name="onFetch"><![CDATA[var phone = reportContext.getPersistentGlobalVariable("phone");var address = reportContext.getPersistentGlobalVariable("address");var city = reportContext.getPersistentGlobalVariable("city");phone.add(row["PHONE"]);address.add(row["ADDRESSLINE1"]);city.add(row["CITY"]);reportContext.setPersistentGlobalVariable("phone", phone);reportContext.setPersistentGlobalVariable("address", address);reportContext.setPersistentGlobalVariable("city", city);]]></method> <property name="dataSource">Data Source</property> <list-property name="resultSet"> <structure> <property name="position">1</property> <property name="name">CUSTOMERNUMBER</property> <property name="nativeName">CUSTOMERNUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">2</property> <property name="name">CUSTOMERNAME</property> <property name="nativeName">CUSTOMERNAME</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">3</property> <property name="name">CONTACTLASTNAME</property> <property name="nativeName">CONTACTLASTNAME</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">4</property> <property name="name">CONTACTFIRSTNAME</property> <property name="nativeName">CONTACTFIRSTNAME</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">5</property> <property name="name">PHONE</property> <property name="nativeName">PHONE</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">6</property> <property name="name">ADDRESSLINE1</property> <property name="nativeName">ADDRESSLINE1</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">7</property> <property name="name">ADDRESSLINE2</property> <property name="nativeName">ADDRESSLINE2</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">8</property> <property name="name">CITY</property> <property name="nativeName">CITY</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">9</property> <property name="name">STATE</property> <property name="nativeName">STATE</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">10</property> <property name="name">POSTALCODE</property> <property name="nativeName">POSTALCODE</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">11</property> <property name="name">COUNTRY</property> <property name="nativeName">COUNTRY</property> <property name="dataType">string</property> <property name="nativeDataType">12</property> </structure> <structure> <property name="position">12</property> <property name="name">SALESREPEMPLOYEENUMBER</property> <property name="nativeName">SALESREPEMPLOYEENUMBER</property> <property name="dataType">integer</property> <property name="nativeDataType">4</property> </structure> <structure> <property name="position">13</property> <property name="name">CREDITLIMIT</property> <property name="nativeName">CREDITLIMIT</property> <property name="dataType">float</property> <property name="nativeDataType">8</property> </structure> </list-property> <xml-property name="queryText"><![CDATA[select *from customers]]></xml-property> <xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?><model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel"> <Version>2.0</Version> <design:ResultSets derivedMetaData="true"> <design:resultSetDefinitions> <design:resultSetColumns> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CUSTOMERNUMBER</design:name> <design:position>1</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CUSTOMERNUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CUSTOMERNUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CUSTOMERNAME</design:name> <design:position>2</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CUSTOMERNAME</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CUSTOMERNAME</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CONTACTLASTNAME</design:name> <design:position>3</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CONTACTLASTNAME</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CONTACTLASTNAME</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CONTACTFIRSTNAME</design:name> <design:position>4</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CONTACTFIRSTNAME</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CONTACTFIRSTNAME</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>PHONE</design:name> <design:position>5</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>PHONE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>PHONE</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>ADDRESSLINE1</design:name> <design:position>6</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>ADDRESSLINE1</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>ADDRESSLINE1</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>ADDRESSLINE2</design:name> <design:position>7</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>ADDRESSLINE2</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>ADDRESSLINE2</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CITY</design:name> <design:position>8</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CITY</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CITY</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>STATE</design:name> <design:position>9</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>STATE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>STATE</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>POSTALCODE</design:name> <design:position>10</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>15</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>POSTALCODE</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>POSTALCODE</design:label> <design:formattingHints> <design:displaySize>15</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>COUNTRY</design:name> <design:position>11</design:position> </design:identifier> <design:nativeDataTypeCode>12</design:nativeDataTypeCode> <design:precision>50</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>COUNTRY</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>COUNTRY</design:label> <design:formattingHints> <design:displaySize>50</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>SALESREPEMPLOYEENUMBER</design:name> <design:position>12</design:position> </design:identifier> <design:nativeDataTypeCode>4</design:nativeDataTypeCode> <design:precision>10</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>SALESREPEMPLOYEENUMBER</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>SALESREPEMPLOYEENUMBER</design:label> <design:formattingHints> <design:displaySize>11</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> <design:resultColumnDefinitions> <design:attributes> <design:identifier> <design:name>CREDITLIMIT</design:name> <design:position>13</design:position> </design:identifier> <design:nativeDataTypeCode>8</design:nativeDataTypeCode> <design:precision>15</design:precision> <design:scale>0</design:scale> <design:nullability>Nullable</design:nullability> <design:uiHints> <design:displayName>CREDITLIMIT</design:displayName> </design:uiHints> </design:attributes> <design:usageHints> <design:label>CREDITLIMIT</design:label> <design:formattingHints> <design:displaySize>22</design:displaySize> </design:formattingHints> </design:usageHints> </design:resultColumnDefinitions> </design:resultSetColumns> <design:criteria/> </design:resultSetDefinitions> </design:ResultSets></model:DesignValues>]]></xml-property> </oda-data-set> </data-sets> <styles> <style name="report" id="4"> <property name="fontFamily">sans-serif</property> <property name="fontSize">10pt</property> </style> <style name="crosstab-cell" id="5"> <property name="borderBottomColor">#CCCCCC</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">1pt</property> <property name="borderLeftColor">#CCCCCC</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">1pt</property> <property name="borderRightColor">#CCCCCC</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">1pt</property> <property name="borderTopColor">#CCCCCC</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">1pt</property> </style> <style name="crosstab" id="6"> <property name="borderBottomColor">#CCCCCC</property> <property name="borderBottomStyle">solid</property> <property name="borderBottomWidth">1pt</property> <property name="borderLeftColor">#CCCCCC</property> <property name="borderLeftStyle">solid</property> <property name="borderLeftWidth">1pt</property> <property name="borderRightColor">#CCCCCC</property> <property name="borderRightStyle">solid</property> <property name="borderRightWidth">1pt</property> <property name="borderTopColor">#CCCCCC</property> <property name="borderTopStyle">solid</property> <property name="borderTopWidth">1pt</property> </style> </styles> <page-setup> <simple-master-page name="Simple MasterPage" id="2"> <page-footer> <text id="3"> <property name="contentType">html</property> <text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property> </text> </page-footer> </simple-master-page> </page-setup> <body> <table id="557"> <property name="dataSet">Data Set</property> <list-property name="boundDataColumns"> <structure> <property name="name">CUSTOMERNUMBER</property> <text-property name="displayName">CUSTOMERNUMBER</text-property> <expression name="expression" type="javascript">dataSetRow["CUSTOMERNUMBER"]</expression> <property name="dataType">integer</property> </structure> <structure> <property name="name">CUSTOMERNAME</property> <text-property name="displayName">CUSTOMERNAME</text-property> <expression name="expression" type="javascript">dataSetRow["CUSTOMERNAME"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">PHONE</property> <text-property name="displayName">PHONE</text-property> <expression name="expression" type="javascript">dataSetRow["PHONE"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">dummyGroup</property> <text-property name="displayName">dummyGroup</text-property> <expression name="expression" type="javascript">var counter = parseInt(reportContext.getPersistentGlobalVariable("counter"));var group = parseInt(reportContext.getPersistentGlobalVariable("group"));if(counter == 3) { counter = 0; group++; reportContext.setPersistentGlobalVariable("counter", counter.toString()); reportContext.setPersistentGlobalVariable("group", group.toString()); group;}else{ counter++; reportContext.setPersistentGlobalVariable("counter", counter.toString()); group;}</expression> <property name="dataType">string</property> <property name="allowExport">true</property> </structure> <structure> <property name="name">CITY</property> <text-property name="displayName">CITY</text-property> <expression name="expression" type="javascript">dataSetRow["CITY"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">STATE</property> <text-property name="displayName">STATE</text-property> <expression name="expression" type="javascript">dataSetRow["STATE"]</expression> <property name="dataType">string</property> </structure> <structure> <property name="name">CREDITLIMIT</property> <text-property name="displayName">CREDITLIMIT</text-property> <expression name="expression" type="javascript">dataSetRow["CREDITLIMIT"]</expression> <property name="dataType">float</property> </structure> </list-property> <column id="573"> <list-property name="visibility"> <structure> <property name="format">all</property> <expression name="valueExpr" type="javascript">true</expression> </structure> </list-property> </column> <column id="574"/> <column id="575"/> <column id="576"/> <header> <row id="558"> <cell id="559"/> <cell id="560"> <label id="577"> <text-property name="text">CUSTOMERNUMBER</text-property> </label> </cell> <cell id="561"> <label id="579"> <text-property name="text">CUSTOMERNAME</text-property> </label> </cell> <cell id="562"> <label id="581"> <text-property name="text">PHONE</text-property> </label> </cell> </row> </header> <group id="584"> <property name="groupName">NewTableGroup1</property> <expression name="keyExpr" type="javascript">row["dummyGroup"]</expression> <structure name="toc"> <expression name="expressionValue" type="javascript">row["dummyGroup"]</expression> </structure> <property name="hideDetail">false</property> <header> <row id="585"> <cell id="586"/> <cell id="587"/> <cell id="588"/> <cell id="589"/> </row> </header> <footer> <row id="590"> <cell id="591"/> <cell id="592"> <property name="colSpan">3</property> <property name="rowSpan">1</property> <table id="595"> <property name="pageBreakAfter">always</property> <property name="pageBreakInterval">12</property> <column id="608"/> <column id="609"/> <column id="610"/> <header> <row id="596"> <cell id="597"> <label id="611"> <text-property name="text">CITY</text-property> </label> </cell> <cell id="598"> <label id="613"> <text-property name="text">STATE</text-property> </label> </cell> <cell id="599"> <label id="615"> <text-property name="text">CREDITLIMIT</text-property> </label> </cell> </row> </header> <detail> <row id="600"> <cell id="601"> <data id="612"> <property name="resultSetColumn">CITY</property> </data> </cell> <cell id="602"> <data id="614"> <property name="resultSetColumn">STATE</property> </data> </cell> <cell id="603"> <data id="616"> <property name="resultSetColumn">CREDITLIMIT</property> </data> </cell> </row> </detail> <footer> <row id="604"> <cell id="605"/> <cell id="606"/> <cell id="607"/> </row> </footer> </table> </cell> </row> </footer> </group> <detail> <row id="563"> <cell id="564"> <data id="583"> <property name="resultSetColumn">dummyGroup</property> </data> </cell> <cell id="565"> <data id="578"> <property name="resultSetColumn">CUSTOMERNUMBER</property> </data> </cell> <cell id="566"> <data id="580"> <property name="resultSetColumn">CUSTOMERNAME</property> </data> </cell> <cell id="567"> <data id="582"> <property name="resultSetColumn">PHONE</property> </data> </cell> </row> </detail> <footer> <row id="568"> <cell id="569"/> <cell id="570"/> <cell id="571"/> <cell id="572"/> </row> </footer> </table> </body></report></pre>