Hi all
When I export my reports to excel, all cells are set to "General" number
style.
Users wanted to show numbers as "Number", but I didn't found the way to set
the cell output style.
Any idea?
Thanks in advance.On Aug 20, 12:57 pm, "David Rodr=EDguez Rinc=F3n" <d_rin...@.hotmail.com>
wrote:
> Hi all
> When I export my reports to excel, all cells are set to "General" number
> style.
> Users wanted to show numbers as "Number", but I didn't found the way to s=et
> the cell output style.
> Any idea?
> Thanks in advance.
Depending on your needs, you may be able to set the field's format
based on what the numbering format needs to be. Maybe something like
one of the following as an expression in the Format property (select
the control -> select the View drop-down list -> Properties Window ->
to the right of Format, select <Expression...>)
#,0
-or-
#,0.00
etc
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique.
First of all, thank you very much for your quick answer
My issue is not related woth the format in the Report Viewer. I can show
data using the correct format.
The problem is in the excel file exported by MS RS, when all the cells are
set as "General" (right click on cell >> Format Cell >> Number Category)
Our users want to set numbers to "Number" category, to be able to apply
formulas to validate data.
I tried your approach, and it works in the Report Viewer, but unfortunatelly
the excel file is exported with no specific cell format :(
Any other suggestion?
Thanks again.
David Rodríguez
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1187661848.228911.233150@.50g2000hsm.googlegroups.com...
On Aug 20, 12:57 pm, "David Rodríguez Rincón" <d_rin...@.hotmail.com>
wrote:
> Hi all
> When I export my reports to excel, all cells are set to "General" number
> style.
> Users wanted to show numbers as "Number", but I didn't found the way to
> set
> the cell output style.
> Any idea?
> Thanks in advance.
Depending on your needs, you may be able to set the field's format
based on what the numbering format needs to be. Maybe something like
one of the following as an expression in the Format property (select
the control -> select the View drop-down list -> Properties Window ->
to the right of Format, select <Expression...>)
#,0
-or-
#,0.00
etc
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi again!
Enrique, your solution works.
My problem was that if you format the value in the .Value expresion, using
funtions like FormatNumber or FormatPercentage, the format entered in the
.Format expresion is not taked into account.
If I only show the Value in the textbox, and use the .Format property using
the MS Excel custom styles[ ="#,##0;(#,##0)"] it works!!!!!
Thanks you very much!!
Regards.
David Rodríguez Rincón
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1187661848.228911.233150@.50g2000hsm.googlegroups.com...
On Aug 20, 12:57 pm, "David Rodríguez Rincón" <d_rin...@.hotmail.com>
wrote:
> Hi all
> When I export my reports to excel, all cells are set to "General" number
> style.
> Users wanted to show numbers as "Number", but I didn't found the way to
> set
> the cell output style.
> Any idea?
> Thanks in advance.
Depending on your needs, you may be able to set the field's format
based on what the numbering format needs to be. Maybe something like
one of the following as an expression in the Format property (select
the control -> select the View drop-down list -> Properties Window ->
to the right of Format, select <Expression...>)
#,0
-or-
#,0.00
etc
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 22, 1:11 pm, "David Rodr=EDguez Rinc=F3n" <d_rin...@.hotmail.com>
wrote:
> Hi again!
> Enrique, your solution works.
> My problem was that if you format the value in the .Value expresion, using
> funtions like FormatNumber or FormatPercentage, the format entered in the
> .Format expresion is not taked into account.
> If I only show the Value in the textbox, and use the .Format property usi=ng
> the MS Excel custom styles[ =3D"#,##0;(#,##0)"] it works!!!!!
> Thanks you very much!!
> Regards.
> David Rodr=EDguez Rinc=F3n
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1187661848.228911.233150@.50g2000hsm.googlegroups.com...
> On Aug 20, 12:57 pm, "David Rodr=EDguez Rinc=F3n" <d_rin...@.hotmail.com>
> wrote:
> > Hi all
> > When I export my reports to excel, all cells are set to "General" number
> > style.
> > Users wanted to show numbers as "Number", but I didn't found the way to
> > set
> > the cell output style.
> > Any idea?
> > Thanks in advance.
> Depending on your needs, you may be able to set the field's format
> based on what the numbering format needs to be. Maybe something like
> one of the following as an expression in the Format property (select
> the control -> select the View drop-down list -> Properties Window ->
> to the right of Format, select <Expression...>)
> #,0
> -or-
> #,0.00
> etc
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
You're welcome. Glad I could be of assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi again!
Enrique, your solution works.
My problem was that if you format the value in the .Value expresion, using
funtions like FormatNumber or FormatPercentage, the format entered in the
.Format expresion is not taked into account.
If I only show the Value in the textbox, and use the .Format property using
the MS Excel custom styles[ ="#,##0;(#,##0)"] it works!!!!!
Thanks you very much!!
Regards.
David Rodríguez Rincón
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1187661848.228911.233150@.50g2000hsm.googlegroups.com...
On Aug 20, 12:57 pm, "David Rodríguez Rincón" <d_rin...@.hotmail.com>
wrote:
> Hi all
> When I export my reports to excel, all cells are set to "General" number
> style.
> Users wanted to show numbers as "Number", but I didn't found the way to
> set
> the cell output style.
> Any idea?
> Thanks in advance.
Depending on your needs, you may be able to set the field's format
based on what the numbering format needs to be. Maybe something like
one of the following as an expression in the Format property (select
the control -> select the View drop-down list -> Properties Window ->
to the right of Format, select <Expression...>)
#,0
-or-
#,0.00
etc
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant
Showing posts with label style. Show all posts
Showing posts with label style. Show all posts
Wednesday, March 7, 2012
Friday, February 24, 2012
Export to Excel
Hi!
When i export my reports with tables to Excel cells border style get changed for unpredictable reason. Some cells keep style i set in designer, some don't.
Is there a reason for that\ way to fix this?The border styles available in Report Designer don't map 100% to the styles available in Excel. Does a simple style like Solid get preserved in your Excel renderings? Are the changes in style consistent for a given style, or do certain styles only get dropped/changed sporadically?|||Mike, thank for interest in my problem!
The situation is: I needed to show border for columns only, which means that i set Solid border value to the Left and Right property of BorderStyle attribute of the textbox with data.
ReportViewer renders it just fine, but when i export this report to Excel document - cells in far right, left and bottom columns are bordered all around.
I hope this picture will help you understand what the problem is: http://g00vm-blablabla.narod.ru/ExportExample.PNG
Just to notice:
All border styles are the same for all cells
This is a table - not a matrix.|||
OK, I see what the problem is. It seems like a bug. What version of Report Server are you seeing this on? RS2000 or RS2005? Which service pack?
I'll try to put together an independent repro, but in the meantime if you could send me an RDL file, that might speed up the investigation.
|||I made up a simple report that mimics what I saw in your .PNG, but I don't see the bad behavior. I'm using RS 2005 SP2. What version of RS are you seeing the problem on?|||I do use RS 2005 with no service pack installed.
I'll try to find and put somewhere the .rdl file for you.
Also i experience different problem with Reporting Service when i user temporary tables( #tmpTable ) in a stored procedure. This problem also affects report designer.
Should i post it here or start another thread?
|||Hi! I've found the rdl file!
Please, note, that report is using Russian symbols - so you might need to delete\convert them before you will be able to run this report.
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataSource">
<DataSourceReference>DataSource</DataSourceReference>
<rd:DataSourceID>a21b9a26-aec2-4076-b70b-043189a3608f</rd:DataSourceID>
</DataSource>
</DataSources>
<BottomMargin>1.5cm</BottomMargin>
<RightMargin>1.5cm</RightMargin>
<PageWidth>21cm</PageWidth>
<ReportParameters>
<ReportParameter Name="StartDate">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>01.01.2000</Value>
</Values>
</DefaultValue>
<Prompt>Begin of period </Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<DefaultValue>
<Values>
<Value>01.01.2050</Value>
</Values>
</DefaultValue>
<Prompt>End of period </Prompt>
</ReportParameter>
<ReportParameter Name="Author">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Anonymous</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Report Author </Prompt>
</ReportParameter>
<ReportParameter Name="Units">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>1</Value>
</Values>
</DefaultValue>
<Prompt>Mesure</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>1</Value>
<Label>Minutes</Label>
</ParameterValue>
<ParameterValue>
<Value>2</Value>
<Label>Seconds</Label>
</ParameterValue>
<ParameterValue>
<Value>3</Value>
<Label>Rounded Minutes</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="MinValue">
<DataType>Integer</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<Prompt>Filter field( < )</Prompt>
</ReportParameter>
<ReportParameter Name="IncludeKnown">
<DataType>Boolean</DataType>
<DefaultValue>
<Values>
<Value>True</Value>
</Values>
</DefaultValue>
<Prompt>Include known</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>True</Value>
<Label>Include</Label>
</ParameterValue>
<ParameterValue>
<Value>False</Value>
<Label>Dont include</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ShowName">
<DataType>Boolean</DataType>
<DefaultValue>
<Values>
<Value>True</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Show Field 1</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>True</Value>
<Label>Yes</Label>
</ParameterValue>
<ParameterValue>
<Value>False</Value>
<Label>No</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ShowContractDate">
<DataType>Boolean</DataType>
<DefaultValue>
<Values>
<Value>False</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Show contract date</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>True</Value>
<Label>Yes</Label>
</ParameterValue>
<ParameterValue>
<Value>False</Value>
<Label>No</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ShowAddress">
<DataType>Boolean</DataType>
<DefaultValue>
<Values>
<Value>False</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Show address</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>True</Value>
<Label>Yes</Label>
</ParameterValue>
<ParameterValue>
<Value>False</Value>
<Label>No</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="ShowDevice">
<DataType>Boolean</DataType>
<DefaultValue>
<Values>
<Value>False</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Show equipment</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Value>True</Value>
<Label>Yes</Label>
</ParameterValue>
<ParameterValue>
<Value>False</Value>
<Label>No</Label>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>8.5in</InteractiveWidth>
<rd:GridSpacing>0.25cm</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ColumnSpacing>1cm</ColumnSpacing>
<ReportItems>
<Textbox Name="Count">
<RepeatWith>table1</RepeatWith>
<DataElementOutput>NoOutput</DataElementOutput>
<rd:DefaultName>Count</rd:DefaultName>
<ZIndex>1</ZIndex>
<Width>16.75cm</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.75cm</Height>
<Value>= "Total found:" + CStr(CountRows())</Value>
</Textbox>
<Table Name="table1">
<NoRows>= " "</NoRows>
<DataSetName>database</DataSetName>
<Top>0.75cm</Top>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox26">
<rd:DefaultName>textbox26</rd:DefaultName>
<ZIndex>14</ZIndex>
<Action>
<Hyperlink>= var w = window.open('" + Globals!ReportServerUrl +
"/Pages/ReportViewer.aspx?" + Left(CStr(Globals!ReportFolder),InStr(2,CStr(Globals!ReportFolder),"/")) +
"SignaturesReports%2fAbonentStructure" +
"&rs:Command=Render" +
"&rs:Toolbar=True" +
"&rc:Parameters=False" +
"&StartDate=" + CDate(Parameters!StartDate.Value).ToString("s") +
"&EndDate=" + CDate(Parameters!EndDate.Value).ToString("s") +
"&AbonentNumber=" + Replace(Fields!ABONENT_NUMBER.Value, " ", "") +
"&Author=" + Parameters!Author.Value +
"&Fio=" + CStr(Parameters!ShowName.Value) +
"&Address=" + CStr(Parameters!ShowAddress.Value) +
"&ContractDate=" + CStr(Parameters!ShowContractDate.Value) +
"&DeviceType=" + CStr(Parameters!ShowDevice.Value) +
"&TrafficUnit=" + Cstr(Parameters!Units.Value) +
"'," +
"' Window Title'," +
"'toolbar=false,location=false,directories=false,status=false,menubar=false,scrollbars=true,resizable=true');"</Hyperlink>
</Action>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<Color>SteelBlue</Color>
<TextDecoration>Underline</TextDecoration>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!ABONENT_NUMBER.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox29">
<rd:DefaultName>textbox29</rd:DefaultName>
<ZIndex>13</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!ABONENT_NAME.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox10">
<rd:DefaultName>textbox10</rd:DefaultName>
<ZIndex>12</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!ABONENT_ADDRESS.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox32">
<rd:DefaultName>textbox32</rd:DefaultName>
<ZIndex>11</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=CDate(Fields!ABONENT_CONTRACT_DATE.Value).ToString("dd.MM.yyyy")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox5">
<rd:DefaultName>textbox5</rd:DefaultName>
<ZIndex>10</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!ABONENT_DEVICE.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Organization">
<rd:DefaultName>Organization</rd:DefaultName>
<ZIndex>9</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!ORGANIZATION_NAME.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox35">
<rd:DefaultName>textbox35</rd:DefaultName>
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!ABONENT_TYPE.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox41">
<rd:DefaultName>textbox41</rd:DefaultName>
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!SERVICE_TYPE.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox38">
<rd:DefaultName>textbox38</rd:DefaultName>
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!SERVICE_NAME.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="INNER_CALLS_COUNT">
<rd:DefaultName>INNER_CALLS_COUNT</rd:DefaultName>
<ZIndex>5</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!INNER_CALLS_COUNT.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Inner_Seconds">
<rd:DefaultName>Inner_Seconds</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!INNER_TRAFFIC.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Inner_TarifMin">
<rd:DefaultName>Inner_TarifMin</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>= FormatNumber(Fields!INNER_AVERAGE_DURATION.Value, 0)</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="OUTER_CALLS_COUNT">
<rd:DefaultName>OUTER_CALLS_COUNT</rd:DefaultName>
<ZIndex>2</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!OUTER_CALLS_COUNT.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Outer_Seconds">
<rd:DefaultName>Outer_Seconds</rd:DefaultName>
<ZIndex>1</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!OUTER_TRAFFIC.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Outer_TarifMin">
<rd:DefaultName>Outer_TarifMin</rd:DefaultName>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<BackgroundColor>=IIf((RowNumber(Nothing) Mod 2) = 0,"#ECE9D8","White")</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>= FormatNumber(Fields!OUTER_AVERAGE_DURATION.Value, 0)</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.75cm</Height>
</TableRow>
</TableRows>
</Details>
<Style>
<BorderStyle>
<Default>=Iif(CountRows()=0, "None", "Solid")</Default>
</BorderStyle>
</Style>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox24">
<rd:DefaultName>textbox24</rd:DefaultName>
<ZIndex>29</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!ABONENT_NUMBER.Value</SortExpression>
</UserSort>
<Value>????а ??-?-в </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox28">
<rd:DefaultName>textbox28</rd:DefaultName>
<ZIndex>28</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!ABONENT_NAME.Value</SortExpression>
</UserSort>
<Value>”€? Ё?Ё - §? -Ё? ?а? -Ё§ жЁЁ ??-?-в </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox7">
<rd:DefaultName>textbox7</rd:DefaultName>
<ZIndex>27</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!ABONENT_ADDRESS.Value</SortExpression>
</UserSort>
<Value>?¤а?б ??-?-в </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox34">
<ZIndex>26</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!ABONENT_CONTRACT_DATE.Value</SortExpression>
</UserSort>
<Value>? в § ??оз?-Ёп ¤?????а </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>25</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!ABONENT_DEVICE.Value</SortExpression>
</UserSort>
<Value>’Ё? ???аг¤?? -Ёп ??-?-в </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox2">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>24</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!ORGANIZATION_NAME.Value</SortExpression>
</UserSort>
<Value>?а? -Ё§ жЁп</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox31">
<rd:DefaultName>textbox31</rd:DefaultName>
<ZIndex>23</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!ABONENT_TYPE.Value</SortExpression>
</UserSort>
<Value>’Ё? ??-?-в </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox57">
<rd:DefaultName>textbox57</rd:DefaultName>
<ZIndex>22</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!SERVICE_TYPE.Value</SortExpression>
</UserSort>
<Value>’Ё? б?г|?л</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox37">
<rd:DefaultName>textbox37</rd:DefaultName>
<ZIndex>21</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!SERVICE_NAME.Value</SortExpression>
</UserSort>
<Value>??Ёб -Ё? б?г|?л</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<ZIndex>20</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!INNER_CALLS_COUNT.Value</SortExpression>
</UserSort>
<Value>???Ёз?бв?? ?е?¤пйЁе ?л§????</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox20">
<rd:DefaultName>textbox20</rd:DefaultName>
<ZIndex>19</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!INNER_TRAFFIC.Value</SortExpression>
</UserSort>
<Value>??к?? ?е?¤пй??? ва дЁ? </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox23">
<rd:DefaultName>textbox23</rd:DefaultName>
<ZIndex>18</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!INNER_AVERAGE_DURATION.Value</SortExpression>
</UserSort>
<Value>‘а?¤-пп ?а?¤??|Ёв??м-?бвм ?е?¤пйЁе ?л§????</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox17">
<rd:DefaultName>textbox17</rd:DefaultName>
<ZIndex>17</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!OUTER_CALLS_COUNT.Value</SortExpression>
</UserSort>
<Value>???Ёз?бв?? Ёбе?¤пйЁе ?л§????</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox14">
<rd:DefaultName>textbox14</rd:DefaultName>
<ZIndex>16</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!OUTER_TRAFFIC.Value</SortExpression>
</UserSort>
<Value>??к?? Ёбе?¤пй??? ва дЁ? </Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox11">
<rd:DefaultName>textbox11</rd:DefaultName>
<ZIndex>15</ZIndex>
<Style>
<BorderStyle>
<Left>Solid</Left>
<Right>Solid</Right>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<BackgroundColor>Gainsboro</BackgroundColor>
<PaddingRight>2pt</PaddingRight>
<FontStyle>Italic</FontStyle>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!OUTER_AVERAGE_DURATION.Value</SortExpression>
</UserSort>
<Value>‘а?¤-пп ?а?¤??|Ёв??м-?бвм Ёбе?¤пйЁе ?л§????</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.75cm</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
<FixedHeader>true</FixedHeader>
</Header>
<TableColumns>
<TableColumn>
<Width>3.5cm</Width>
</TableColumn>
<TableColumn>
<Width>3.75cm</Width>
<Visibility>
<Hidden>= Not(Parameters!ShowName.Value)</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>3cm</Width>
<Visibility>
<Hidden>= Not(Parameters!ShowAddress.Value)</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>3.5cm</Width>
<Visibility>
<Hidden>= Not(Parameters!ShowContractDate.Value)</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>3.77646cm</Width>
<Visibility>
<Hidden>= Not(Parameters!ShowDevice.Value)</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>5.52645cm</Width>
</TableColumn>
<TableColumn>
<Width>3.02645cm</Width>
</TableColumn>
<TableColumn>
<Width>3.02645cm</Width>
</TableColumn>
<TableColumn>
<Width>3cm</Width>
</TableColumn>
<TableColumn>
<Width>3.5cm</Width>
</TableColumn>
<TableColumn>
<Width>3.5cm</Width>
</TableColumn>
<TableColumn>
<Width>3.5cm</Width>
</TableColumn>
<TableColumn>
<Width>3.5cm</Width>
</TableColumn>
<TableColumn>
<Width>3.5cm</Width>
</TableColumn>
<TableColumn>
<Width>3.5cm</Width>
</TableColumn>
</TableColumns>
</Table>
</ReportItems>
<Height>2.25cm</Height>
</Body>
<PageHeader>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<ZIndex>4</ZIndex>
<Width>16.75cm</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontWeight>700</FontWeight>
<FontSize>20pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>1.75cm</Height>
<Value>? б?а?¤???-Ё? ???Ёз?бв? ?л§???? Ё ??к???? ?е?¤пй??? ва дЁ? </Value>
</Textbox>
<Textbox Name="textbox43">
<Top>1.75cm</Top>
<ZIndex>3</ZIndex>
<Width>16.75cm</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.75cm</Height>
<Value>= "? ??аЁ?¤ б " + CDate(Parameters!StartDate.Value).ToString("dd.MM.yyyy") +
" ?? " + CDate(Parameters!EndDate.Value).ToString("dd.MM.yyyy") + "."</Value>
</Textbox>
<Textbox Name="textbox15">
<Top>2.5cm</Top>
<ZIndex>2</ZIndex>
<Width>16.75cm</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.75cm</Height>
<Value>= "…¤Ё-Ёж Ё§??а?-Ёп ??к?? ва дЁ? : " + Parameters!Units.Label + "."</Value>
</Textbox>
<Textbox Name="textbox12">
<Top>3.25cm</Top>
<ZIndex>1</ZIndex>
<Width>16.75cm</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.75cm</Height>
<Value>= "‘?§¤ -: " + CDate(Now).ToString("dd.MM.yyyy HH:mm:ss") + "."</Value>
</Textbox>
<Textbox Name="textbox18">
<Top>4cm</Top>
<Width>16.75cm</Width>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>= "??в?а: " + Parameters!Author.Value + "."</Value>
</Textbox>
</ReportItems>
<Height>4.75cm</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageHeader>
<rd:ReportID>be9941b9-2bd0-449d-8fd9-d67c36889500</rd:ReportID>
<LeftMargin>2.5cm</LeftMargin>
<DataSets>
<DataSet Name="database">
<Query>
<CommandType>StoredProcedure</CommandType>
<CommandText>AD_Report_TrafficByGatewayFiltered</CommandText>
<QueryParameters>
<QueryParameter Name="@.startDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@.endDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@.units">
<Value>=Parameters!Units.Value</Value>
</QueryParameter>
<QueryParameter Name="@.minValue">
<Value>=Parameters!MinValue.Value</Value>
</QueryParameter>
<QueryParameter Name="@.getKnown">
<Value>=Parameters!IncludeKnown.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataSource</DataSourceName>
</Query>
<Fields>
<Field Name="ORGANIZATION_ID">
<rd:TypeName>System.Int16</rd:TypeName>
<DataField>ORGANIZATION_ID</DataField>
</Field>
<Field Name="ORGANIZATION_NAME">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ORGANIZATION_NAME</DataField>
</Field>
<Field Name="ABONENT_NUMBER">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ABONENT_NUMBER</DataField>
</Field>
<Field Name="ABONENT_NAME">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ABONENT_NAME</DataField>
</Field>
<Field Name="ABONENT_ADDRESS">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ABONENT_ADDRESS</DataField>
</Field>
<Field Name="ABONENT_DEVICE">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ABONENT_DEVICE</DataField>
</Field>
<Field Name="ABONENT_CONTRACT_DATE">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>ABONENT_CONTRACT_DATE</DataField>
</Field>
<Field Name="ABONENT_TYPE">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ABONENT_TYPE</DataField>
</Field>
<Field Name="SERVICE_TYPE">
<rd:TypeName>System.String</rd:TypeName>
<DataField>SERVICE_TYPE</DataField>
</Field>
<Field Name="SERVICE_NAME">
<rd:TypeName>System.String</rd:TypeName>
<DataField>SERVICE_NAME</DataField>
</Field>
<Field Name="INNER_CALLS_COUNT">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>INNER_CALLS_COUNT</DataField>
</Field>
<Field Name="INNER_TRAFFIC">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>INNER_TRAFFIC</DataField>
</Field>
<Field Name="INNER_AVERAGE_DURATION">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>INNER_AVERAGE_DURATION</DataField>
</Field>
<Field Name="OUTER_CALLS_COUNT">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>OUTER_CALLS_COUNT</DataField>
</Field>
<Field Name="OUTER_TRAFFIC">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>OUTER_TRAFFIC</DataField>
</Field>
<Field Name="OUTER_AVERAGE_DURATION">
<rd:TypeName>System.Decimal</rd:TypeName>
<DataField>OUTER_AVERAGE_DURATION</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Code />
<Width>53.10581cm</Width>
<InteractiveHeight>11in</InteractiveHeight>
<Language>ru-RU</Language>
<PageFooter>
<ReportItems>
<Textbox Name="tbxPF_Paging">
<Width>16.75cm</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>="Page "+CStr(Globals!PageNumber)+" / "+CStr(Globals!TotalPages)</Value>
</Textbox>
</ReportItems>
<Height>0.63492cm</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>1.5cm</TopMargin>
<PageHeight>29.7cm</PageHeight>
</Report>
Subscribe to:
Posts (Atom)