how to freezy table (column) headers when scrolling the page in the report?

a.number27 · September 29, 2021

how to fix table (column) headers in the report? So that when scrolling the page, they are static at the top of the page

I was offered this option:

If you would like to use the same Freeze as it is in Excel, then Right Click on the row/coulmn-->Select XLS Tags-->Freeze.Select text boxes on the header and set the stretch type to "Relative to Tallest Object "

but it didn't help.

Help me please! I really need to solve this problem

bigalex · September 29, 2021

Please see your original post

djohnson53 · September 29, 2021

@bigalex, What do you mean?

yama818 · September 29, 2021

original post

https://community.jaspersoft.com/questions/1188021/how-fix-table-column-headers-report

a.number27 · September 30, 2021

@yama818 thanks

bigalex · October 4, 2021

Copy and Paste your code here

a.number27 · October 4, 2021

<?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.17.0.final using JasperReports Library version 6.17.0-6d93193241dd8cc42629e188b94f9e0bc5722efd  --><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="contracts" language="groovy" pageWidth="2200" pageHeight="1000" orientation="Landscape" columnWidth="2160" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="34d63523-9679-44c8-9daf-612cb2c1a7f5">    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>    <property name="ireport.jasperserver.url" value="http://rkn-app04.phoenixit.ru:8080/jasperserver/"/>    <property name="ireport.jasperserver.user" value="jasperadmin"/>    <property name="com.jaspersoft.studio.report.unit.description" value="GROUP=Отчетность по РФИЗарубежная собственность;ORDER=1;GROUPORDER=100;ACCESS=FCP_ROLE"/>    <property name="com.jaspersoft.studio.report.description" value="Subreport"/>    <property name="ireport.jasperserver.report.resource" value="/reports/jrxml/contracts.jrxml"/>    <property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="false"/>    <property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"/>    <property name="net.sf.jasperreports.csv.encoding" value="UTF-8"/>    <property name="net.sf.jasperreports.export.csv.write.bom" value="true"/>    <property name="net.sf.jasperreports.export.docx.frames.as.nested.tables" value="false"/>    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="test_db"/>    <property name="net.sf.jasperreports.export.pdf.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.docx.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.xls.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.csv.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.rtf.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.odt.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.ods.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.xlsx.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.pptx.exclude.key.export_json"/>    <property name="net.sf.jasperreports.export.pdf.exclude.key.export_xml"/>    <property name="net.sf.jasperreports.export.docx.exclude.key.export_xml"/>    <property name="net.sf.jasperreports.export.xls.exclude.key.export_xml"/>    <property name="net.sf.jasperreports.export.csv.exclude.key.export_xml"/>    <property name="net.sf.jasperreports.export.rtf.exclude.key.export_xml"/>    <property name="net.sf.jasperreports.export.odt.exclude.key.export_xml"/>    <property name="net.sf.jasperreports.export.ods.exclude.key.export_xml"/>    <property name="net.sf.jasperreports.export.xlsx.exclude.key.export_xml"/>    <property name="net.sf.jasperreports.export.pptx.exclude.key.export_xml"/>    <property name="ireport.jasperserver.reportUnit" value="/reports/erir/contracts"/>    <style name="Table 1_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 1_CH" mode="Opaque" backcolor="#DAE1E8">        <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 1_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="Dataset_search_obj_1_2" uuid="885b11c7-cb4d-4037-8f81-54b9f4237339">        <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="203"/>        <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="790"/>        <property name="com.jaspersoft.studio.data.sql.tables" value=""/>        <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="774"/>        <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="215"/>        <property name="com.jaspersoft.studio.data.defaultdataadapter" value="RKN_DEV"/>        <parameter name="report_pages_max" class="java.lang.Integer"/>        <parameter name="rfi_card_status" class="java.util.List" nestedType="java.lang.String"/>        <parameter name="ri_tu" class="java.util.List" nestedType="java.lang.String"/>        <parameter name="org_list" class="java.util.List" nestedType="java.lang.Long">            <parameterDescription><![CDATA[]]></parameterDescription>        </parameter>        <parameter name="rfi_reg_section_foreign" class="java.util.List" nestedType="java.lang.String"/>        <parameter name="ri_tu_active" class="java.util.List"/>        <parameter name="holderogrn" class="java.lang.String" nestedType="java.lang.String"/>        <parameter name="contract_id" class="java.lang.String"/>        <parameter name="contractor_id" class="java.lang.String"/>        <parameter name="inn" class="java.lang.String"/>        <queryString>            <![CDATA[select distinct vcc.number,vcc.date,vcc.amount,c.amount as sum_dogovor,coalesce(vcc.customer_inn,'-') as customer_inn,vcc.customer_name,vcc.client_inn,vcc.client_name,vcc.created_date,od.name as ord_name,vcc.external_id as ord_id,vcc.id as contract_id,c.document_link as document_linkfrom register.v_contract_with_company vccleft join register.ord od on od.id=vcc.ord_idleft join register.advertiser ad on ad.ord_id=vcc.ord_idleft join register.contract c on c.id=vcc.idwhere ( vcc.id::text =$P{contract_id}::text or $P{contract_id} is NULL)and (vcc.contractor_id::text=$P{contractor_id}::text or $P{contractor_id} is NULL)and ((vcc.client_inn::text=$P{inn}::text or vcc.customer_inn::text=$P{inn}::text) or $P{inn} is NULL)and vcc.rec_status_id=0order by vcc.date desc]]>        </queryString>        <field name="number" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="number"/>            <property name="com.jaspersoft.studio.field.label" value="number"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="date" class="java.sql.Date">            <property name="com.jaspersoft.studio.field.name" value="date"/>            <property name="com.jaspersoft.studio.field.label" value="date"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="amount" class="java.math.BigDecimal">            <property name="com.jaspersoft.studio.field.name" value="amount"/>            <property name="com.jaspersoft.studio.field.label" value="amount"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="sum_dogovor" class="java.lang.Double">            <property name="com.jaspersoft.studio.field.name" value="sum_dogovor"/>            <property name="com.jaspersoft.studio.field.label" value="sum_dogovor"/>            <property name="com.jaspersoft.studio.field.tree.path" value="contract"/>        </field>        <field name="customer_inn" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="customer_inn"/>            <property name="com.jaspersoft.studio.field.label" value="customer_inn"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="customer_name" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="customer_name"/>            <property name="com.jaspersoft.studio.field.label" value="customer_name"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="client_inn" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="client_inn"/>            <property name="com.jaspersoft.studio.field.label" value="client_inn"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="client_name" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="client_name"/>            <property name="com.jaspersoft.studio.field.label" value="client_name"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="created_date" class="java.sql.Timestamp">            <property name="com.jaspersoft.studio.field.name" value="created_date"/>            <property name="com.jaspersoft.studio.field.label" value="created_date"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="ord_name" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="ord_name"/>            <property name="com.jaspersoft.studio.field.label" value="ord_name"/>            <property name="com.jaspersoft.studio.field.tree.path" value="ord"/>        </field>        <field name="ord_id" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="ord_id"/>            <property name="com.jaspersoft.studio.field.label" value="ord_id"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="contract_id" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="contract_id"/>            <property name="com.jaspersoft.studio.field.label" value="contract_id"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>        <field name="document_link" class="java.lang.String">            <property name="com.jaspersoft.studio.field.name" value="document_link"/>            <property name="com.jaspersoft.studio.field.label" value="document_link"/>            <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>        </field>    </subDataset>    <parameter name="report_pages_max" class="java.lang.Integer">        <defaultValueExpression><![CDATA[10]]></defaultValueExpression>    </parameter>    <parameter name="rfi_card_status" class="java.util.List" nestedType="java.lang.String"/>    <parameter name="ri_tu" class="java.util.List" nestedType="java.lang.String"/>    <parameter name="org_list" class="java.util.List" nestedType="java.lang.Long">        <parameterDescription><![CDATA[]]></parameterDescription>    </parameter>    <parameter name="ri_tu_active" class="java.util.List" nestedType="java.lang.String"/>    <parameter name="rfi_reg_section_foreign" class="java.util.List" nestedType="java.lang.String"/>    <parameter name="inn" class="java.lang.String"/>    <parameter name="contract_id" class="java.lang.String"/>    <parameter name="contractor_id" class="java.lang.String"/>    <queryString>        <![CDATA[select 1]]>    </queryString>    <title>        <band height="65" splitType="Stretch">            <textField>                <reportElement mode="Transparent" x="10" y="0" width="2010" height="60" forecolor="#000000" backcolor="#477FF0" uuid="0fa7f4c7-5c47-473f-be8b-113827f3948f"/>                <textElement textAlignment="Left" verticalAlignment="Middle">                    <font fontName="DejaVu Sans" size="18" isBold="true"/>                </textElement>                <textFieldExpression><![CDATA[(($P{contract_id} ==null)?"Договоры":"Договор")]]></textFieldExpression>            </textField>            <textField hyperlinkType="Reference" hyperlinkTarget="Blank">                <reportElement key="export_xml" x="1260" y="22" width="190" height="21" uuid="6af39a19-0dac-4218-8257-c9c56cf9817d"/>                <textFieldExpression><![CDATA["Экспортировать в XML"]]></textFieldExpression>                <hyperlinkReferenceExpression><![CDATA["https://rkn-app01.phoenixit.ru/web/guest/export?reportname=contracts&exporttype=xml"+($P{contract_id}==null?"":"&"+"contract_id="+$P{contract_id})+($P{inn}==null?"":"&inn="+$P{inn})+($P{contractor_id}==null?"":"&"+"contractor_id="+$P{contractor_id})]]></hyperlinkReferenceExpression>            </textField>            <textField hyperlinkType="Reference" hyperlinkTarget="Parent">                <reportElement key="export_json" x="1450" y="22" width="160" height="21" uuid="647fc7fc-e1a2-48b6-85c6-2abfc68a5ba4"/>                <textFieldExpression><![CDATA["Экспортировать в JSON"]]></textFieldExpression>                <hyperlinkReferenceExpression><![CDATA["https://rkn-app01.phoenixit.ru/web/guest/export?reportname=contracts&exporttype=json"+($P{contract_id}==null?"":"&"+"contract_id="+$P{contract_id})+($P{inn}==null?"":"&inn="+$P{inn})+($P{contractor_id}==null?"":"&"+"contractor_id="+$P{contractor_id})]]></hyperlinkReferenceExpression>            </textField>        </band>    </title>    <detail>        <band height="206">            <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>            <rectangle radius="12">                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="10" y="29" width="2140" height="97" forecolor="#F4F6F9" backcolor="#F4F6F9" uuid="07d275ab-dbb4-427a-aa80-a9a7d5fd7706">                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                </reportElement>            </rectangle>            <componentElement>                <reportElement stretchType="RelativeToTallestObject" x="10" y="36" width="2140" height="170" uuid="481e8803-8a0b-442a-a095-a9056624550a">                    <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>                    <property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/>                    <property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/>                    <property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/>                </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">                    <datasetRun subDataset="Dataset_search_obj_1_2" uuid="97646bc4-3779-4482-baff-3a682f618f5d">                        <datasetParameter name="contract_id">                            <datasetParameterExpression><![CDATA[$P{contract_id}]]></datasetParameterExpression>                        </datasetParameter>                        <datasetParameter name="contractor_id">                            <datasetParameterExpression><![CDATA[$P{contractor_id}]]></datasetParameterExpression>                        </datasetParameter>                        <datasetParameter name="inn">                            <datasetParameterExpression><![CDATA[$P{inn}]]></datasetParameterExpression>                        </datasetParameter>                        <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>                    </datasetRun>                    <jr:column width="120" uuid="7f647532-1f9b-4e0e-b8dd-422ccab46125">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>                        <property name="net.sf.jasperreports.components.filter.char" value="true"/>                        <property name="net.sf.jasperreports.components.sort.down.arrow.char" value="true"/>                        <property name="net.sf.jasperreports.components.sort.up.arrow.char" value="true"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="number"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="120" height="90" backcolor="#F4F6F9" uuid="db74e993-cc97-4a76-be46-f90c83c8d752">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[№ Договора]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField>                                <reportElement x="0" y="0" width="120" height="80" uuid="4afa3d0a-3d77-492d-b340-852b9749c0b5"/>                                <box padding="3">                                    <pen lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{number}==null?"-":$F{number}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="130" uuid="c95c42a5-65a2-42df-8721-f7b53692a805">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="date"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="130" height="90" backcolor="#F4F6F9" uuid="80a78918-2f96-48e1-a427-1e9580284d31">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[Дата]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight" pattern="dd.MM.yyyy ">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="130" height="80" uuid="305c6ea4-5311-4d07-b8de-c0f986506f45"/>                                <box padding="3">                                    <pen lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12" isBold="false"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{date}==null?"-":$F{date}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="130" uuid="71069537-b268-4f68-99ea-74bc3cb88920">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="amount"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="130" height="90" backcolor="#F4F6F9" uuid="376a7815-9b39-425c-9ea7-c17b56a4d6e9">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[Сумма по актам]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight" pattern="###0.00">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="130" height="80" uuid="26ddfd8c-1e07-47b5-98f3-1bf905c11769"/>                                <box padding="3">                                    <pen lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12" isBold="false"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{amount}==null?"-":$F{amount}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="140" uuid="92d20e37-3022-4592-a9c7-0d462925e770">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="sum_dogovor"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="140" height="90" backcolor="#F4F6F9" uuid="de4eb1c7-3695-4fb5-a73d-7a9b8367441b">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[Сумма договора]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight" pattern="###0.00">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="140" height="80" uuid="26ddce48-d9cf-48dd-8a2c-1655358ddc09"/>                                <box padding="3">                                    <pen lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12" isBold="false"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{sum_dogovor}==null?"-":$F{sum_dogovor}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="170" uuid="e6e88d6b-a543-405a-929c-e0350c6fcb59">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="client_inn"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="170" height="90" backcolor="#F4F6F9" uuid="1568dae7-4f4c-4969-9418-71f0eb5db0ac">                                    <property name="com.jaspersoft.studio.unit.width" value="pixel"/>                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[ИНН заказчика]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="170" height="80" uuid="2a720a13-5bdb-4c43-bd56-d63bea07a1d7"/>                                <box padding="3">                                    <pen lineStyle="Dashed" lineColor="#808080"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{client_inn}==null?"-":$F{client_inn}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="250" uuid="e3027ed4-6289-44c5-a5da-7baecc1e7258">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="client_name"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="250" height="90" backcolor="#F4F6F9" uuid="f509ed7e-5e86-4101-89c2-be0bbd93c8f3">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[Название организации заказчика]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="250" height="80" uuid="b077a0ca-9311-46ea-85fe-eb0f9120ca5b"/>                                <box padding="3">                                    <pen lineStyle="Dashed" lineColor="#808080"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{client_name}==null?"-":$F{client_name}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="170" uuid="ffc7a267-f27e-491d-8d57-29e2432e051f">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="client_inn"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.spreadsheet.SpreadsheetLayout"/>                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="170" height="90" backcolor="#F4F6F9" uuid="d9f772c5-6fff-42ef-961c-b10acedd4917">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[ИНН исполнителя]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="170" height="80" uuid="f48b1e58-f0f9-4a2c-af47-e350b39ca4ef"/>                                <box padding="3">                                    <pen lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{customer_inn}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="260" uuid="41514832-09c5-40c7-a332-2a175b0875b4">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="customer_name"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="260" height="90" backcolor="#F4F6F9" uuid="acb89de3-d835-420d-8ab9-e2680e636d2f">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[Название организации исполнителя]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="260" height="80" uuid="101a6733-4992-457e-8141-2f3abf2845ed"/>                                <box padding="3">                                    <pen lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{customer_name}==null?"-":$F{customer_name}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="190" uuid="d6072f41-a47b-4daa-be19-d026d2daf2c1">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column9"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="created_date"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="190" height="90" backcolor="#F4F6F9" uuid="9f911fb0-4393-46dc-a32d-f3ffee42abe5">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[Дата регистрации в ЕРИР]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight" pattern="dd.MM.yyyy">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="190" height="80" uuid="de439953-566b-490f-b8cd-2ef4d35835ae"/>                                <box padding="3">                                    <pen lineStyle="Dashed" lineColor="#808080"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{created_date}==null?"-":$F{created_date}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="160" uuid="fd75ac99-1697-4871-ae60-98dec23240ac">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column10"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="ord_name"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="160" height="90" backcolor="#F4F6F9" uuid="6e94ffcf-7677-404f-bbfc-e2d8216b12b4">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[ОРД]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="160" height="80" uuid="447d22fa-1cec-48f6-b5df-79dd77645a6b"/>                                <box padding="3">                                    <pen lineStyle="Dashed" lineColor="#808080"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{ord_name}==null?"-":$F{ord_name}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="140" uuid="f6d3ddc6-cb39-498f-af1c-ad29b23cc9e6">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column11"/>                        <property name="net.sf.jasperreports.components.table.column.field" value="ord_id"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="140" height="90" backcolor="#F4F6F9" uuid="0d3dc919-051e-413e-af0b-8d4c7b10f966">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[iD в ОРД]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="140" height="80" uuid="ef3cd6df-89c9-4fe3-98ef-e4749dba162b"/>                                <box padding="3">                                    <pen lineStyle="Dashed" lineColor="#808080"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{ord_id}==null?"-":$F{ord_id}]]></textFieldExpression>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="150" uuid="984518a3-393a-40c7-9efc-b27f004e4853">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column12"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="150" height="90" backcolor="#F4F6F9" uuid="087b887d-4ad3-4fb6-84a4-aa0afff46117">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[Ссылка на акты]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineStyle="Solid" lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight" hyperlinkType="ReportExecution">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="150" height="80" forecolor="#1B23CC" uuid="2bdf726b-e4a4-47cd-b05c-1d4ed5ac12d4"/>                                <box padding="3">                                    <pen lineStyle="Dashed" lineColor="#808080"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12" isUnderline="true"/>                                </textElement>                                <textFieldExpression><![CDATA["Акты"]]></textFieldExpression>                                <hyperlinkParameter name="_report">                                    <hyperlinkParameterExpression><![CDATA["/reports/erir/invoice"]]></hyperlinkParameterExpression>                                </hyperlinkParameter>                                <hyperlinkParameter name="contract_id">                                    <hyperlinkParameterExpression><![CDATA[$F{contract_id}]]></hyperlinkParameterExpression>                                </hyperlinkParameter>                                <hyperlinkParameter name="start_date">                                    <hyperlinkParameterExpression><![CDATA["1900-01-01"]]></hyperlinkParameterExpression>                                </hyperlinkParameter>                                <hyperlinkParameter name="ended_date">                                    <hyperlinkParameterExpression><![CDATA[new java.util.Date()]]></hyperlinkParameterExpression>                                </hyperlinkParameter>                            </textField>                        </jr:detailCell>                    </jr:column>                    <jr:column width="130" uuid="9ff521a6-beb6-472f-a583-c237961ef713">                        <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column13"/>                        <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">                            <box>                                <pen lineColor="#C0C9D8"/>                                <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <staticText>                                <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="130" height="90" backcolor="#F4F6F9" uuid="7113c4eb-9b85-478d-a2f9-a00bf7c237d1">                                    <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>                                </reportElement>                                <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">                                    <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="14" isBold="true"/>                                </textElement>                                <text><![CDATA[Ссылка на документ]]></text>                            </staticText>                        </jr:columnHeader>                        <jr:detailCell style="Table 1_TD" height="80">                            <box>                                <pen lineColor="#C0C9D8"/>                                <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>                                <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                            </box>                            <textField textAdjust="StretchHeight" hyperlinkType="Reference" hyperlinkTarget="Blank">                                <reportElement stretchType="ContainerHeight" x="0" y="0" width="130" height="80" forecolor="#1B23CC" uuid="d76bda64-dcf9-416a-a87d-836cc02e7f12"/>                                <box padding="3">                                    <pen lineStyle="Dashed" lineColor="#808080"/>                                    <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                    <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>                                </box>                                <textElement textAlignment="Center" verticalAlignment="Middle">                                    <font fontName="DejaVu Sans" size="12" isUnderline="true"/>                                </textElement>                                <textFieldExpression><![CDATA[$F{document_link}==null?"-":$F{document_link}]]></textFieldExpression>                                <hyperlinkReferenceExpression><![CDATA[$F{document_link}]]></hyperlinkReferenceExpression>                                <hyperlinkParameter name="_report">                                    <hyperlinkParameterExpression><![CDATA["/reports/erir/invoice"]]></hyperlinkParameterExpression>                                </hyperlinkParameter>                                <hyperlinkParameter name="contract_id">                                    <hyperlinkParameterExpression><![CDATA[$F{contract_id}]]></hyperlinkParameterExpression>                                </hyperlinkParameter>                                <hyperlinkParameter name="start_date">                                    <hyperlinkParameterExpression><![CDATA["1900-01-01"]]></hyperlinkParameterExpression>                                </hyperlinkParameter>                                <hyperlinkParameter name="ended_date">                                    <hyperlinkParameterExpression><![CDATA[new java.util.Date()]]></hyperlinkParameterExpression>                                </hyperlinkParameter>                            </textField>                        </jr:detailCell>                    </jr:column>                </jr:table>            </componentElement>            <textField hyperlinkType="ReportExecution">                <reportElement x="130" y="9" width="130" height="16" forecolor="#808D99" uuid="49c0b2f1-1df1-4fe7-bf98-abee8cc20398"/>                <textElement textAlignment="Center" verticalAlignment="Middle">                    <font fontName="DejaVu Sans" size="9" isUnderline="true"/>                </textElement>                <textFieldExpression><![CDATA["Группировать по столбцу"]]></textFieldExpression>                <hyperlinkParameter name="_report">                    <hyperlinkParameterExpression><![CDATA["/reports/erir/contracts_group_date"]]></hyperlinkParameterExpression>                </hyperlinkParameter>            </textField>            <textField hyperlinkType="ReportExecution">                <reportElement x="530" y="9" width="170" height="16" forecolor="#808D99" uuid="bdf6fbcd-7310-4a26-8e67-cac288bf9cf7"/>                <textElement textAlignment="Center" verticalAlignment="Middle">                    <font fontName="DejaVu Sans" size="9" isUnderline="true"/>                </textElement>                <textFieldExpression><![CDATA["Группировать по столбцу"]]></textFieldExpression>                <hyperlinkParameter name="_report">                    <hyperlinkParameterExpression><![CDATA["/reports/erir/contracts_group_inn"]]></hyperlinkParameterExpression>                </hyperlinkParameter>            </textField>        </band>    </detail></jasperReport>[/code]

