title: What is the reason of getting empty report with jdbc datasource?
body: <p>I am using <code>iReport  4.7.0</code>. To get report in table format I am connecting to <em><code>SQL Server 2005</code></em>.  </p>
  
  <p>I am creating a dataset while designing a table that gives me a field values which are in database table but after complete design while I am previewing my <em><code>jrxml</code></em> file it doesn't show me a table with values. </p>
  
  <p>I want to know what is the problem.</p>
  
  <p>My <em><code>jrxml</code></em> file:</p>
  
  <pre class="lang-xml prettyprint-override"><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Test" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="09817b9b-055f-4d9f-b22e-85b7fac3d81e" whenNoDataType="AllSectionsNoDetail"&gt;
      &lt;property name="ireport.zoom" value="1.0"/&gt;
      &lt;property name="ireport.x" value="0"/&gt;
      &lt;property name="ireport.y" value="35"/&gt;
      &lt;style name="table"&gt;
          &lt;box&gt;
              &lt;pen lineWidth="1.0" lineColor="#000000"/&gt;
          &lt;/box&gt;
      &lt;/style&gt;
      &lt;style name="table_TH" mode="Opaque" backcolor="#F0F8FF"&gt;
          &lt;box&gt;
              &lt;pen lineWidth="0.5" lineColor="#000000"/&gt;
          &lt;/box&gt;
      &lt;/style&gt;
      &lt;style name="table_CH" mode="Opaque" backcolor="#BFE1FF"&gt;
          &lt;box&gt;
              &lt;pen lineWidth="0.5" lineColor="#000000"/&gt;
          &lt;/box&gt;
      &lt;/style&gt;
      &lt;style name="table_TD" mode="Opaque" backcolor="#FFFFFF"&gt;
          &lt;box&gt;
              &lt;pen lineWidth="0.5" lineColor="#000000"/&gt;
          &lt;/box&gt;
          &lt;conditionalStyle&gt;
              &lt;conditionExpression&gt;&lt;![CDATA[new Boolean($V{REPORT_COUNT}.intValue()%2==0)]]&gt;&lt;/conditionExpression&gt;
              &lt;style backcolor="#EFF7FF"/&gt;
          &lt;/conditionalStyle&gt;
      &lt;/style&gt;
      &lt;subDataset name="New Dataset 1" uuid="9bfe7683-aa43-4113-b4a6-8007d4c7ff5d"&gt;
          &lt;queryString language="SQL"&gt;
              &lt;![CDATA[select * from employee]]&gt;
          &lt;/queryString&gt;
          &lt;field name="id" class="java.lang.Integer"/&gt;
          &lt;field name="first_name" class="java.lang.String"/&gt;
          &lt;field name="last_name" class="java.lang.String"/&gt;
          &lt;field name="salary" class="java.lang.Integer"/&gt;
          &lt;group name="id"&gt;
              &lt;groupExpression&gt;&lt;![CDATA[$F{id}]]&gt;&lt;/groupExpression&gt;
          &lt;/group&gt;
          &lt;group name="first_name"&gt;
              &lt;groupExpression&gt;&lt;![CDATA[$F{first_name}]]&gt;&lt;/groupExpression&gt;
          &lt;/group&gt;
          &lt;group name="last_name"&gt;
              &lt;groupExpression&gt;&lt;![CDATA[$F{last_name}]]&gt;&lt;/groupExpression&gt;
          &lt;/group&gt;
      &lt;/subDataset&gt;
      &lt;queryString&gt;
          &lt;![CDATA[]]&gt;
      &lt;/queryString&gt;
      &lt;background&gt;
          &lt;band splitType="Stretch"/&gt;
      &lt;/background&gt;
      &lt;title&gt;
          &lt;band height="79" splitType="Stretch"&gt;
              &lt;staticText&gt;
                  &lt;reportElement uuid="3f6a40c5-cb7c-4237-8635-19aab55cef63" x="205" y="16" width="100" height="20"/&gt;
                  &lt;textElement&gt;
                      &lt;font size="14" isBold="true"/&gt;
                  &lt;/textElement&gt;
                  &lt;text&gt;&lt;![CDATA[Test Database]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
          &lt;/band&gt;
      &lt;/title&gt;
      &lt;pageHeader&gt;
          &lt;band height="35" splitType="Stretch"/&gt;
      &lt;/pageHeader&gt;
      &lt;detail&gt;
          &lt;band height="125" splitType="Stretch"&gt;
              &lt;componentElement&gt;
                  &lt;reportElement uuid="6dc5bcfb-b281-4ec4-a611-4e5b602031ed" key="table" style="table" x="16" y="10" width="527" height="115"/&gt;
                  &lt;jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"&gt;
                      &lt;datasetRun subDataset="New Dataset 1" uuid="ba8de9b8-6e5b-4178-a62d-380ec6e268c2"&gt;
                          &lt;connectionExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/connectionExpression&gt;
                      &lt;/datasetRun&gt;
                      &lt;jr:column uuid="8a09f431-ce9d-4c86-bde8-b6eba830a10f" width="90"&gt;
                          &lt;jr:columnHeader style="table_CH" height="30" rowSpan="1"&gt;
                              &lt;staticText&gt;
                                  &lt;reportElement uuid="05cb64bd-b18c-4323-9365-ed6fa5d763ae" x="0" y="0" width="90" height="30"/&gt;
                                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                                      &lt;font size="12" isBold="true"/&gt;
                                  &lt;/textElement&gt;
                                  &lt;text&gt;&lt;![CDATA[id]]&gt;&lt;/text&gt;
                              &lt;/staticText&gt;
                          &lt;/jr:columnHeader&gt;
                          &lt;jr:columnFooter style="table_CH" height="31" rowSpan="1"/&gt;
                          &lt;jr:detailCell style="table_TD" height="20" rowSpan="1"&gt;
                              &lt;textField&gt;
                                  &lt;reportElement uuid="2fb15323-2f8b-4234-ae0b-7272676180df" x="0" y="0" width="90" height="20"/&gt;
                                  &lt;textElement textAlignment="Center"/&gt;
                                  &lt;textFieldExpression&gt;&lt;![CDATA[$F{id}]]&gt;&lt;/textFieldExpression&gt;
                              &lt;/textField&gt;
                          &lt;/jr:detailCell&gt;
                      &lt;/jr:column&gt;
                      &lt;jr:column uuid="db3eb7e3-b13d-4dff-b4cf-c64aa06853f2" width="90"&gt;
                          &lt;jr:columnHeader style="table_CH" height="30" rowSpan="1"&gt;
                              &lt;staticText&gt;
                                  &lt;reportElement uuid="d60ed209-0e4f-4e66-8a4b-53a117a4fdf2" x="0" y="0" width="90" height="30"/&gt;
                                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                                      &lt;font size="12" isBold="true"/&gt;
                                  &lt;/textElement&gt;
                                  &lt;text&gt;&lt;![CDATA[first_name]]&gt;&lt;/text&gt;
                              &lt;/staticText&gt;
                          &lt;/jr:columnHeader&gt;
                          &lt;jr:columnFooter style="table_CH" height="31" rowSpan="1"/&gt;
                          &lt;jr:detailCell style="table_TD" height="20" rowSpan="1"&gt;
                              &lt;textField&gt;
                                  &lt;reportElement uuid="4dc05d21-5b86-4da2-b64f-9f83666e1948" x="0" y="0" width="90" height="20"/&gt;
                                  &lt;textElement textAlignment="Center"/&gt;
                                  &lt;textFieldExpression&gt;&lt;![CDATA[$F{first_name}]]&gt;&lt;/textFieldExpression&gt;
                              &lt;/textField&gt;
                          &lt;/jr:detailCell&gt;
                      &lt;/jr:column&gt;
                      &lt;jr:column uuid="1bdd10f7-b718-4fbc-9fca-9f0a7883dc5c" width="90"&gt;
                          &lt;jr:columnHeader style="table_CH" height="30" rowSpan="1"&gt;
                              &lt;staticText&gt;
                                  &lt;reportElement uuid="2bdbbd7d-f990-4261-9243-6b0f9f7feb7b" x="0" y="0" width="90" height="30"/&gt;
                                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                                      &lt;font size="12" isBold="true"/&gt;
                                  &lt;/textElement&gt;
                                  &lt;text&gt;&lt;![CDATA[last_name]]&gt;&lt;/text&gt;
                              &lt;/staticText&gt;
                          &lt;/jr:columnHeader&gt;
                          &lt;jr:columnFooter style="table_CH" height="31" rowSpan="1"/&gt;
                          &lt;jr:detailCell style="table_TD" height="20" rowSpan="1"&gt;
                              &lt;textField&gt;
                                  &lt;reportElement uuid="d361d452-b63c-47ff-a2de-33b3f6bebe9c" x="0" y="0" width="90" height="20"/&gt;
                                  &lt;textElement textAlignment="Center"/&gt;
                                  &lt;textFieldExpression&gt;&lt;![CDATA[$F{last_name}]]&gt;&lt;/textFieldExpression&gt;
                              &lt;/textField&gt;
                          &lt;/jr:detailCell&gt;
                      &lt;/jr:column&gt;
                      &lt;jr:column uuid="da448dd2-72b0-4e70-92f8-0343fa894cc0" width="90"&gt;
                          &lt;jr:columnHeader style="table_CH" height="30" rowSpan="1"&gt;
                              &lt;staticText&gt;
                                  &lt;reportElement uuid="388b140a-53d8-4097-b483-007767ab3494" x="0" y="0" width="90" height="30"/&gt;
                                  &lt;textElement textAlignment="Center" verticalAlignment="Middle"&gt;
                                      &lt;font size="12" isBold="true"/&gt;
                                  &lt;/textElement&gt;
                                  &lt;text&gt;&lt;![CDATA[salary]]&gt;&lt;/text&gt;
                              &lt;/staticText&gt;
                          &lt;/jr:columnHeader&gt;
                          &lt;jr:columnFooter style="table_CH" height="31" rowSpan="1"/&gt;
                          &lt;jr:detailCell style="table_TD" height="20" rowSpan="1"&gt;
                              &lt;textField&gt;
                                  &lt;reportElement uuid="25c5ca88-39e2-4ea2-abd7-d1afe2df4ed9" x="0" y="0" width="90" height="20"/&gt;
                                  &lt;textElement textAlignment="Center"/&gt;
                                  &lt;textFieldExpression&gt;&lt;![CDATA[$F{salary}]]&gt;&lt;/textFieldExpression&gt;
                              &lt;/textField&gt;
                          &lt;/jr:detailCell&gt;
                      &lt;/jr:column&gt;
                  &lt;/jr:table&gt;
              &lt;/componentElement&gt;
          &lt;/band&gt;
      &lt;/detail&gt;
      &lt;columnFooter&gt;
          &lt;band height="45" splitType="Stretch"&gt;
              &lt;line&gt;
                  &lt;reportElement uuid="e22bf754-66e2-4993-9e24-93ef1cfadaaa" x="0" y="44" width="555" height="1"/&gt;
              &lt;/line&gt;
          &lt;/band&gt;
      &lt;/columnFooter&gt;
      &lt;pageFooter&gt;
          &lt;band height="54" splitType="Stretch"&gt;
              &lt;textField&gt;
                  &lt;reportElement uuid="94fcb4b3-e6da-4603-a6f1-f10063aee62e" x="409" y="0" width="100" height="20"/&gt;
                  &lt;textElement/&gt;
                  &lt;textFieldExpression&gt;&lt;![CDATA[$V{PAGE_NUMBER}]]&gt;&lt;/textFieldExpression&gt;
              &lt;/textField&gt;
          &lt;/band&gt;
      &lt;/pageFooter&gt;
      &lt;summary&gt;
          &lt;band height="42" splitType="Stretch"/&gt;
      &lt;/summary&gt;
  &lt;/jasperReport&gt;
  </code></pre>