a.number27's Content - Jaspersoft Community

How to make sure that all errors in reports are displayed in Russian?

a.number27 replied to a.number27's topic in Products

THX so much

How to make sure that all errors in reports are displayed in Russian?

a.number27 posted a topic in Products

How to make sure that all errors in reports are displayed in Russian? Is there a localization guide?

How to freeze only top row

a.number27 posted a topic in Products

when exporting a report to xls, I set the "net.sf.jasperreports.export.xls.freeze.row.edge" property to Bottom. But when I open the report in excel, I have 8 lines pinned, instead of the highlighted 1 with headers. How to solve the problem? how to freeze only the top row?

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

a.number27 replied to a.number27's topic in Products

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

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

a.number27 replied to a.number27's topic in Products

<?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="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]

how to change the system font?

a.number27 posted a topic in Products

For example. If the search for a report fails, a pop-up window will appear. How do I change the font size? It seems to be in the system folders associated with the theme

how to fix table (column) headers in the report?

a.number27 replied to a.number27's topic in Products

Good day! the problem is still not resolved. Maybe I can send you a report by mail?

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

a.number27 replied to a.number27's topic in Products

@yama818 thanks

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

a.number27 posted a topic in Products

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

Sign In

a.number27

Posts

Joined

Last visited

Content Type

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Everything posted by a.number27

How to make sure that all errors in reports are displayed in Russian?

How to make sure that all errors in reports are displayed in Russian?

How to freeze only top row

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

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

how to change the system font?

how to fix table (column) headers in the report?

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

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

how to fix table (column) headers in the report?

how to fix table (column) headers in the report?

how to fix table (column) headers in the report?

Activity

Products

Explore