---

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.12.2.final using JasperReports Library version 6.12.2-75c5e90a222ab406e416cbf590a5397028a52de3  -->
<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="pu_bu" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="aab4d06b-4c0a-4c47-be0a-8ae82a99a6f6">
	<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
	<property name="net.sf.jasperreports.default.locale" value="ru_RU"/>
	<property name="com.jaspersoft.studio.data.defaultdataadapter" value="NEW.xml"/>
	<style name="Table_TH" mode="Opaque" backcolor="#F0F8FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table_CH" mode="Opaque" backcolor="#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>
	<style name="Table_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<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="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table 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>
	<style name="Table 2_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 2_CH" mode="Opaque" backcolor="#BFE1FF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<style name="Table 2_TD" mode="Opaque" backcolor="#FFFFFF">
		<box>
			<pen lineWidth="0.5" lineColor="#000000"/>
			<topPen lineWidth="0.5" lineColor="#000000"/>
			<leftPen lineWidth="0.5" lineColor="#000000"/>
			<bottomPen lineWidth="0.5" lineColor="#000000"/>
			<rightPen lineWidth="0.5" lineColor="#000000"/>
		</box>
	</style>
	<subDataset name="Dataset1" uuid="de3b076e-5efd-417b-bbd5-910538cdb715">
		<property name="com.jaspersoft.studio.data.defaultdataadapter" value="NEW.xml"/>
		<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
		<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w1" value="256"/>
		<property name="com.jaspersoft.studio.data.sql.SQLQueryDesigner.sash.w2" value="738"/>
		<parameter name="id" class="java.lang.Integer">
			<defaultValueExpression><![CDATA[30]]></defaultValueExpression>
		</parameter>
		<queryString>
			<![CDATA[with agg_p as (
    select
        si.id,
        sum(
            coalesce(rd.sum_dt_pu, 0)
            - coalesce(rd.sum_ct_pu, 0)
        ) as s_pu,
        sum(
            coalesce(rd.sum_dt_bu, 0)
            - coalesce(rd.sum_ct_bu, 0)
        ) as s_bu
    from ourpension.spr_indicator_bu si
    join ourpension.spr_indicator_bu si1
        on si.id = si1.is_aggregate
    join ourpension.spr_accounts_indicator_bu sa
        on sa.spr_indicator_bu_id = si1.id
    join back_office.report_conformity_pu_bu_detail rd
        on rd.report_conformity_pu_bu_id = $P{id}
       and rd.account = sa.account
    join back_office.report_conformity_pu_bu r
        on r.id = rd.report_conformity_pu_bu_id
       and r.service_type = any(si.service_type)
       and r.service_type = any(si1.service_type)
    group by si.id
),
agg_sum as (
 select
    si.id,
    sum(
        coalesce(rd.sum_dt_pu, 0)
        - coalesce(rd.sum_ct_pu, 0)
    ) as s_pu,
    sum(
        coalesce(rd.sum_dt_bu, 0)
        - coalesce(rd.sum_ct_bu, 0)
    ) as s_bu
  from ourpension.spr_indicator_bu si
  join ourpension.spr_accounts_indicator_bu sa
    on sa.spr_indicator_bu_id = si.id
  join back_office.report_conformity_pu_bu_detail rd
    on rd.report_conformity_pu_bu_id = $P{id}
    and rd."account" = sa.account
  join back_office.report_conformity_pu_bu r
    on r.id = rd.report_conformity_pu_bu_id
   and r."service_type" = any(si."service_type")
  group by si.id
),
all_sum as (
    select
        0 as id,
        1 as step,
        sum(
            coalesce(rd.sum_dt_pu, 0)
            - coalesce(rd.sum_ct_pu, 0)
        ) as s_pu,
        sum(
            coalesce(rd.sum_dt_bu, 0)
            - coalesce(rd.sum_ct_bu, 0)
        ) as s_bu
    from back_office.report_conformity_pu_bu_detail rd
    where rd.report_conformity_pu_bu_id = $P{id}
),
agg_all as (
select id, s_pu, s_bu
from agg_p
union all
select a.id, a.s_pu, a.s_bu
from agg_sum a
left join agg_p b 
       on a.id = b.id
where b.id is null
),
si_agg as (
  select si.id, 1 as step, string_agg(sa.account,'+' order by sa.account) as accounts
  from ourpension.spr_indicator_bu si
  join ourpension.spr_accounts_indicator_bu sa
    on sa.spr_indicator_bu_id = si.id
  join back_office.report_conformity_pu_bu r
    on r.id = $P{id}
   and r."service_type" = any(si."service_type")
  group by si.id
)
, report_rows as (
    select
        si.id,
        sia.step,
        si.name,
        sia.accounts,
        a.s_pu,
        a.s_bu,
        coalesce(a.s_pu, 0) - coalesce(a.s_bu, 0) as razn
    from ourpension.spr_indicator_bu si
    join si_agg sia
        on si.id = sia.id
    left join agg_all a
        on si.id = a.id

    union all

    select
        id,
        step,
        '',
        '',
        s_pu,
        s_bu,
        coalesce(s_pu, 0) - coalesce(s_bu, 0)
    from all_sum

    union all

    select distinct
        si.is_aggregate,
        2,
        'в т.ч.',
        '',
        0,
        0,
        0
    from ourpension.spr_indicator_bu si
    join back_office.report_conformity_pu_bu r
        on r.id = $P{id}
       and r.service_type = any(si.service_type)
    where si.is_aggregate is not null
      and 'OPS' = any(si.service_type)

    union all

    select
        cast(
            (
                select coalesce(max(ind.id), 0)
                from ourpension.spr_indicator_bu ind
            )
            + row_number() over (order by m.account)
            as integer
        ) as id,
        1 as step,
        'Счёт ' || m.account as name,
        m.account as accounts,
        m.s_pu,
        m.s_bu,
        m.s_pu - m.s_bu as razn
    from (
        select
            rd.account,
            sum(
                coalesce(rd.sum_dt_pu, 0)
                - coalesce(rd.sum_ct_pu, 0)
            ) as s_pu,
            sum(
                coalesce(rd.sum_dt_bu, 0)
                - coalesce(rd.sum_ct_bu, 0)
            ) as s_bu
        from back_office.report_conformity_pu_bu_detail rd
        join back_office.report_conformity_pu_bu r
            on r.id = rd.report_conformity_pu_bu_id
        where rd.report_conformity_pu_bu_id = $P{id}
          and not exists (
              select 1
              from ourpension.spr_accounts_indicator_bu sa
              join ourpension.spr_indicator_bu si
                  on si.id = sa.spr_indicator_bu_id
              where sa.account = rd.account
                and r.service_type = any(si.service_type)
          )
        group by rd.account
    ) m
),
sort_accounts as (
    select
        g.group_account,
        g.group_no,
        r.service_type,
        (
            select min(ind.id)
            from ourpension.spr_indicator_bu ind
            join ourpension.spr_accounts_indicator_bu sa
                on sa.spr_indicator_bu_id = ind.id
            where sa.account = g.anchor_account
              and r.service_type = any(ind.service_type)
        ) as sort_id
    from (
        values
            ('38911', '38911.1', 1),
            ('39011', '39011.1', 1),
            ('39031', '39033',   1),
            ('39032', '39033',   2),
            ('39033', '39033',   3),
            ('39034', '39034.2', 1),
            ('39035', '48305',   1),
            ('39036', '48305',   2),
            ('39037', '48305',   3),
            ('48305', '48305',   4),
            ('48306', '48306',   1)
    ) as g(group_account, anchor_account, group_no)
    join back_office.report_conformity_pu_bu r
        on r.id = $P{id}
       and r.service_type in ('NPO', 'PDS')
),
indicator_order as (
    select
        si.id,
        min(g.sort_id) as sort_id,
        min(g.group_no) as group_no,
        min(
            case
                when sa.account = g.group_account then 0
                when sa.account = g.group_account || '.1' then 1
                when sa.account = g.group_account || '.2' then 2

                when g.group_account in ('48305', '48306')
                 and sa.account = g.group_account || '.3'
                    then 2

                when g.group_account = '48305'
                 and sa.account = '48310' then 3

                when g.group_account = '48306'
                 and sa.account = '48309' then 3

                when g.group_account = '48305'
                 and sa.account = '60301' then 4

                when g.group_account = '48306'
                 and sa.account = '60302' then 4

                when g.group_account = '48305'
                 and sa.account = '60322' then 5

                when g.group_account = '48306'
                 and sa.account = '60323' then 5
            end
        ) as row_no
    from sort_accounts g
    join ourpension.spr_accounts_indicator_bu sa
        on sa.account in (
            g.group_account,
            g.group_account || '.1',
            g.group_account || '.2'
        )
        or (
            g.group_account = '48305'
            and sa.account in (
                '48305.3', '48310', '60301', '60322'
            )
        )
        or (
            g.group_account = '48306'
            and sa.account in (
                '48306.3', '48309', '60302', '60323'
            )
        )
    join ourpension.spr_indicator_bu si
        on si.id = sa.spr_indicator_bu_id
       and g.service_type = any(si.service_type)
    group by si.id
)
select
    rr.id,
    rr.step,
    rr.name,
    rr.accounts,
    rr.s_pu,
    rr.s_bu,
    rr.razn
from report_rows rr
left join indicator_order io
    on io.id = rr.id
order by
    coalesce(io.sort_id, rr.id),
    coalesce(io.group_no, 0),
    coalesce(io.row_no, 0),
    rr.id,
    rr.step]]>
		</queryString>
		<field name="id" class="java.lang.Integer">
			<property name="com.jaspersoft.studio.field.label" value="id"/>
		</field>
		<field name="step" class="java.lang.Integer">
			<property name="com.jaspersoft.studio.field.label" value="step"/>
		</field>
		<field name="name" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="name"/>
		</field>
		<field name="accounts" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="accounts"/>
		</field>
		<field name="s_pu" class="java.math.BigDecimal">
			<property name="com.jaspersoft.studio.field.label" value="s_pu"/>
		</field>
		<field name="s_bu" class="java.math.BigDecimal">
			<property name="com.jaspersoft.studio.field.label" value="s_bu"/>
		</field>
		<field name="razn" class="java.math.BigDecimal">
			<property name="com.jaspersoft.studio.field.label" value="razn"/>
		</field>
	</subDataset>
	<subDataset name="Dataset2" uuid="4620ac73-15be-4846-a14c-921d5896b22c">
		<property name="com.jaspersoft.studio.data.defaultdataadapter" value="postgre"/>
		<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
		<parameter name="signAgentIdPU" class="java.lang.String"/>
		<queryString>
			<![CDATA[select distinct on (a.id) a.id, ap.position, concat(a.last_name, ' ', a.first_name, ' ', a.middle_name) as fio 
from ourpension.agent a
join ourpension.agent_position ap
  on ap.agent_id = a.id
where a.id = ANY(string_to_array($P{signAgentIdPU}, ',') ::int[])]]>
		</queryString>
		<field name="id" class="java.lang.Integer">
			<property name="com.jaspersoft.studio.field.label" value="id"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="agent"/>
		</field>
		<field name="position" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="position"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="agent_position"/>
		</field>
		<field name="fio" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="fio"/>
		</field>
	</subDataset>
	<subDataset name="Dataset3" uuid="7c55d1c5-017b-47b5-a3e9-ecb4231fc4f2">
		<property name="com.jaspersoft.studio.data.defaultdataadapter" value="postgre"/>
		<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
		<parameter name="signAgentIdBU" class="java.lang.String"/>
		<queryString>
			<![CDATA[select distinct on (a.id) a.id, ap.position, concat(a.last_name, ' ', a.first_name, ' ', a.middle_name) as fio 
from ourpension.agent a
join ourpension.agent_position ap
  on ap.agent_id = a.id
where a.id = ANY(string_to_array($P{signAgentIdBU}, ',') ::int[])]]>
		</queryString>
		<field name="id" class="java.lang.Integer">
			<property name="com.jaspersoft.studio.field.label" value="id"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="agent"/>
		</field>
		<field name="position" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="position"/>
			<property name="com.jaspersoft.studio.field.tree.path" value="agent_position"/>
		</field>
		<field name="fio" class="java.lang.String">
			<property name="com.jaspersoft.studio.field.label" value="fio"/>
		</field>
	</subDataset>
	<parameter name="id" class="java.lang.Integer"/>
	<parameter name="signAgentIdPU" class="java.lang.String"/>
	<parameter name="signAgentIdBU" class="java.lang.String"/>
	<parameter name="executorAgentIdPU" class="java.lang.String"/>
	<parameter name="executorAgentIdBU" class="java.lang.String"/>
	<queryString language="SQL">
		<![CDATA[select
    form_date,
    to_char(
        to_date(m_y_report, 'MM.YYYY') + interval '1 month - 1 day',
        'DD.MM.YYYY'
    ) as enddate,
    (
        select concat_ws(' ', a.last_name, a.first_name, a.middle_name)
        from ourpension.agent a
        where a.id = cast(nullif($P{executorAgentIdPU}, '') as bigint)
    ) as executor_fio_pu,
    (
        select concat_ws(' ', a.last_name, a.first_name, a.middle_name)
        from ourpension.agent a
        where a.id = cast(nullif($P{executorAgentIdBU}, '') as bigint)
    ) as executor_fio_bu
from back_office.report_conformity_pu_bu
where id = $P{id}]]>
	</queryString>
	<field name="form_date" class="java.sql.Date">
		<property name="com.jaspersoft.studio.field.label" value="form_date"/>
		<property name="com.jaspersoft.studio.field.tree.path" value="report_conformity_pu_bu"/>
	</field>
	<field name="enddate" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="enddate"/>
	</field>
	<field name="executor_fio_pu" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="executor_fio_pu"/>
	</field>
	<field name="executor_fio_bu" class="java.lang.String">
		<property name="com.jaspersoft.studio.field.label" value="executor_fio_bu"/>
	</field>
	<detail>
		<band height="276" splitType="Stretch">
			<componentElement>
				<reportElement stretchType="RelativeToBandHeight" x="0" y="120" width="550" height="60" isRemoveLineWhenBlank="true" isPrintWhenDetailOverflows="true" uuid="5441010e-6e5a-461d-8d9a-f47e56a27027">
					<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
					<property name="com.jaspersoft.studio.table.style.table_header" value="Table_TH"/>
					<property name="com.jaspersoft.studio.table.style.column_header" value="Table_CH"/>
					<property name="com.jaspersoft.studio.table.style.detail" value="Table_TD"/>
				</reportElement>
				<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd" whenNoDataType="AllSectionsNoDetail">
					<datasetRun subDataset="Dataset1" uuid="f236a7a0-1935-4802-a0ff-df5cda08ee2d">
						<datasetParameter name="id">
							<datasetParameterExpression><![CDATA[$P{id}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="150" uuid="165499e6-de25-45bb-8a55-eac69ca5b6d5">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
						<jr:columnHeader style="Table_CH" height="40" rowSpan="1">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<staticText>
								<reportElement stretchType="RelativeToBandHeight" x="0" y="0" width="150" height="40" uuid="521d07d7-979e-4b15-875c-11821ad221d6"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[Показатель]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="Table_TD" height="15">
							<property name="com.jaspersoft.studio.unit.height" value="px"/>
							<textField textAdjust="StretchHeight" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="150" height="15" isPrintWhenDetailOverflows="true" uuid="6fc3f20a-89b6-4a3c-a719-77a92b7bf86d"/>
								<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="70" uuid="444c5831-25f8-475f-98e0-454a6fa76e86">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>
						<jr:columnHeader style="Table_CH" height="40" rowSpan="1">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<staticText>
								<reportElement x="0" y="0" width="70" height="40" uuid="292719be-fdb0-4bc0-86fc-9a68f99f380b"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[Счет]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="Table_TD" height="15">
							<textField textAdjust="StretchHeight" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="70" height="15" uuid="183b11e8-f67b-478e-b42d-5914317dbb27"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{accounts}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="110" uuid="2ec736bd-a1ed-4592-afa4-d154774649db">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>
						<jr:columnHeader style="Table_CH" height="40" rowSpan="1">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<property name="com.jaspersoft.studio.unit.height" value="px"/>
							<staticText>
								<reportElement x="0" y="0" width="110" height="40" uuid="247b3d96-1eb0-4ae7-af84-2ee59bb68f7c"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[Система персонифицированного учета]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="Table_TD" height="15">
							<textField textAdjust="StretchHeight" pattern="#,##0.00#" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="110" height="15" uuid="35ffe4e8-2916-4504-9fce-77ef67e11acb"/>
								<textElement textAlignment="Right" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{step} != 2 ? ($F{s_pu} == null ? 0 : $F{s_pu}) : null]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="110" uuid="8484f0a4-2de7-4304-914f-08df63bb0bd6">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/>
						<jr:columnHeader style="Table_CH" height="40" rowSpan="1">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<staticText>
								<reportElement x="0" y="0" width="110" height="40" uuid="54afe149-c713-4279-8e83-c19aefbe2d69"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[Система бухгалтерского учета]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="Table_TD" height="15">
							<textField textAdjust="StretchHeight" pattern="#,##0.00#" isBlankWhenNull="true">
								<reportElement stretchType="RelativeToTallestObject" x="0" y="0" width="110" height="15" uuid="b0d006df-5df8-4f5c-a9e2-b78af4089468"/>
								<textElement textAlignment="Right" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{step} != 2 ? ($F{s_bu} == null ? 0 : $F{s_bu}) : null]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="110" uuid="bfefd073-152c-4d1b-81ea-63410d4459e9">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/>
						<jr:columnHeader style="Table_CH" height="40" rowSpan="1">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<staticText>
								<reportElement x="0" y="0" width="110" height="40" uuid="7129f623-aea6-4921-afb9-10f4abc66e66"/>
								<textElement textAlignment="Center" verticalAlignment="Middle"/>
								<text><![CDATA[Расхождения]]></text>
							</staticText>
						</jr:columnHeader>
						<jr:detailCell style="Table_TD" height="15">
							<textField textAdjust="StretchHeight" pattern="#,##0.00#" isBlankWhenNull="true">
								<reportElement x="0" y="0" width="110" height="15" uuid="836b59a9-1b4b-49ea-b6c3-5a767522f4d5"/>
								<textElement textAlignment="Right" verticalAlignment="Middle"/>
								<textFieldExpression><![CDATA[$F{step} != 2 ? $F{razn} : null]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
			<staticText>
				<reportElement x="0" y="0" width="545" height="15" uuid="6ad7e374-2015-4a7e-b77b-ba4360c3f345">
					<property name="com.jaspersoft.studio.unit.x" value="px"/>
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center"/>
				<text><![CDATA[Акт соответствия сведений № 04-ПН]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="15" width="550" height="15" uuid="cb3e463f-0b5b-44dd-9a6c-2148d229db60">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textElement textAlignment="Center"/>
				<text><![CDATA[персонифицированного и бухгалтерского учетов Фонда]]></text>
			</staticText>
			<textField pattern="dd.MM.yyyy">
				<reportElement x="380" y="30" width="170" height="30" uuid="a4791603-11cd-4903-aed8-6912ad84a233"/>
				<textElement textAlignment="Right" verticalAlignment="Bottom"/>
				<textFieldExpression><![CDATA[$F{form_date}]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="0" y="30" width="180" height="30" uuid="0b29544e-0234-4f4e-b7a4-5853008a76db"/>
				<textElement verticalAlignment="Bottom"/>
				<text><![CDATA[АО "НПФ "БУДУЩЕЕ"]]></text>
			</staticText>
			<staticText>
				<reportElement x="0" y="60" width="550" height="30" uuid="2ded7b03-e81f-4761-8fd2-3437085a8de0"/>
				<textElement verticalAlignment="Bottom"/>
				<text><![CDATA[В соответствии с Регламентом взаимодействия подразделений, произведена сверка учета операций.	]]></text>
			</staticText>
			<textField>
				<reportElement x="0" y="90" width="550" height="15" uuid="7ec9fce3-b47a-4c2e-87bf-5c96bc5cb63a">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<textFieldExpression><![CDATA["На дату "+$F{enddate}+"г.  в системах Фонда отражены следующие показатели:	"]]></textFieldExpression>
			</textField>
			<staticText>
				<reportElement x="440" y="105" width="110" height="15" uuid="ec295a81-8e2a-4518-a2ee-33d0c2efa906">
					<property name="com.jaspersoft.studio.unit.height" value="px"/>
				</reportElement>
				<text><![CDATA[(руб.)]]></text>
			</staticText>
			<componentElement>
				<reportElement positionType="Float" x="0" y="210" width="270" height="60" uuid="98ce6bad-aad0-44d4-b7cc-ecae2c9d811b">
					<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="Dataset2" uuid="1151ffd2-5086-4f26-af33-d70bf3e264aa">
						<datasetParameter name="signAgentIdPU">
							<datasetParameterExpression><![CDATA[$P{signAgentIdPU}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="100" uuid="7dc66f0e-7818-4347-9d20-cdba0a5a2adc">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<box>
								<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>
							<textField textAdjust="StretchHeight" isBlankWhenNull="true">
								<reportElement x="0" y="0" width="100" height="30" uuid="d6a5fe5d-ab79-4702-923c-c92106cb5847"/>
								<textFieldExpression><![CDATA[$F{position}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="100" uuid="98530959-222c-4d82-bfaf-4f1f7a167084">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<box>
								<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>
							<textField textAdjust="StretchHeight" isBlankWhenNull="true">
								<reportElement x="0" y="0" width="100" height="30" uuid="8574ac66-600e-434c-a3a9-e92bb983e956"/>
								<textFieldExpression><![CDATA[$F{fio}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="70" uuid="9a2bfd7f-8c18-470f-a852-e8fd7817ead0">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>
						<jr:detailCell style="Table 1_TD" height="30">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<box>
								<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 mode="Opaque" x="0" y="0" width="70" height="30" isPrintWhenDetailOverflows="true" uuid="a11ba10d-2a2c-41e4-9042-9aea6eea2040"/>
								<box>
									<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 verticalAlignment="Bottom"/>
								<text><![CDATA[____________ ]]></text>
							</staticText>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
			<componentElement>
				<reportElement positionType="Float" x="280" y="210" width="270" height="60" uuid="5854d801-57df-455c-890d-a1763ff3e75e">
					<property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/>
					<property name="com.jaspersoft.studio.table.style.table_header" value="Table 2_TH"/>
					<property name="com.jaspersoft.studio.table.style.column_header" value="Table 2_CH"/>
					<property name="com.jaspersoft.studio.table.style.detail" value="Table 2_TD"/>
					<property name="com.jaspersoft.studio.unit.width" 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">
					<datasetRun subDataset="Dataset3" uuid="9430633f-b833-4216-911d-edf6a63ca19e">
						<datasetParameter name="signAgentIdBU">
							<datasetParameterExpression><![CDATA[$P{signAgentIdBU}]]></datasetParameterExpression>
						</datasetParameter>
						<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>
					</datasetRun>
					<jr:column width="100" uuid="1baf6197-a2f2-48b9-accf-1c42c338deb5">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/>
						<jr:detailCell style="Table 2_TD" height="30">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<box>
								<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>
							<textField textAdjust="StretchHeight" isBlankWhenNull="true">
								<reportElement x="0" y="0" width="100" height="30" uuid="5f2c2962-13a6-43f0-94db-4986b82e4071"/>
								<textFieldExpression><![CDATA[$F{position}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="100" uuid="1c489180-9ef1-4221-957a-a97a32f1f33b">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/>
						<jr:detailCell style="Table 2_TD" height="30">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<box>
								<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>
							<textField textAdjust="StretchHeight">
								<reportElement x="0" y="0" width="100" height="30" uuid="5eb4cce2-f96d-4ef6-bd69-34874a47ceae"/>
								<textFieldExpression><![CDATA[$F{fio}]]></textFieldExpression>
							</textField>
						</jr:detailCell>
					</jr:column>
					<jr:column width="70" uuid="3bb2c7ba-562d-4e86-bca7-eb6262252f78">
						<property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/>
						<jr:detailCell style="Table 2_TD" height="30">
							<property name="com.jaspersoft.studio.unit.width" value="px"/>
							<box>
								<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 x="0" y="0" width="70" height="30" uuid="a3c0d41c-cbf3-4346-b86d-427a49ddfce1"/>
								<textElement verticalAlignment="Bottom"/>
								<text><![CDATA[____________ ]]></text>
							</staticText>
						</jr:detailCell>
					</jr:column>
				</jr:table>
			</componentElement>
			<staticText>
				<reportElement positionType="Float" x="0" y="180" width="100" height="30" uuid="db385d89-3acc-4548-b598-e2f22aec5bbe"/>
				<textElement verticalAlignment="Bottom"/>
				<text><![CDATA[От ДПУ:]]></text>
			</staticText>
			<staticText>
				<reportElement positionType="Float" x="280" y="180" width="100" height="30" uuid="25418281-f782-434b-8ed9-a66abbb571a6"/>
				<textElement verticalAlignment="Bottom"/>
				<text><![CDATA[От Бухгалтерии:]]></text>
			</staticText>
		</band>
		<band height="50">
			<textField>
				<reportElement x="0" y="2" width="270" height="30" uuid="d6e455ff-77fb-44ff-bdfe-1bb2177d0324"/>
				<textFieldExpression><![CDATA["Подписант от ДПУ: " + $F{executor_fio_pu}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="280" y="2" width="270" height="30" uuid="5650c2ff-31ce-4cdd-b25f-0efd253a4fcf"/>
				<textFieldExpression><![CDATA["Подписант от Бухгалтерии: " + $F{executor_fio_bu}]]></textFieldExpression>
			</textField>
		</band>
	</detail>
</jasperReport>