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" +

"&amp;rs:Command=Render" +

"&amp;rs:Toolbar=True" +

"&amp;rc:Parameters=False" +

"&amp;StartDate=" + CDate(Parameters!StartDate.Value).ToString("s") +

"&amp;EndDate=" + CDate(Parameters!EndDate.Value).ToString("s") +

"&amp;AbonentNumber=" + Replace(Fields!ABONENT_NUMBER.Value, " ", "") +

"&amp;Author=" + Parameters!Author.Value +

"&amp;Fio=" + CStr(Parameters!ShowName.Value) +

"&amp;Address=" + CStr(Parameters!ShowAddress.Value) +

"&amp;ContractDate=" + CStr(Parameters!ShowContractDate.Value) +

"&amp;DeviceType=" + CStr(Parameters!ShowDevice.Value) +

"&amp;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>