3.07 R21.09
32127
12
5
135168
0
0
0
0
0
0
0
0
0
<XtraReportsLayoutSerializer SerializerVersion="16.2.5.0" Ref="1" ControlType="DevExpress.XtraReports.UI.XtraReport, DevExpress.XtraReports.v16.2, Version=16.2.5.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Name="BaseReport" ScriptsSource="// Ссылка на экземпляр формируемого отчета 
private XtraReport report = null;

// Строка с форматом вывода даты/времени по умолчанию
private string formatString = "";

// Парамер задаваемый пользователем
private string userParameter = "";

private bool group1 = false, group2 = false;

// Обрабатывает запрос источника данных
private void BaseReport_DataSourceDemanded(object sender, System.EventArgs e) 
{
	// Ссылка на экземпляр формируемого отчета 
	this.report = (XtraReport)sender;

	// Получаем значение параметра задаваемого пользователем при формировании отчета
	// Переменную userParameter можно использовать в обработчиках события 'Получить значение' 
	// для вычисляемых полей создаваемых в любых узлах.
	if (this.report.Parameters["USER_PARAMETER"] != null)
		this.userParameter = Convert.ToString(this.report.Parameters["USER_PARAMETER"].Value);
}

// Формирование номера по порядку в группах
private void N_BeforePrint(object sender, System.Drawing.Printing.PrintEventArgs e) 
{
	if (this.GetCurrentColumnValue(this.groupData.Name) == null)
		return;

	XRTableCell cell = (XRTableCell)sender;

	int groupdata = Convert.ToInt32(this.GetCurrentColumnValue(this.groupData.Name).ToString());
	if (groupdata == 1)
	{
		// Группа средств измерения, у которых срок поверки заканчивается в указанном периоде 
		group1 = true;
	}
	else
	{
		// Группа средств измерения с истекшим сроком поверки
		group2 = true;
	}
}

private void footerText_PrintOnPage(object sender, DevExpress.XtraReports.UI.PrintOnPageEventArgs e) 
{
	if (!group1)
		footerText.Text = "Не найдены средства измерения, у которых срок поверки заканчивается в указанном периоде.";
	if (!group2)
		footerText.Text = "Не найдены средства измерения c истекшим сроком поверки.";
}

