Reporting Services does not display table data in the preview

I put a table in my report with labels in the first column and mappings in the second column, but when I click on preview (in the IDE) the table is not displayed.

Initial Visibility is set to Visible.

I am using VS 2005 Team Explorer Edition (which is open from Sql Server 2005 BI)

Here's a sample XML (code) if it might help.

         <TableRow>
          <TableCells>
            <TableCell>
              <ReportItems>
                <Textbox Name="labelRID">
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>12pt</FontSize>
                    <TextAlign>Right</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <ZIndex>7</ZIndex>
                  <CanGrow>true</CanGrow>
                  <Value>RID:</Value>
                </Textbox>
              </ReportItems>
            </TableCell>
            <TableCell>
              <ReportItems>
                <Textbox Name="textboxRID">
                  <Style>
                    <FontFamily>Times New Roman</FontFamily>
                    <FontSize>12pt</FontSize>
                    <TextAlign>Left</TextAlign>
                    <PaddingLeft>2pt</PaddingLeft>
                    <PaddingRight>2pt</PaddingRight>
                    <PaddingTop>2pt</PaddingTop>
                    <PaddingBottom>2pt</PaddingBottom>
                  </Style>
                  <ZIndex>6</ZIndex>
                  <CanGrow>true</CanGrow>
                  <Value>=Fields!rid.Value</Value>
                </Textbox>
              </ReportItems>
            </TableCell>
          </TableCells>
          <Height>0.25in</Height>
        </TableRow>

      

0


source to share


1 answer


Thanks to the Microsoft forum my problem was here.

"Select the table and press" F4 ", there you will see the" Data "tab where you have the property" No rows ", you can print the text if there is no data returned from the dataset. Example" No data ".



So basically, since I have no data at this point (the client hasn't provided it yet), my table with labels won't show.

+1


source







All Articles