Jump to content
We've recently updated our Privacy Statement, available here ×

slavkor

Members
  • Posts

    2
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Security Advisories

Downloads

Everything posted by slavkor

  1. Hi, I am getting this exception when i try to run a report containg a subreport the source of main report <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.4.3.final using JasperReports Library version 6.4.3 --><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="employee_list_009" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="bddf4b77-0b5d-42ee-9071-e44225accaa3"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="ISM.xml"/> <property name="com.jaspersoft.studio.report.description" value=""/> <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver/"/> <property name="ireport.jasperserver.user" value="jasperadmin"/> <property name="ireport.jasperserver.reportUnit" value="/reports/ISM/employee_list_006"/> <property name="net.sf.jasperreports.data.adapter" value="ISM.xml"/> <property name="ireport.jasperserver.report.resource" value="/reports/ISM/employee_list_006_files/main_jrxml"/> <parameter name="url" class="java.lang.String"/> <parameter name="company" class="java.lang.String"/> <parameter name="token" class="java.lang.String"/> <parameter name="reportid" class="java.lang.String"/> <parameter name="SubFieldsMap" class="java.util.Map"> <defaultValueExpression><![CDATA[["company":"company.shortname","project":"project.name","site":"employee.occuancies.project.site.name"]]]></defaultValueExpression> </parameter> <queryString language="WebServiceQuery"> <![CDATA[{ "getparameters" : { }, "fields" : [ { "name" : "id", "expression" : "employee.id" }, { "name" : "name", "expression" : "employee.name" }, { "name" : "lastname", "expression" : "employee.lastname" } ], "options" : { "contentType" : "application/json", "rootPath" : "", "baseUrl" : "dev.api.ismvuzem.si/rpt/20e3a564-f6d5-4936-8499-9698db5a1479/employees/listhome" }, "headersMap" : { "reportid" : "$P{reportid}" }, "queryData" : "", "GETParameters" : { }}]]> </queryString> <field name="id" class="java.lang.String"/> <field name="name" class="java.lang.String"/> <field name="lastname" class="java.lang.String"/> <sortField name="lastname"/> <columnHeader> <band height="22"> <property name="com.jaspersoft.studio.unit.height" value="mm"/> </band> </columnHeader> <detail> <band height="101" splitType="Stretch"> <textField isBlankWhenNull="true"> <reportElement x="0" y="17" width="82" height="14" uuid="9788dc79-4fa7-4bde-b438-6f1fa1893879"> <property name="com.jaspersoft.studio.unit.height" value="mm"/> <property name="com.jaspersoft.studio.unit.leftIndent" value="mm"/> </reportElement> <box> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> <paragraph leftIndent="2"/> </textElement> <textFieldExpression><![CDATA[$F{lastname}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="82" y="17" width="80" height="14" uuid="d4a1c69f-4925-4115-b2ae-55eeb842d64f"> <property name="com.jaspersoft.studio.unit.height" value="mm"/> <property name="com.jaspersoft.studio.unit.leftIndent" value="mm"/> </reportElement> <box> <leftPen lineWidth="0.25"/> <bottomPen lineWidth="0.25"/> <rightPen lineWidth="0.25"/> </box> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> <paragraph leftIndent="2"/> </textElement> <textFieldExpression><![CDATA[$F{name}]]></textFieldExpression> </textField> <staticText> <reportElement mode="Opaque" x="162" y="0" width="640" height="17" backcolor="#E8E6E6" uuid="d24e1122-31aa-4a6a-a7a8-6d7e251fe990"> <property name="com.jaspersoft.studio.unit.height" value="mm"/> <property name="com.jaspersoft.studio.unit.leftIndent" value="mm"/> </reportElement> <box> <topPen lineWidth="0.75"/> <leftPen lineWidth="0.75"/> <bottomPen lineWidth="0.75"/> <rightPen lineWidth="0.75"/> </box> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> <paragraph leftIndent="2"/> </textElement> <text><![CDATA[]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="0" y="0" width="82" height="17" backcolor="#E8E6E6" uuid="ff3d52ee-1943-4561-983b-43b075d542cb"> <property name="com.jaspersoft.studio.unit.height" value="mm"/> <property name="com.jaspersoft.studio.unit.leftIndent" value="mm"/> </reportElement> <box> <topPen lineWidth="0.75"/> <leftPen lineWidth="0.75"/> <bottomPen lineWidth="0.75"/> <rightPen lineWidth="0.75"/> </box> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> <paragraph leftIndent="2"/> </textElement> <text><![CDATA[Priimek]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="82" y="0" width="80" height="17" backcolor="#E8E6E6" uuid="2e9d4089-77b3-404d-bf56-282e83a6a17a"> <property name="com.jaspersoft.studio.unit.height" value="mm"/> <property name="com.jaspersoft.studio.unit.leftIndent" value="mm"/> </reportElement> <box> <topPen lineWidth="0.75"/> <leftPen lineWidth="0.75"/> <bottomPen lineWidth="0.75"/> <rightPen lineWidth="0.75"/> </box> <textElement verticalAlignment="Middle"> <font fontName="DejaVu Sans"/> <paragraph leftIndent="2"/> </textElement> <text><![CDATA[ime]]></text> </staticText> <subreport> <reportElement x="0" y="38" width="490" height="42" uuid="78d11903-1892-4db7-99d2-e07829149104"/> <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression> <subreportParameter name="id"> <subreportParameterExpression><![CDATA[$F{id}]]></subreportParameterExpression> </subreportParameter> <dataSourceExpression><![CDATA[((com.jaspersoft.webservice.data.query.IWSDataSource)$P{REPORT_DATA_SOURCE}).clone("employee(id =="+$F{id}+")", $P{SubFieldsMap})]]></dataSourceExpression> <subreportExpression><![CDATA["empl/employee_list_009_sub_1.jasper"]]></subreportExpression> </subreport> </band> </detail></jasperReport>[/code]the source of the subreport <?xml version="1.0" encoding="UTF-8"?><!-- Created with Jaspersoft Studio version 6.4.3.final using JasperReports Library version 6.4.3 --><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="employee_list_009_sub_1" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="2547a737-aea4-4f3b-b4e8-84fb7325aa5e"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <parameter name="id" class="java.lang.String"/> <queryString language="WebServiceQuery"> <![CDATA[{ "getparameters" : { }, "fields" : [ { "name" : "company", "expression" : "company.shortname" }, { "name" : "project", "expression" : "project.name" } ], "options" : { "contentType" : "application/json", "rootPath" : "employee(id == $P{id}).occupancies", "baseUrl" : "dev.api.ismvuzem.si/rpt/20e3a564-f6d5-4936-8499-9698db5a1479/employees/listhome" }, "headersMap" : { }, "queryData" : "", "GETParameters" : { }}]]> </queryString> <field name="company" class="java.lang.String"/> <field name="project" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <columnHeader> <band height="34"> <staticText> <reportElement x="0" y="0" width="185" height="30" uuid="2902af56-6049-4ebc-bf25-8d9f4d6f4679"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ebd27f34-fa5b-4d79-aca2-d205d6a0b090"/> </reportElement> <text><![CDATA[company]]></text> </staticText> <staticText> <reportElement x="185" y="0" width="185" height="30" uuid="1ea0e641-8853-4873-bdaa-aec6ebb857ff"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1db2e868-9605-4715-99bc-d07d2774368c"/> </reportElement> <text><![CDATA[project]]></text> </staticText> </band> </columnHeader> <detail> <band height="33" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="185" height="30" uuid="37ec138b-de4b-4409-9848-6a0d04c0bf91"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="ebd27f34-fa5b-4d79-aca2-d205d6a0b090"/> </reportElement> <textFieldExpression><![CDATA[$F{company}]]></textFieldExpression> </textField> <textField> <reportElement x="185" y="0" width="185" height="30" uuid="ee11f71b-7c5b-43b6-b97d-6182fbc31147"> <property name="com.jaspersoft.studio.spreadsheet.connectionID" value="1db2e868-9605-4715-99bc-d07d2774368c"/> </reportElement> <textFieldExpression><![CDATA[$F{project}]]></textFieldExpression> </textField> </band> </detail></jasperReport>[/code]what am i doing wrong? Can somebody help me?
  2. Hi, i am having some trouble in assembling a report for my json. The structure of my json: (remote image lost) so i have a main report and a subreport for the occupancies. the subreport is a table with a subdatasource. My problem is that on every main report record the table show all the occupancies. How do i query the occupancies node for a specific record? pleace help
×
×
  • Create New...