bigalex

Removing the title or adjusting the group header height may correct the issue (see the attached example). Personally, I never use the title in my reports.

Try to change the Evaluation time for that filed to "Report"

Hi, Edit my Expression example and replace "Part_#" with your variables. for example: $P{Part_1} would be $F{Numéro de téléphone domicile de cette personne.Individu}

May help if you show the entire code.

Sorry, I am just guessing here what you are trying to do. (see the attached example) "Telephone: " + ($P{Part_1}!= ""? $P{Part_1}:"") +($P{Part_1}!=""? ($P{Part_2}!= ""? " / "+ $P{Part_2}:""): ($P{Part_2}!= ""? $P{Part_2}:"")) +(($P{Part_1}!="" || $P{Part_2}!= "")? ($P{Part_3}!= ""? " / "+ $P{Part_3}:""):($P{Part_3}!= ""? $P{Part_3}:"")) +(($P{Part_1}!= ""|| $P{Part_2}!= "" || $P{Part_3}!= "")? ($P{Email}!= ""? " / "+ $P{Email}:""):($P{Email}!= ""? $P{Email}:""))

Change your Title hight to 25.

Check all bands hight. Also i notice you have some logo image somewhere

Try to rotate and crop, then save. I tried, and it works (see the attached screenshots)

Have you tried create a groups and reset your pages Page evaluation time : now # of pages evaluation time : group Select Reset page number in the group footter

It's working for me: Image-- Expression: "C:/Users/OneDrive/MyReports/BBC/CC-19/"+$P{FileName}+".png"

Use two images- one with texture and another with text, or use the Static text field for text.

$V{ RoundUp}.setScale(2,BigDecimal. ROUND_HALF_UP)

Upgarade to the lates version. Download Jaspersoft Business Intelligence Suite | Jaspersoft Community

Add <property name="net.sf.jasperreports.export.xls.freeze.row" value="4"/> (Freeze Row #3)

Would you mind providing a code, at least for the parameter?

If you need the page numbers s to continue -don't reset group. The variable $P{Page_Number) is available on the Variable list. Field 1 reset-Now "Page " + $V{PAGE_NUMBER} Field 2 reset-Report ) " of " + $V{PAGE_NUMBER}

A measure is a result of aggregate data calculation. Please provide an example of your data.

See Source code below: V1= $VPage V2=V1 Added 1 in the textbox for visual <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928 --> <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="Blank_A4" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="1b423b67-c8b9-4256-9132-e680bbdfdeac"> <queryString> <![CDATA[]]> </queryString> <variable name="Variable_1" class="java.lang.Integer"> <variableExpression><![CDATA[$V{PAGE_NUMBER}]]></variableExpression> </variable> <variable name="Variable_2" class="java.lang.Integer"> <variableExpression><![CDATA[$V{Variable_1}]]></variableExpression> </variable> <background> <band splitType="Stretch"/> </background> <title> <band height="30" splitType="Stretch"> <textField> <reportElement x="50" y="0" width="100" height="30" uuid="0fd880cc-44e2-4aeb-b4d7-dc16c75006c0"/> <textElement> <font size="12" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="197" y="0" width="100" height="30" uuid="7f39fd74-e747-4d89-9ec4-e3c9fd8737f0"/> <textElement> <font size="12" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{Variable_1}+1]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement x="401" y="0" width="100" height="30" uuid="ba244951-d773-4295-aab3-5648c80340d8"/> <textElement> <font size="12" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$V{Variable_2}+2]]></textFieldExpression> </textField> </band> </title> </jasperReport>

$X{IN,CAT.CAT_CAT_NO,employerRefNumber} $P{employerRefNumber} must be collection class

You may need to create a dataset first, then the other option will be available, just copy the existing query into the dataset. A normal report (with a query) does not have a dataset.

Page # by group: Page # evaluation time : now # Of pages evaluation time : group Select Reset page number in the group footter. 2. Select group header and enter "new Boolean($V{PAGE_NUMBER}.intValue()==1)" into [Print When Expression] 3. Make IF statement in the text field for pages: if # of pages > 1 then "invoice + {number 123}+ continued" else page#

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"?> <!-- Created with Jaspersoft Studio version 6.16.0.final using JasperReports Library version 6.16.0-48579d909b7943b64690c65c71e07e0b80981928 --> <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>

Try to view the results in other formats than Java (e.g. html, pdf, etc.)

Copy and Paste your code here

Convert in query: to_char(blob text)