sql-server – IE does not display a Reporting Services report correctly

Question:

In IE (11th version), the text in column 5 is displayed incorrectly, or rather, the alignment does not work.

IE Screen

In Report Builder, everything is visually correct, alignment is set by analogy with neighboring cells

Screen RB

What could be the problem?

UPD – screen from Firefox

UPD2: I can't tell you exactly according to the RS version. Installed the one that comes with SQL Server 2008 R2.

Code of this cell + neighbors:

<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 suggest you take it, look at the source code, and download it. If you use asp – no problem. If you don't, 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 that.

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 the report control) and add 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. what to displace the inscription "in place".

Not the best option, but it will give the result. If it doesn't work, you need to call alert or console.log. I piled up report pages when "beauty was demanded" (added the report title in front of the table).

PS It is likely that the answer to the question needs to be wiped out at mіcrosoft or on their forums, perhaps in the new version of ReportServer this problem will be fixed.

UDP: And questions … as a question-and-answer solution:

1) see how the lines are formatted in the rdl / rdlc file. Perhaps the analysis of the xml itself (rdl = xml) will answer the question "why are they different". The rdlc report editor may "not display" the differences. Perhaps some kind of 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 there are two differences in "explore the element" (it seems that there is such a thing in IE11. Perhaps this difference will lead you to think that something is wrong.

3) If you draw a new template from scratch – the problem repeats (like rdl-buggy) or is it solved?

Scroll to Top