" SnapGridSize="5" ReportUnit="TenthsOfAMillimeter" Landscape="true" Margins="250, 100, 100, 84" PaperKind="A4" PageWidth="2970" PageHeight="2100" Version="16.2" RequestParameters="false" DataMember="Устройство" DataSource="#Ref-0" Dpi="254" Font="Arial, 9.75pt" Tag_type="System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Tag="1">
<FormattingRuleSheet>
<Item1 Ref="2" Name="formattingRule1">
<Formatting Ref="3" BorderStyle="Inset" StringFormat="Near;Near;0;None;Character;Default" />
</Item1>
</FormattingRuleSheet>
<Parameters>
<Item1 Ref="5" Description="Дата начала отчетного периода" ValueInfo="2017-04-20" Name="DATE_START" Type="#Ref-4" />
<Item2 Ref="6" Description="Дата окончания отчетного периода" ValueInfo="2017-04-20" Name="DATE_END" Type="#Ref-4" />
<Item3 Ref="8" Description="Идентификатор учетной записи" ValueInfo="0" Name="ACCOUNT_ID" Type="#Ref-7" />
<Item4 Ref="9" Description="Тип данных, по которым формируется отчет." ValueInfo="0" Name="DATA_TYPE" Type="#Ref-7" />
<Item5 Ref="11" Description="Параметр отчета задаваемый пользователем при формировании отчета." Name="USER_PARAMETER" />
</Parameters>
<CalculatedFields>
<Item1 Ref="12" Name="daysForCalibration" FieldType="Int32" Expression="Iif(IsNull([ScheduledCalibrationDate]), ?, DateDiffDay(Today(), [ScheduledCalibrationDate]))" DataMember="Устройство" />
<Item2 Ref="13" Name="groupData" Expression="Iif(IsNull([daysForCalibration]), ?,Iif([daysForCalibration] < 0, -1, 1))" DataMember="Устройство" />
<Item3 Ref="14" Name="groupTitle" Expression="Iif(IsNull([groupData]), 'Не найдены средства измерения требущие поверки' , Iif([groupData] < 0, 'Средства измерения с истекшим сроком поверки.', 'Средства измерения, у которых срок поверки заканчивается в указанном периоде.'))" DataMember="Устройство" />
<Item4 Ref="15" Name="NN" FieldType="Int32" DataMember="Устройство">
<Scripts Ref="16" OnGetValue="NN_GetValue" />
</Item4>
<Item5 Ref="17" Name="absDaysForCalibration" FieldType="Int32" Expression="Abs([daysForCalibration])" DataMember="Устройство" />
<Item6 Ref="18" Name="daysTitle" Expression="Iif( [groupData] > 0, 'Срок до окончания поверки, сут.', 'Поверка просрочена, сут.')" DataMember="Устройство" />
</CalculatedFields>
<Bands>
<Item1 Ref="19" ControlType="ReportHeaderBand" Name="ReportHeader" HeightF="120.770813" Dpi="254" Font="Arial, 9.75pt" Tag_type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Tag="24736">
<Controls>
<Item1 Ref="20" ControlType="XRLabel" Name="label6" Text="Дата составления " TextAlignment="MiddleCenter" SizeF="349.839478,58.4200058" LocationFloat="1018.66351, 59.4200439" Dpi="254" Font="Arial, 11.25pt" Padding="5,5,0,0,254">
<StylePriority Ref="21" UseFont="false" UseTextAlignment="false" />
</Item1>
<Item2 Ref="22" ControlType="XRPageInfo" Name="pageInfo2" PageInfo="DateTime" Format="{0:dd.MM.yyyy}" TextAlignment="MiddleCenter" SizeF="232.8335,58.41999" LocationFloat="1368.50293, 59.4200668" Dpi="254" Font="Arial, 11.25pt, charSet=204" Padding="5,5,0,0,254">
<StylePriority Ref="23" UseFont="false" UseTextAlignment="false" />
</Item2>
<Item3 Ref="24" ControlType="XRPictureBox" Name="pictureBox1" Image="iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAIAAAD8GO2jAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAAr/AAAK/wE0YpqCAAADe0lEQVRIS7WUXUhTYRjH34sYXUR33kR20SdkZHRhFFlEEFToRVgpETW76MsMLQgiI6kLs4KpYZkpqGkzS5mouC8/I81S15jNnLpN53b2qWufZx+u53hez6am24T9eG7O857n93/PezgHje2Kj2lRAeY3+TGqYEAgBqwngPQHvunc+CIcUQeAPaWFYJVO8pQO3FqT6ALAntpCoJIJVDrJKlfx1E68sDpRBITa0VslKlexqqd5mjBnFWlA0P5mwf5ehaqmUO0M6zPB066VEVHA/+zTYEefdOgLsZWn7yVIfOsKwgcst1cssW9p0ie3GC6KzMMmDx5YSpiAoB3UtL16GtXNoAbKHt+kP9ZqPC8wsTsst3tm5RYvHgshTMBVkWGl/aDIVK507uAZjrcaLwjNYL/ZZXnUZy0atqv/+vDkImECpCYyDl4m2CvV2C42mT3zsNStIzNEFrDf6rbk9Vk5Q7YKmeOD3Kl3+ulZmjABgNTsiavToBoNY3cO9NvEQlj6YfDc6Zl73A97p+w1vx3tKrfE4HWHPAYOGNyXoC57jnsh+LXjAZddOuuNayQYuyJxz9je7TaRAG4YMXtfS+z03vmU3TNj8+sd1CNS436/pPCJZO8e1J50RFZZTHcZfDMKKHKow0dMjfz1Be30T3gxQ2n1cf+4hGq3FNuDRzQ/P99bwuk6mIRyMx5W1FN3M9B296DYzq9zCLjeKQU0bUI+eHHA7m1zDVy/zepRjsO5y0w+sBuXvgCgsbK26uQ5dDa7Ir/pJ+4tnAxjh7J+LLaUPSVHf8ESzli0a66lqVKOkn/kLl/A7MInE0oRV8xmF6Cd+Z1ZreO4B7jt5FAnY4cXZSzIMRXec8uoTUDG3Od62j6RnABPM3EoETLo0WXkNMv357WhTa+kV9q1uLeAz6BxCLmMHYp4mKnLvugc6IHVUDtdq2Vktqk3v5QgFmc0g6/HvUW8mknLu2eMXZuVNn35lObKaZugeZmdLuJBLp4M4RJft5EzguBzhS8e90IgFTLTi/uMHUqVehjUK+3aG5kBz39+R+l8wwbO2KoBgFs+rLubvj47cF5gpH42awQArqE+DfvMOuwAaMMHAM7vvZMnDkRrByINABxfOxTMVxaZHYgiALCLBUxGJHYgugCAztBeZ0diB6IOAFzDgxHagfUERMWSgBgVDohhlUz8A3pvZMzN7axWAAAAAElFTkSuQmCC" AnchorVertical="Top" SizeF="114.3,114.3" LocationFloat="0, 0" Dpi="254" />
<Item4 Ref="25" ControlType="XRLabel" Name="label1" Text="Отчет о сроках поверок средств измерения за период с" TextAlignment="MiddleCenter" SizeF="1049.61255,58.4200058" LocationFloat="511.006348, 0" Dpi="254" Font="Arial, 11.25pt" Padding="5,5,0,0,254">
<StylePriority Ref="26" UseFont="false" UseTextAlignment="false" />
</Item4>
<Item5 Ref="27" ControlType="XRLabel" Name="label3" Text="label3" TextAlignment="MiddleCenter" SizeF="230.1709,58.4200058" LocationFloat="1560.6189, 1.00001967" Dpi="254" Font="Arial, 11.25pt" Padding="5,5,0,0,254">
<DataBindings>
<Item1 Ref="29" Parameter="#Ref-5" FormatString="{0:dd.MM.yyyy}" PropertyName="Text" DataMember="DATE_START" />
</DataBindings>
<StylePriority Ref="30" UseFont="false" UseTextAlignment="false" />
</Item5>
<Item6 Ref="31" ControlType="XRLabel" Name="label4" Text="по" TextAlignment="MiddleCenter" SizeF="60.854126,58.42" LocationFloat="1790.78979, 0" Dpi="254" Font="Arial, 11.25pt, charSet=204" Padding="5,5,0,0,254">
<StylePriority Ref="32" UseFont="false" UseTextAlignment="false" />
</Item6>
<Item7 Ref="33" ControlType="XRLabel" Name="label5" Text="label5" TextAlignment="MiddleCenter" SizeF="230.1709,58.4200058" LocationFloat="1851.64392, 1" Dpi="254" Font="Arial, 11.25pt" Padding="5,5,0,0,254">
<DataBindings>
<Item1 Ref="34" Parameter="#Ref-6" FormatString="{0:dd.MM.yyyy}" PropertyName="Text" DataMember="DATE_END" />
</DataBindings>
<StylePriority Ref="35" UseFont="false" UseTextAlignment="false" />
</Item7>
</Controls>
<StylePriority Ref="36" UseFont="false" />
</Item1>
<Item2 Ref="37" ControlType="DetailBand" Name="Detail" HeightF="63.5" Dpi="254">
<SortFields>
<Item1 Ref="38" FieldName="Serviceman" />
</SortFields>
<Controls>
<Item1 Ref="39" ControlType="XRTable" Name="table2" SizeF="2620.00024,63.5" LocationFloat="0, 0" Dpi="254">
<Rows>
<Item1 Ref="40" ControlType="XRTableRow" Name="tableRow2" Weight="1" Dpi="254">
<Cells>
<Item1 Ref="41" ControlType="XRTableCell" Name="N" Weight="0.24584569815429275" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Left, Right, Bottom">
<Scripts Ref="42" OnBeforePrint="N_BeforePrint" />
<Summary Ref="43" FormatString="{0:F0}" Running="Group" Func="RecordNumber" />
<DataBindings>
<Item1 Ref="44" PropertyName="Text" DataMember="Устройство.ScheduledCalibrationDate" />
</DataBindings>
<StylePriority Ref="45" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item1>
<Item2 Ref="46" ControlType="XRTableCell" Name="tableCell2" Weight="1.561446112189292" TextAlignment="MiddleLeft" Dpi="254" Font="Arial, 9.75pt" Padding="10,0,0,0,254" Borders="Right, Bottom">
<DataBindings>
<Item1 Ref="47" PropertyName="Text" DataMember="Устройство.NodeTitle" />
</DataBindings>
<StylePriority Ref="48" UseFont="false" UsePadding="false" UseBorders="false" UseTextAlignment="false" />
</Item2>
<Item3 Ref="49" ControlType="XRTableCell" Name="tableCell10" Weight="1.164582290048674" TextAlignment="MiddleLeft" Dpi="254" Font="Arial, 9.75pt" Padding="10,0,0,0,254" Borders="Right, Bottom">
<DataBindings>
<Item1 Ref="50" PropertyName="Text" DataMember="Устройство.Address" />
</DataBindings>
<StylePriority Ref="51" UseFont="false" UsePadding="false" UseBorders="false" UseTextAlignment="false" />
</Item3>
<Item4 Ref="52" ControlType="XRTableCell" Name="tableCell20" Weight="1.0099933382116961" Text="tableCell20" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Right, Bottom">
<DataBindings>
<Item1 Ref="53" PropertyName="Text" DataMember="Устройство.Serviceman" />
</DataBindings>
<StylePriority Ref="54" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item4>
<Item5 Ref="55" ControlType="XRTableCell" Name="tableCell11" Weight="0.776957853125663" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Right, Bottom">
<DataBindings>
<Item1 Ref="56" PropertyName="Text" DataMember="Устройство.Model" />
</DataBindings>
<StylePriority Ref="57" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item5>
<Item6 Ref="58" ControlType="XRTableCell" Name="tableCell12" Weight="1.1754358685854767" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Right, Bottom">
<DataBindings>
<Item1 Ref="59" PropertyName="Text" DataMember="Устройство.SerialNumber" />
</DataBindings>
<StylePriority Ref="60" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item6>
<Item7 Ref="61" ControlType="XRTableCell" Name="tableCell13" Weight="0.65155288462332284" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Right, Bottom">
<DataBindings>
<Item1 Ref="62" PropertyName="Text" DataMember="Устройство.Вариант исполнения.NominalDiameter" />
</DataBindings>
<StylePriority Ref="63" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item7>
<Item8 Ref="64" ControlType="XRTableCell" Name="tableCell18" Weight="0.51936893948127749" Text="tableCell18" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Right, Bottom">
<DataBindings>
<Item1 Ref="65" FormatString="{0:dd.MM.yyyy}" PropertyName="Text" DataMember="Устройство.ScheduledCalibrationDate" />
</DataBindings>
<StylePriority Ref="66" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item8>
</Cells>
</Item1>
</Rows>
</Item1>
</Controls>
</Item2>
<Item3 Ref="67" ControlType="TopMarginBand" Name="topMarginBand1" HeightF="100" Dpi="254" />
<Item4 Ref="68" ControlType="BottomMarginBand" Name="bottomMarginBand1" HeightF="84" Dpi="254" />
<Item5 Ref="69" ControlType="GroupHeaderBand" Name="GroupHeader1" HeightF="302.107544" Dpi="254">
<GroupFields>
<Item1 Ref="70" FieldName="groupData" SortOrder="Descending" />
</GroupFields>
<Controls>
<Item1 Ref="71" ControlType="XRTable" Name="tableGroupHeader" SizeF="2620.00024,127.000015" LocationFloat="0, 175.107529" Dpi="254">
<Rows>
<Item1 Ref="72" ControlType="XRTableRow" Name="tableRow3" Weight="2" Dpi="254">
<Cells>
<Item1 Ref="73" ControlType="XRTableCell" Name="tableCell21" Weight="0.2458457602247956" Text="№ п/п" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="All">
<StylePriority Ref="74" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item1>
<Item2 Ref="75" ControlType="XRTableCell" Name="tableCell1" Weight="1.5614460501187888" Text="Объект" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Top, Right, Bottom">
<StylePriority Ref="76" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item2>
<Item3 Ref="77" ControlType="XRTableCell" Name="tableCell23" Weight="1.1645822900486742" Text="Адрес" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Top, Right, Bottom">
<StylePriority Ref="78" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item3>
<Item4 Ref="79" ControlType="XRTableCell" Name="tableCell25" Weight="1.0099930071690142" Text="Обслуживающий" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Top, Right, Bottom">
<StylePriority Ref="80" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item4>
<Item5 Ref="81" ControlType="XRTableCell" Name="tableCell26" Weight="0.77695781887782367" Text="Марка прибора" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Top, Right, Bottom">
<StylePriority Ref="82" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item5>
<Item6 Ref="83" ControlType="XRTableCell" Name="tableCell27" Weight="1.1754368959613615" Text="Заводской номер" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Top, Right, Bottom">
<StylePriority Ref="84" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item6>
<Item7 Ref="85" ControlType="XRTableCell" Name="tableCell28" Weight="0.65155222253795875" Text="Диметр условного прохода, ДУ" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Top, Right, Bottom">
<StylePriority Ref="86" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item7>
<Item8 Ref="87" ControlType="XRTableCell" Name="tableCell29" Weight="0.51936893948127738" Text="Очередная поверка" TextAlignment="MiddleCenter" Dpi="254" Font="Arial, 9.75pt" Borders="Top, Right, Bottom">
<StylePriority Ref="88" UseFont="false" UseBorders="false" UseTextAlignment="false" />
</Item8>
</Cells>
</Item1>
</Rows>
</Item1>
<Item2 Ref="89" ControlType="XRLabel" Name="label7" NullValueText="Не найдены средства измерения со сроком поверки в указанном периоде." TextAlignment="MiddleLeft" SizeF="2605.583,58.4200134" LocationFloat="0, 116.687561" Dpi="254" Font="Arial, 12pt, charSet=204" Padding="10,5,0,0,254" Borders="None">
<DataBindings>
<Item1 Ref="90" PropertyName="Text" DataMember="Устройство.groupTitle" />
</DataBindings>
<StylePriority Ref="91" UseFont="false" UsePadding="false" UseBorders="false" UseTextAlignment="false" />
</Item2>
</Controls>
</Item5>
<Item6 Ref="92" ControlType="ReportFooterBand" Name="ReportFooter" HeightF="111.125" Dpi="254">
<Controls>
<Item1 Ref="93" ControlType="XRLabel" Name="footerText" TextAlignment="MiddleLeft" SizeF="2605.583,58.420002" LocationFloat="0, 51.51753" Dpi="254" Font="Arial, 12pt, charSet=204" Padding="10,5,0,0,254" Borders="None">
<Scripts Ref="94" OnPrintOnPage="footerText_PrintOnPage" />
<StylePriority Ref="95" UseFont="false" UsePadding="false" UseBorders="false" UseTextAlignment="false" />
</Item1>
</Controls>
</Item6>
</Bands>
<Scripts Ref="96" OnDataSourceDemanded="BaseReport_DataSourceDemanded" />
<ExportOptions Ref="97">
<PrintPreview Ref="98" DefaultFileName="Поверка" />
</ExportOptions>
<ObjectStorage>
<Item1 ObjectType="DevExpress.XtraReports.Serialization.ObjectStorageInfo, DevExpress.XtraReports.v16.2" Ref="4" Content="System.DateTime" Type="System.Type" />
<Item2 ObjectType="DevExpress.XtraReports.Serialization.ObjectStorageInfo, DevExpress.XtraReports.v16.2" Ref="7" Content="System.Int32" Type="System.Type" />
<Item3 ObjectType="DevExpress.XtraReports.Serialization.ObjectStorageInfo, DevExpress.XtraReports.v16.2" Ref="0" Content="~Xtra#NULL" Type="Lers.Reports.ReportDataSet" />
</ObjectStorage>
</XtraReportsLayoutSerializer>