Question:
In IE (11th version) the text in column 5 is displayed incorrectly, or rather the alignment does not work.
Everything is visually correct in the Report Builder, the alignment is set up similarly to neighboring cells
What could be the problem?
UPD – screenshot from Firefox
UPD2: According to the RS version, I can’t tell you for sure. The one that comes with SQL Server 2008 R2 is installed.
The code of this cell + neighboring ones:
<TablixCornerCell>
<CellContents>
<Textbox Name="Textbox384">
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>В рабочее время</Value>
<Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox384</rd:DefaultName>
<Style>
<Border>
<Style>Solid</Style>
</Border>
<TopBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</TopBorder>
<BottomBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</BottomBorder>
<LeftBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</LeftBorder>
<RightBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</RightBorder>
<BackgroundColor>CornflowerBlue</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
<WritingMode>Rotate270</WritingMode>
</Style>
</Textbox>
</CellContents>
</TablixCornerCell>
<TablixCornerCell>
<CellContents>
<Textbox Name="Textbox6">
<CanGrow>true</CanGrow>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Звонки, поступившие в очередь</Value>
<Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox6</rd:DefaultName>
<Style>
<Border>
<Style>Solid</Style>
</Border>
<TopBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</TopBorder>
<BottomBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</BottomBorder>
<LeftBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</LeftBorder>
<RightBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</RightBorder>
<BackgroundColor>CornflowerBlue</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
<WritingMode>Rotate270</WritingMode>
</Style>
</Textbox>
<rd:Selected>true</rd:Selected>
</CellContents>
</TablixCornerCell>
<TablixCornerCell>
<CellContents>
<Textbox Name="Textbox420">
<CanShrink>true</CanShrink>
<KeepTogether>true</KeepTogether>
<Paragraphs>
<Paragraph>
<TextRuns>
<TextRun>
<Value>Вне часов работы</Value>
<Style>
<FontSize>8pt</FontSize>
<FontWeight>Bold</FontWeight>
</Style>
</TextRun>
</TextRuns>
<Style>
<TextAlign>Left</TextAlign>
</Style>
</Paragraph>
</Paragraphs>
<rd:DefaultName>Textbox420</rd:DefaultName>
<Style>
<Border>
<Style>Solid</Style>
</Border>
<TopBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</TopBorder>
<BottomBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</BottomBorder>
<LeftBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</LeftBorder>
<RightBorder>
<Color>Black</Color>
<Style>Solid</Style>
<Width>1pt</Width>
</RightBorder>
<BackgroundColor>CornflowerBlue</BackgroundColor>
<VerticalAlign>Middle</VerticalAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<PaddingBottom>2pt</PaddingBottom>
<WritingMode>Rotate270</WritingMode>
</Style>
</Textbox>
</CellContents>
Answer:
I propose to take, look at the source code, and patch it. If you use asp – no problem. If not, then aspx is here c:\program files\Microsoft SQL server\MSSQL.4\Reporting Services\ReportServer\Pages\ReportView.aspx I have 4, you may have a different number. The path may be slightly different, but somewhere like this.
Let's see what the report server generated
<table id="ReportViewerControl" cellpadding="0" cellspacing="0">
<tr style="HEIGHT:27.50mm">
<td class="a34 r5 r7 r8"><div class="r11">Cтолбец 1</div></td>
<td class="a35 r7 r8"><div class="r11">Столбец 2</div></td>
Accordingly, there are two options. JS, CSS, JS+CSS
I'll show you a variant with JS
We take our ReportView.aspx (or your aspx with a report control) and finish it
...<html>
<RS:ReportViewrHost ID="..." >
</form>
// Cуда вставим наш код
<script type="text/javascript" >
if (условие_на_иe11)
// Для всех отчётов используется один файл, отличить отчёты можно по location вверху браузера.
//ReportViewer.aspx?%2fProject%2fMyReport1 у меня такой
if (location.href.IndexOf("?Название-Отчета-С-Папкой") > 0 ) {
// Патчим
var tab = document.getElementById("ReportViewerControl");
var row = tab.rows[0];
var elm = row.firstChild;
elm = elm.nextSibling;
elm = elm.nextSibling;
elm.style = "Стиль";
}
</script>
You need to add margin padding, etc. to the style. that shift the inscription "in place".
Not the best option, but the result will give. If it doesn't work, you need to call alert or console.log. I patched the report pages when "beauty was demanded" (added the title of the report before the table).
PS It is likely that the answer to the question needs to be obtained from microsoft or on their forums, perhaps this problem will be fixed in the new version of ReportServer.
UDP: And questions… as a solution question:
1) see how the lines in the rdl/rdlc file are formatted. Perhaps the analysis of the xml itself (rdl=xml) will answer the question "why different". The rdlc report editor may not "display" differences. Perhaps some xml-attribute is superfluous. Compare two branches for two columns of the form <Textbox Name="textbox19"> .
2) the table is shown, but its html-code is not shown, but rather two differences in "explore the element" (it seems that this already exists in IE11. Perhaps this difference will suggest what is wrong.
3) If you draw a new template from scratch – does the problem repeat itself (like rdl-buggy) or is it solved?