steve.shafer
-
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
Downloads
Posts posted by steve.shafer
-
-
I'm trying to use a JSON file as a data source for a report designed with Jaspersoft Studio 6.5.1.final. I create the Data Adapter, pointing it to this file and selecting "Use the report JSON expression when filling the report". The TEST button shows Success! but I don't get a list of fields anywhere to select from, and when I try to preview my report using this data adapter it complains the document is empty and shows 0 pages. Can anyone please help? I'm assuming the JSON file isn't formatted correctly, but I just don't know.
The JSON file:
{ "item" :
[
{
"id": "12345",
"name": "Donald Duck",
"point": "x y",
"total": 12345.0
},
{
"id": "23456",
"name" : "Yosemite Sam",
"point": "u v",
"total": 54321.0
}
]
}The report:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.5.1.final using JasperReports Library version 6.5.1 -->
<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="example" pageWidth="612" pageHeight="792" columnWidth="572" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="dbbccb9a-1990-400a-a676-0f51c05464a5">
<property name="ireport.zoom" value="1.0"/>
<property name="ireport.x" value="0"/>
<property name="ireport.y" value="0"/>
<property name="com.jaspersoft.studio.unit." value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/>
<property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/>
<property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/>
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="Trial JSON Adapter"/>
<style name="table">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 2">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 3">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 3_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 3_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 4">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 4_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 4_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 5">
<box>
<pen lineWidth="1.0" lineColor="#000000"/>
</box>
</style>
<style name="table 5_TH" mode="Opaque" backcolor="#F0F8FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 5_CH" mode="Opaque" backcolor="#BFE1FF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<style name="table 5_TD" mode="Opaque" backcolor="#FFFFFF">
<box>
<pen lineWidth="0.5" lineColor="#000000"/>
</box>
</style>
<parameter name="HEADER" class="java.lang.String">
<defaultValueExpression><![CDATA["BEGIN"]]></defaultValueExpression>
</parameter>
<parameter name="FOOTER" class="java.lang.String">
<defaultValueExpression><![CDATA["END"]]></defaultValueExpression>
</parameter>
<queryString>
<![CDATA[]]>
</queryString>
<field name="name" class="java.lang.String"/>
<field name="total" class="java.lang.Double"/>
<field name="id" class="java.lang.String"/>
<field name="point" class="java.lang.String"/>
<title>
<band height="79" splitType="Stretch">
<staticText>
<reportElement x="0" y="0" width="555" height="79" uuid="6c8bac56-3aea-4ef7-bf99-b9c0c6dadf63"/>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font size="30" isBold="true" isUnderline="false"/>
</textElement>
<text><![CDATA[Example Label]]></text>
</staticText>
</band>
</title>
<columnHeader>
<band height="60">
<staticText>
<reportElement x="0" y="30" width="153" height="20" uuid="6320b737-d8a5-4563-a16e-5cff508a2d08"/>
<text><![CDATA[id]]></text>
</staticText>
<staticText>
<reportElement x="153" y="30" width="302" height="20" uuid="d6949bb9-9960-4425-94e4-634f7a87bb5c"/>
<text><![CDATA[name]]></text>
</staticText>
<staticText>
<reportElement x="455" y="30" width="100" height="20" uuid="bb2bf7f4-79fc-458c-99b9-b5c6812770f7"/>
<text><![CDATA[total]]></text>
</staticText>
<textField>
<reportElement x="0" y="0" width="555" height="30" uuid="e003bd24-7355-40b5-9263-adff6a2ca43a"/>
<textElement markup="html"/>
<textFieldExpression><![CDATA[$P{HEADER}]]></textFieldExpression>
</textField>
<staticText>
<reportElement x="300" y="30" width="100" height="20" uuid="bc5602db-1986-4240-896f-e95dc34e59e3">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0c96dd60-c92f-49a9-8ca2-430a1b7a137b"/>
</reportElement>
<text><![CDATA[point]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="122">
<textField>
<reportElement x="0" y="20" width="153" height="20" uuid="7108cc10-9366-45ab-b23d-d45db4db1c0c"/>
<textFieldExpression><![CDATA[$F{id}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="153" y="20" width="137" height="20" uuid="1254f26c-0f15-4f10-9a1b-980e64fa3c44"/>
<textFieldExpression><![CDATA[$F{name}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="455" y="20" width="100" height="20" uuid="02eff0fe-5c80-4e59-aee5-ecaaf8922a3d"/>
<textFieldExpression><![CDATA[$F{total}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="300" y="20" width="130" height="20" uuid="38e9d773-9613-4062-9bb9-97c80bed4be2">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="0ba41536-a3e8-4211-ae00-097f3b7595f4"/>
</reportElement>
<textFieldExpression><![CDATA[$F{point}]]></textFieldExpression>
</textField>
</band>
</detail>
<pageFooter>
<band height="50">
<textField>
<reportElement x="0" y="0" width="555" height="50" uuid="6ed5397f-12b1-459e-9949-ed8429d729db"/>
<textFieldExpression><![CDATA[$P{FOOTER}]]></textFieldExpression>
</textField>
</band>
</pageFooter>
</jasperReport>
Thanks in advance!
How do I format JSON file as data source?
in Products
Posted
FIXED! Thanks so much!