a.number27 · October 4, 2021

The <body> goes under the <header>. I hope I clearly explained the essence of my problem.

bigalex · October 6, 2021

Not sure why you create table. Looking at nature of your report it is not necessary. I made some adjustments (See Below).

Make all your fields are aligned, otherwise it will create extra column when exporting to Excel.

------------------------------------------------------------------------------------------------------------

<?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="contracts" language="groovy" pageWidth="2160" pageHeight="960" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="2160" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" uuid="34d63523-9679-44c8-9daf-612cb2c1a7f5">
   <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
   <property name="ireport.jasperserver.url" value="http://rkn-app04.phoenixit.ru:8080/jasperserver/"/>
   <property name="ireport.jasperserver.user" value="jasperadmin"/>
   <property name="com.jaspersoft.studio.report.unit.description" value="GROUP=Отчетность по РФИЗарубежная собственность;ORDER=1;GROUPORDER=100;ACCESS=FCP_ROLE"/>
   <property name="com.jaspersoft.studio.report.description" value="Subreport"/>
   <property name="ireport.jasperserver.report.resource" value="/reports/jrxml/contracts.jrxml"/>
   <property name="net.sf.jasperreports.export.xls.ignore.cell.border" value="false"/>
   <property name="net.sf.jasperreports.export.xls.collapse.row.span" value="false"/>
   <property name="net.sf.jasperreports.csv.encoding" value="UTF-8"/>
   <property name="net.sf.jasperreports.export.csv.write.bom" value="true"/>
   <property name="net.sf.jasperreports.export.docx.frames.as.nested.tables" value="false"/>
   <property name="com.jaspersoft.studio.data.defaultdataadapter" value="test_db"/>
   <property name="net.sf.jasperreports.export.pdf.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.docx.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.xls.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.csv.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.rtf.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.odt.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.ods.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.xlsx.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.pptx.exclude.key.export_json"/>
   <property name="net.sf.jasperreports.export.pdf.exclude.key.export_xml"/>
   <property name="net.sf.jasperreports.export.docx.exclude.key.export_xml"/>
   <property name="net.sf.jasperreports.export.xls.exclude.key.export_xml"/>
   <property name="net.sf.jasperreports.export.csv.exclude.key.export_xml"/>
   <property name="net.sf.jasperreports.export.rtf.exclude.key.export_xml"/>
   <property name="net.sf.jasperreports.export.odt.exclude.key.export_xml"/>
   <property name="net.sf.jasperreports.export.ods.exclude.key.export_xml"/>
   <property name="net.sf.jasperreports.export.xlsx.exclude.key.export_xml"/>
   <property name="net.sf.jasperreports.export.pptx.exclude.key.export_xml"/>
   <property name="ireport.jasperserver.reportUnit" value="/reports/erir/contracts"/>
   <property name="net.sf.jasperreports.export.xls.white.page.background" value="false"/>
   <property name="net.sf.jasperreports.export.xls.detect.cell.type" value="true"/>
   <property name="net.sf.jasperreports.export.xls.freeze.row" value="4"/>
   <property name="net.sf.jasperreports.exports.xls.font.size.fix.enabled" value="false"/>
   <style name="Table 1_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 1_CH" mode="Opaque" backcolor="#DAE1E8">
       <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 1_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="Dataset_search_obj_1_2" uuid="885b11c7-cb4d-4037-8f81-54b9f4237339">
       <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="203"/>
       <property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="790"/>
       <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
       <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w1" value="774"/>
       <property name="com.jaspersoft.studio.property.dataset.dialog.DatasetDialog.sash.w2" value="215"/>
       <property name="com.jaspersoft.studio.data.defaultdataadapter" value="RKN_DEV"/>
       <parameter name="report_pages_max" class="java.lang.Integer"/>
       <parameter name="rfi_card_status" class="java.util.List" nestedType="java.lang.String"/>
       <parameter name="ri_tu" class="java.util.List" nestedType="java.lang.String"/>
       <parameter name="org_list" class="java.util.List" nestedType="java.lang.Long">
           <parameterDescription><![CDATA[]]></parameterDescription>
       </parameter>
       <parameter name="rfi_reg_section_foreign" class="java.util.List" nestedType="java.lang.String"/>
       <parameter name="ri_tu_active" class="java.util.List"/>
       <parameter name="holderogrn" class="java.lang.String" nestedType="java.lang.String"/>
       <parameter name="contract_id" class="java.lang.String"/>
       <parameter name="contractor_id" class="java.lang.String"/>
       <parameter name="inn" class="java.lang.String"/>
       <queryString>
           <![CDATA[select distinct vcc.number,
vcc.date,
vcc.amount,
c.amount as sum_dogovor,
coalesce(vcc.customer_inn,'-') as customer_inn,
vcc.customer_name,
vcc.client_inn,
vcc.client_name,
vcc.created_date,
od.name as ord_name,
vcc.external_id as ord_id,
vcc.id as contract_id,
c.document_link as document_link
from register.v_contract_with_company vcc
left join register.ord od on od.id=vcc.ord_id
left join register.advertiser ad on ad.ord_id=vcc.ord_id
left join register.contract c on c.id=vcc.id
where ( vcc.id::text =$P{contract_id}::text or $P{contract_id} is NULL)
and (vcc.contractor_id::text=$P{contractor_id}::text or $P{contractor_id} is NULL)
and ((vcc.client_inn::text=$P{inn}::text or vcc.customer_inn::text=$P{inn}::text) or $P{inn} is NULL)
and vcc.rec_status_id=0
order by vcc.date desc]]>
       </queryString>
       <field name="number" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="number"/>
           <property name="com.jaspersoft.studio.field.label" value="number"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="date" class="java.sql.Date">
           <property name="com.jaspersoft.studio.field.name" value="date"/>
           <property name="com.jaspersoft.studio.field.label" value="date"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="amount" class="java.math.BigDecimal">
           <property name="com.jaspersoft.studio.field.name" value="amount"/>
           <property name="com.jaspersoft.studio.field.label" value="amount"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="sum_dogovor" class="java.lang.Double">
           <property name="com.jaspersoft.studio.field.name" value="sum_dogovor"/>
           <property name="com.jaspersoft.studio.field.label" value="sum_dogovor"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="contract"/>
       </field>
       <field name="customer_inn" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="customer_inn"/>
           <property name="com.jaspersoft.studio.field.label" value="customer_inn"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="customer_name" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="customer_name"/>
           <property name="com.jaspersoft.studio.field.label" value="customer_name"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="client_inn" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="client_inn"/>
           <property name="com.jaspersoft.studio.field.label" value="client_inn"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="client_name" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="client_name"/>
           <property name="com.jaspersoft.studio.field.label" value="client_name"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="created_date" class="java.sql.Timestamp">
           <property name="com.jaspersoft.studio.field.name" value="created_date"/>
           <property name="com.jaspersoft.studio.field.label" value="created_date"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="ord_name" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="ord_name"/>
           <property name="com.jaspersoft.studio.field.label" value="ord_name"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="ord"/>
       </field>
       <field name="ord_id" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="ord_id"/>
           <property name="com.jaspersoft.studio.field.label" value="ord_id"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="contract_id" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="contract_id"/>
           <property name="com.jaspersoft.studio.field.label" value="contract_id"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
       <field name="document_link" class="java.lang.String">
           <property name="com.jaspersoft.studio.field.name" value="document_link"/>
           <property name="com.jaspersoft.studio.field.label" value="document_link"/>
           <property name="com.jaspersoft.studio.field.tree.path" value="v_contract_with_company"/>
       </field>
   </subDataset>
   <parameter name="report_pages_max" class="java.lang.Integer">
       <defaultValueExpression><![CDATA[10]]></defaultValueExpression>
   </parameter>
   <parameter name="rfi_card_status" class="java.util.List" nestedType="java.lang.String"/>
   <parameter name="ri_tu" class="java.util.List" nestedType="java.lang.String"/>
   <parameter name="org_list" class="java.util.List" nestedType="java.lang.Long">
       <parameterDescription><![CDATA[]]></parameterDescription>
   </parameter>
   <parameter name="ri_tu_active" class="java.util.List" nestedType="java.lang.String"/>
   <parameter name="rfi_reg_section_foreign" class="java.util.List" nestedType="java.lang.String"/>
   <parameter name="inn" class="java.lang.String"/>
   <parameter name="contract_id" class="java.lang.String"/>
   <parameter name="contractor_id" class="java.lang.String"/>
   <queryString>
       <![CDATA[select 1]]>
   </queryString>
   <detail>
       <band height="170">
           <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
           <componentElement>
               <reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="2160" height="170" uuid="481e8803-8a0b-442a-a095-a9056624550a">
                   <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
                   <property name="com.jaspersoft.studio.table.style.table_header" value="Table 1_TH"/>
                   <property name="com.jaspersoft.studio.table.style.column_header" value="Table 1_CH"/>
                   <property name="com.jaspersoft.studio.table.style.detail" value="Table 1_TD"/>
                   <property name="com.jaspersoft.studio.unit.y" value="px"/>
               </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="Dataset_search_obj_1_2" uuid="97646bc4-3779-4482-baff-3a682f618f5d">
                       <datasetParameter name="contract_id">
                           <datasetParameterExpression><![CDATA[$P{contract_id}]]></datasetParameterExpression>
                       </datasetParameter>
                       <datasetParameter name="contractor_id">
                           <datasetParameterExpression><![CDATA[$P{contractor_id}]]></datasetParameterExpression>
                       </datasetParameter>
                       <datasetParameter name="inn">
                           <datasetParameterExpression><![CDATA[$P{inn}]]></datasetParameterExpression>
                       </datasetParameter>
                       <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
                   </datasetRun>
                   <jr:column width="120" uuid="7f647532-1f9b-4e0e-b8dd-422ccab46125">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
                       <property name="net.sf.jasperreports.components.filter.char" value="true"/>
                       <property name="net.sf.jasperreports.components.sort.down.arrow.char" value="true"/>
                       <property name="net.sf.jasperreports.components.sort.up.arrow.char" value="true"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="number"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="120" height="90" backcolor="#F4F6F9" uuid="db74e993-cc97-4a76-be46-f90c83c8d752">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[№ Договора]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField>
                               <reportElement x="0" y="0" width="120" height="80" uuid="4afa3d0a-3d77-492d-b340-852b9749c0b5"/>
                               <box padding="3">
                                   <pen lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{number}==null?"-":$F{number}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="130" uuid="c95c42a5-65a2-42df-8721-f7b53692a805">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="date"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="130" height="90" backcolor="#F4F6F9" uuid="80a78918-2f96-48e1-a427-1e9580284d31">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[Дата]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight" pattern="dd.MM.yyyy ">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="130" height="80" uuid="305c6ea4-5311-4d07-b8de-c0f986506f45"/>
                               <box padding="3">
                                   <pen lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12" isBold="false"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{date}==null?"-":$F{date}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="130" uuid="71069537-b268-4f68-99ea-74bc3cb88920">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="amount"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="130" height="90" backcolor="#F4F6F9" uuid="376a7815-9b39-425c-9ea7-c17b56a4d6e9">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[Сумма по актам]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight" pattern="###0.00">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="130" height="80" uuid="26ddfd8c-1e07-47b5-98f3-1bf905c11769"/>
                               <box padding="3">
                                   <pen lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12" isBold="false"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{amount}==null?"-":$F{amount}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="140" uuid="92d20e37-3022-4592-a9c7-0d462925e770">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="sum_dogovor"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="140" height="90" backcolor="#F4F6F9" uuid="de4eb1c7-3695-4fb5-a73d-7a9b8367441b">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[Сумма договора]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight" pattern="###0.00">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="140" height="80" uuid="26ddce48-d9cf-48dd-8a2c-1655358ddc09"/>
                               <box padding="3">
                                   <pen lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12" isBold="false"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{sum_dogovor}==null?"-":$F{sum_dogovor}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="170" uuid="e6e88d6b-a543-405a-929c-e0350c6fcb59">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="client_inn"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="170" height="90" backcolor="#F4F6F9" uuid="1568dae7-4f4c-4969-9418-71f0eb5db0ac">
                                   <property name="com.jaspersoft.studio.unit.width" value="pixel"/>
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[ИНН заказчика]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="170" height="80" uuid="2a720a13-5bdb-4c43-bd56-d63bea07a1d7"/>
                               <box padding="3">
                                   <pen lineStyle="Dashed" lineColor="#808080"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{client_inn}==null?"-":$F{client_inn}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="250" uuid="e3027ed4-6289-44c5-a5da-7baecc1e7258">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="client_name"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="250" height="90" backcolor="#F4F6F9" uuid="f509ed7e-5e86-4101-89c2-be0bbd93c8f3">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[Название организации заказчика]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="250" height="80" uuid="b077a0ca-9311-46ea-85fe-eb0f9120ca5b"/>
                               <box padding="3">
                                   <pen lineStyle="Dashed" lineColor="#808080"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{client_name}==null?"-":$F{client_name}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="170" uuid="ffc7a267-f27e-491d-8d57-29e2432e051f">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="client_inn"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.spreadsheet.SpreadsheetLayout"/>
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="170" height="90" backcolor="#F4F6F9" uuid="d9f772c5-6fff-42ef-961c-b10acedd4917">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[ИНН исполнителя]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="170" height="80" uuid="f48b1e58-f0f9-4a2c-af47-e350b39ca4ef"/>
                               <box padding="3">
                                   <pen lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{customer_inn}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="260" uuid="41514832-09c5-40c7-a332-2a175b0875b4">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="customer_name"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="260" height="90" backcolor="#F4F6F9" uuid="acb89de3-d835-420d-8ab9-e2680e636d2f">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[Название организации исполнителя]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="260" height="80" uuid="101a6733-4992-457e-8141-2f3abf2845ed"/>
                               <box padding="3">
                                   <pen lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{customer_name}==null?"-":$F{customer_name}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="190" uuid="d6072f41-a47b-4daa-be19-d026d2daf2c1">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column9"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="created_date"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="190" height="90" backcolor="#F4F6F9" uuid="9f911fb0-4393-46dc-a32d-f3ffee42abe5">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[Дата регистрации в ЕРИР]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight" pattern="dd.MM.yyyy">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="190" height="80" uuid="de439953-566b-490f-b8cd-2ef4d35835ae"/>
                               <box padding="3">
                                   <pen lineStyle="Dashed" lineColor="#808080"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{created_date}==null?"-":$F{created_date}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="160" uuid="fd75ac99-1697-4871-ae60-98dec23240ac">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column10"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="ord_name"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="160" height="90" backcolor="#F4F6F9" uuid="6e94ffcf-7677-404f-bbfc-e2d8216b12b4">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[ОРД]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="160" height="80" uuid="447d22fa-1cec-48f6-b5df-79dd77645a6b"/>
                               <box padding="3">
                                   <pen lineStyle="Dashed" lineColor="#808080"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{ord_name}==null?"-":$F{ord_name}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="140" uuid="f6d3ddc6-cb39-498f-af1c-ad29b23cc9e6">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column11"/>
                       <property name="net.sf.jasperreports.components.table.column.field" value="ord_id"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="140" height="90" backcolor="#F4F6F9" uuid="0d3dc919-051e-413e-af0b-8d4c7b10f966">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[iD в ОРД]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="140" height="80" uuid="ef3cd6df-89c9-4fe3-98ef-e4749dba162b"/>
                               <box padding="3">
                                   <pen lineStyle="Dashed" lineColor="#808080"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{ord_id}==null?"-":$F{ord_id}]]></textFieldExpression>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="150" uuid="984518a3-393a-40c7-9efc-b27f004e4853">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column12"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineWidth="2.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="150" height="90" backcolor="#F4F6F9" uuid="087b887d-4ad3-4fb6-84a4-aa0afff46117">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[Ссылка на акты]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <box>
                               <pen lineStyle="Solid" lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight" hyperlinkType="ReportExecution">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="150" height="80" forecolor="#1B23CC" uuid="2bdf726b-e4a4-47cd-b05c-1d4ed5ac12d4"/>
                               <box padding="3">
                                   <pen lineStyle="Dashed" lineColor="#808080"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12" isUnderline="true"/>
                               </textElement>
                               <textFieldExpression><![CDATA["Акты"]]></textFieldExpression>
                               <hyperlinkParameter name="_report">
                                   <hyperlinkParameterExpression><![CDATA["/reports/erir/invoice"]]></hyperlinkParameterExpression>
                               </hyperlinkParameter>
                               <hyperlinkParameter name="contract_id">
                                   <hyperlinkParameterExpression><![CDATA[$F{contract_id}]]></hyperlinkParameterExpression>
                               </hyperlinkParameter>
                               <hyperlinkParameter name="start_date">
                                   <hyperlinkParameterExpression><![CDATA["1900-01-01"]]></hyperlinkParameterExpression>
                               </hyperlinkParameter>
                               <hyperlinkParameter name="ended_date">
                                   <hyperlinkParameterExpression><![CDATA[new java.util.Date()]]></hyperlinkParameterExpression>
                               </hyperlinkParameter>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
                   <jr:column width="130" uuid="9ff521a6-beb6-472f-a583-c237961ef713">
                       <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column13"/>
                       <jr:columnHeader style="Table 1_CH" height="90" rowSpan="1">
                           <box>
                               <pen lineColor="#C0C9D8"/>
                               <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <staticText>
                               <reportElement stretchType="RelativeToTallestObject" mode="Opaque" x="0" y="0" width="130" height="90" backcolor="#F4F6F9" uuid="7113c4eb-9b85-478d-a2f9-a00bf7c237d1">
                                   <property name="net.sf.jasperreports.export.xls.freeze.row.edge" value="Top"/>
                               </reportElement>
                               <box padding="3" topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0">
                                   <pen lineWidth="2.0" lineStyle="Solid" lineColor="#477FF0"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="14" isBold="true"/>
                               </textElement>
                               <text><![CDATA[Ссылка на документ]]></text>
                           </staticText>
                       </jr:columnHeader>
                       <jr:detailCell style="Table 1_TD" height="80">
                           <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/>
                           <box>
                               <pen lineColor="#C0C9D8"/>
                               <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#C0C9D8"/>
                               <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                           </box>
                           <textField textAdjust="StretchHeight" hyperlinkType="Reference" hyperlinkTarget="Blank">
                               <reportElement stretchType="ContainerHeight" x="0" y="0" width="130" height="80" forecolor="#1B23CC" uuid="d76bda64-dcf9-416a-a87d-836cc02e7f12"/>
                               <box padding="3">
                                   <pen lineStyle="Dashed" lineColor="#808080"/>
                                   <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                                   <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/>
                               </box>
                               <textElement textAlignment="Center" verticalAlignment="Middle">
                                   <font fontName="DejaVu Sans" size="12" isUnderline="true"/>
                               </textElement>
                               <textFieldExpression><![CDATA[$F{document_link}==null?"-":$F{document_link}]]></textFieldExpression>
                               <hyperlinkReferenceExpression><![CDATA[$F{document_link}]]></hyperlinkReferenceExpression>
                               <hyperlinkParameter name="_report">
                                   <hyperlinkParameterExpression><![CDATA["/reports/erir/invoice"]]></hyperlinkParameterExpression>
                               </hyperlinkParameter>
                               <hyperlinkParameter name="contract_id">
                                   <hyperlinkParameterExpression><![CDATA[$F{contract_id}]]></hyperlinkParameterExpression>
                               </hyperlinkParameter>
                               <hyperlinkParameter name="start_date">
                                   <hyperlinkParameterExpression><![CDATA["1900-01-01"]]></hyperlinkParameterExpression>
                               </hyperlinkParameter>
                               <hyperlinkParameter name="ended_date">
                                   <hyperlinkParameterExpression><![CDATA[new java.util.Date()]]></hyperlinkParameterExpression>
                               </hyperlinkParameter>
                           </textField>
                       </jr:detailCell>
                   </jr:column>
               </jr:table>
           </componentElement>
       </band>
   </detail>
</jasperReport>

Sign In

how to freezy table (column) headers when scrolling the page in the report?

Recommended Posts

a.number27

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

bigalex

Link to comment

Share on other sites

djohnson53

Link to comment

Share on other sites

yama818

Link to comment

Share on other sites

a.number27

Link to comment

Share on other sites

bigalex

Link to comment

Share on other sites

a.number27

Link to comment

Share on other sites

a.number27

Link to comment

Share on other sites

bigalex

Link to comment

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore