Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

Export to excel problem

Hi,

I have a tabular report that has a toggle(collapsible item) in the details area. The toggle works fine in the report designer but when I export it to excel, the toggle is not exported. Are there some properties that I missed configuring?

Thanks!

Do you have other table rows between details and the row with the toggle? If this is the case, we cannot generate the outlines in Excel since Excel requires the rows to be consecutive.

Thank you,

Nico

|||

We had no problem when we use Reporting Services Standard edition. But after we installed Reporting Service SP2, we got the same problem as you. Unfortunately, I don't have solution yet.

Do you have Reporting Services SP2 installed?

Please let me know.

Alison

|||Did you set the visibility of the table to some expression? If so, just set to visible or hidden, then the toggle will be exported in Excel.

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>