title: Jaspersoft studio json data adapter book or subreport document is Empty
body: <p>I am trying to do something really simple yet after searching for the past few days I could not find an answer, I need some help on this one.</p>
  
  <p><strong>What I am trying to do:</strong> 
  I have multiple reports so A4 portrait some landscape, some with just static text some with tables, some with tables and variables and I want to put merge them together. </p>
  
  <p>They work 100% individually.</p>
  
  <p>Tried to make a master report with subreports did not work, tried the book approach did not work, I always get Document is empty, or if I try to manipulate the data query I get all kind of weird stuff. </p>
  
  <p>Now I will try to make this example as simple as possible.</p>
  
  <p><strong>JSON data: (New data Adapter)</strong> </p>
  
  <pre><code>{
    "name": "Sample Name",
    "people":[
      {
        "who": "Person 1"
      },
      {
        "who": "Person 2"
      },
      {
        "who": "Person 3"
      }
    ]
  }
  </code></pre>
  
  <p><strong>Book master report:</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0  --&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="Empty_Book" pageWidth="595" pageHeight="842" sectionType="Part" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30" uuid="d2716064-8ae4-40cf-a575-33afba400e3a"&gt;
      &lt;property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter "/&gt;
      &lt;property name="net.sf.jasperreports.print.create.bookmarks" value="true"/&gt;
      &lt;queryString language="json"&gt;
          &lt;![CDATA[]]&gt;
      &lt;/queryString&gt;
      &lt;detail&gt;
          &lt;part uuid="69d6ca13-26f6-425f-bff9-395c5b9c183b"&gt;
              &lt;p:subreportPart xmlns:p="http://jasperreports.sourceforge.net/jasperreports/parts" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/parts http://jasperreports.sourceforge.net/xsd/parts.xsd"&gt;
                  &lt;subreportParameter name="REPORT_CONNECTION"&gt;
                      &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/subreportParameterExpression&gt;
                  &lt;/subreportParameter&gt;
                  &lt;subreportExpression&gt;&lt;![CDATA["Blank_A4_2.jasper"]]&gt;&lt;/subreportExpression&gt;
              &lt;/p:subreportPart&gt;
          &lt;/part&gt;
          &lt;part uuid="055c9f89-88b4-4270-b6ef-addb2eac3e56"&gt;
              &lt;p:subreportPart xmlns:p="http://jasperreports.sourceforge.net/jasperreports/parts" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/parts http://jasperreports.sourceforge.net/xsd/parts.xsd"&gt;
                  &lt;subreportParameter name="REPORT_CONNECTION"&gt;
                      &lt;subreportParameterExpression&gt;&lt;![CDATA[$P{REPORT_CONNECTION}]]&gt;&lt;/subreportParameterExpression&gt;
                  &lt;/subreportParameter&gt;
                  &lt;subreportExpression&gt;&lt;![CDATA["Blank_A4_Landscape_1.jasper"]]&gt;&lt;/subreportExpression&gt;
              &lt;/p:subreportPart&gt;
          &lt;/part&gt;
      &lt;/detail&gt;
  &lt;/jasperReport&gt;
  </code></pre>
  
  <p><strong>Blank_A4_2.jrxml</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0  --&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="Blank_A4_2" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bd2bd70c-5a0d-4c3f-b81d-4d5d7731153d"&gt;
      &lt;property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter "/&gt;
      &lt;queryString language="json"&gt;
          &lt;![CDATA[]]&gt;
      &lt;/queryString&gt;
      &lt;field name="name" class="java.lang.String"&gt;
          &lt;property name="net.sf.jasperreports.json.field.expression" value="name"/&gt;
          &lt;fieldDescription&gt;&lt;![CDATA[name]]&gt;&lt;/fieldDescription&gt;
      &lt;/field&gt;
      &lt;background&gt;
          &lt;band splitType="Stretch"/&gt;
      &lt;/background&gt;
      &lt;detail&gt;
          &lt;band height="125" splitType="Stretch"&gt;
              &lt;textField&gt;
                  &lt;reportElement x="150" y="30" width="100" height="30" uuid="eef5f1dc-3d96-4008-8321-ef0be92d42d4"/&gt;
                  &lt;textFieldExpression&gt;&lt;![CDATA[$F{name}]]&gt;&lt;/textFieldExpression&gt;
              &lt;/textField&gt;
              &lt;staticText&gt;
                  &lt;reportElement x="50" y="30" width="100" height="30" uuid="cbe6173f-5399-45ec-926b-ff6f48b4fb0c"/&gt;
                  &lt;text&gt;&lt;![CDATA[name]]&gt;&lt;/text&gt;
              &lt;/staticText&gt;
          &lt;/band&gt;
      &lt;/detail&gt;
  &lt;/jasperReport&gt;
  </code></pre>
  
  <p><strong>Blank_A4_Landscape_1.jrxml</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0  --&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="Blank_A4_Landscape_1" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="62f06d09-42b5-4471-baa5-5aed60cc5fc4"&gt;
      &lt;property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter "/&gt;
      &lt;subDataset name="Dataset1" uuid="eb54ec0d-0c60-44af-8476-e44f40560dee"&gt;
          &lt;property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter "/&gt;
          &lt;queryString language="json"&gt;
              &lt;![CDATA[people]]&gt;
          &lt;/queryString&gt;
          &lt;field name="who" class="java.lang.String"&gt;
              &lt;property name="net.sf.jasperreports.json.field.expression" value="who"/&gt;
              &lt;fieldDescription&gt;&lt;![CDATA[who]]&gt;&lt;/fieldDescription&gt;
          &lt;/field&gt;
      &lt;/subDataset&gt;
      &lt;queryString language="JSON"&gt;
          &lt;![CDATA[]]&gt;
      &lt;/queryString&gt;
      &lt;field name="name" class="java.lang.String"&gt;
          &lt;property name="net.sf.jasperreports.json.field.expression" value="name"/&gt;
          &lt;fieldDescription&gt;&lt;![CDATA[name]]&gt;&lt;/fieldDescription&gt;
      &lt;/field&gt;
      &lt;background&gt;
          &lt;band splitType="Stretch"/&gt;
      &lt;/background&gt;
      &lt;columnHeader&gt;
          &lt;band height="175"&gt;
              &lt;textField&gt;
                  &lt;reportElement x="132" y="81" width="100" height="30" uuid="5cce1f44-2a8b-42ad-a03d-4c294f02d31c"/&gt;
                  &lt;textFieldExpression&gt;&lt;![CDATA[$F{name}]]&gt;&lt;/textFieldExpression&gt;
              &lt;/textField&gt;
          &lt;/band&gt;
      &lt;/columnHeader&gt;
      &lt;detail&gt;
          &lt;band height="140" splitType="Stretch"&gt;
              &lt;componentElement&gt;
                  &lt;reportElement x="110" y="45" width="200" height="40" uuid="75a06812-f9a0-4b0f-9a08-efec60d0b555"/&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="Dataset1" uuid="acd62160-c07c-4c00-b6b4-9ef001d1585d"&gt;
                          &lt;dataSourceExpression&gt;&lt;![CDATA[((net.sf.jasperreports.engine.data.JsonDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("people")]]&gt;&lt;/dataSourceExpression&gt;
                      &lt;/datasetRun&gt;
                      &lt;jr:column width="200" uuid="253a610c-a780-4690-8cce-8a03597ef016"&gt;
                          &lt;jr:detailCell height="30"&gt;
                              &lt;textField&gt;
                                  &lt;reportElement x="0" y="0" width="200" height="30" uuid="910a7e24-c02b-4b21-8c9d-6a3dfda21794"/&gt;
                                  &lt;textFieldExpression&gt;&lt;![CDATA[$F{who}]]&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;/jasperReport&gt;
  </code></pre>
  
  <p>Tested all files before posting, individually they work, I have no params to send to the subreports, I tried looping over the array and still nothing I always get document is Empty no matter what I do.</p>