I have create stored procedure on oracle database, and desig jasper report using jasperstudio, data has been sucessfully fetch on jasperstudio, but while trying to upload jrxml file on server, unable to upload with error:
How to solve the issue??
1 Answer:
Posted on February 11, 2019 at 12:17pm
If you're working with an older version of Jasper Server (6.2.x or older) you'll need to enable using stored procedures - steps are detailed here:
https://community.jaspersoft.com/wiki/how-execute-ms-sql-stored-procedur...
If you're working with version 6.3 plus, no changes are needed. If this doesn't address the issue you're expriencing, post your jrxml. Is this the first report resource you're publishing that references a stored proc?
jarxml file still now working:
<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.6.0.final using JasperReports Library version 6.6.0 -->
<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_1" pageWidth="1000" pageHeight="842" whenNoDataType="BlankPage" columnWidth="960" leftMargin="20" rightMargin="20" topMargin="0" bottomMargin="0" uuid="69abcd0b-ef31-4e05-b830-cd7eaf036e58">
<property name="com.jaspersoft.studio.data.defaultdataadapter" value="PRODUCTION"/>
<property name="com.jaspersoft.studio.data.sql.tables" value=""/>
<parameter name="p_set_id" class="java.lang.String"/>
<parameter name="p_out_res" class="java.sql.ResultSet" isForPrompting="false"/>
<parameter name="p_asofdate" class="java.lang.String"/>
<parameter name="p_monthofdate" class="java.lang.String"/>
<queryString language="plsql">
<![CDATA[{ call custom.sanrpt_pl_proc1( $P{p_set_id}, $P{p_asofdate},$P{p_monthofdate},$P{p_out_res})}]]>
</queryString>
<field name="SOL_ID" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label" value="SOL_ID"/>
</field>
<field name="A.SOL_ID||'_'||A.DESCRIPTION" class="java.lang.String">
<property name="com.jaspersoft.studio.field.label">
<![CDATA[A.SOL_ID||'_'||A.DESCRIPTION]]>
</property>
</field>
<field name="YEARTODATE" class="java.math.BigDecimal">
<property name="com.jaspersoft.studio.field.label" value="YEARTODATE"/>
</field>
<field name="ASOFDATE" class="java.sql.Timestamp">
<property name="com.jaspersoft.studio.field.label" value="ASOFDATE"/>
</field>
<field name="YEARTOMONTH" class="java.math.BigDecimal">
<property name="com.jaspersoft.studio.field.label" value="YEARTOMONTH"/>
</field>
<field name="MONTHOFDATE" class="java.sql.Timestamp">
<property name="com.jaspersoft.studio.field.label" value="MONTHOFDATE"/>
</field>
<field name="(A.YEARTODATE-B.YEARTOMONTH)" class="java.math.BigDecimal">
<property name="com.jaspersoft.studio.field.label" value="(A.YEARTODATE-B.YEARTOMONTH)"/>
</field>
<background>
<band splitType="Stretch"/>
</background>
<columnHeader>
<band height="21" splitType="Stretch">
<staticText>
<reportElement x="0" y="0" width="50" height="21" uuid="8d42d014-f45a-4118-a59c-bd8a0a2c96fb">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="736dd38e-470d-4b5c-aff9-53e0148ca1ba"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[SOL_ID]]></text>
</staticText>
<staticText>
<reportElement x="51" y="0" width="209" height="21" uuid="bc813177-f01c-4057-a182-05ad2e82e4b0">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c9ff8ac2-af37-42ab-874b-7aa8adbd0099"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[A.SOL_ID||'_'||A.DESCRIPTION]]></text>
</staticText>
<staticText>
<reportElement x="260" y="0" width="137" height="21" uuid="f890400a-3db7-4041-92df-432f72372fb7">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9131d907-6094-4c18-828a-463a4abbe5f6"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[YEARTODATE]]></text>
</staticText>
<staticText>
<reportElement x="397" y="0" width="120" height="21" uuid="4e063c7b-6095-4a4b-aa5f-c3e44b31baf1">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e48d217f-60cd-489b-a2cf-9c0a85f51e25"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[ASOFDATE]]></text>
</staticText>
<staticText>
<reportElement x="517" y="0" width="156" height="21" uuid="eb6916a7-5589-4356-ad24-d4fea6afbc5f">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5578712f-6a68-4e93-b026-6148cb09852d"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[YEARTOMONTH]]></text>
</staticText>
<staticText>
<reportElement x="673" y="0" width="137" height="21" uuid="693042be-f0b7-4750-8903-496060f10736">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="76d41d79-27b5-4feb-bedf-89732fe68762"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[MONTHOFDATE]]></text>
</staticText>
<staticText>
<reportElement x="810" y="0" width="150" height="21" uuid="3937df75-6829-4d8a-a2f3-deb6bc64ebc9">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="24ce196b-901c-4a15-85cc-32b6792f9003"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle">
<font isBold="true"/>
</textElement>
<text><![CDATA[MONTHTODATE]]></text>
</staticText>
</band>
</columnHeader>
<detail>
<band height="20" splitType="Stretch">
<textField>
<reportElement x="0" y="0" width="50" height="20" uuid="7667f802-4a02-45b7-a270-503eb6c04fe1">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="736dd38e-470d-4b5c-aff9-53e0148ca1ba"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{SOL_ID}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="51" y="0" width="209" height="20" uuid="c300e76f-a6a1-411f-8bd0-82ae045f45c5">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="c9ff8ac2-af37-42ab-874b-7aa8adbd0099"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Left" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{A.SOL_ID||'_'||A.DESCRIPTION}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="260" y="0" width="137" height="20" uuid="6e22036d-4a0f-4933-a70c-19241dc85a6a">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="9131d907-6094-4c18-828a-463a4abbe5f6"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{YEARTODATE}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="397" y="0" width="120" height="20" uuid="f4e9ee19-45d2-406a-9cf9-9edf9f006936">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="e48d217f-60cd-489b-a2cf-9c0a85f51e25"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{ASOFDATE}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="517" y="0" width="156" height="20" uuid="4db916d1-02c3-4e37-a5cd-da7e52c6e610">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="5578712f-6a68-4e93-b026-6148cb09852d"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{YEARTOMONTH}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="673" y="0" width="137" height="20" uuid="71ed8bae-d26b-4dea-ba65-6935346f9701">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="76d41d79-27b5-4feb-bedf-89732fe68762"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{MONTHOFDATE}]]></textFieldExpression>
</textField>
<textField>
<reportElement x="810" y="0" width="150" height="20" uuid="3d8cd0c8-5125-44af-a276-f070175c6753">
<property name="com.jaspersoft.studio.spreadsheet.connectionID" value="24ce196b-901c-4a15-85cc-32b6792f9003"/>
</reportElement>
<box>
<pen lineWidth="0.25"/>
</box>
<textElement textAlignment="Center" verticalAlignment="Middle"/>
<textFieldExpression><![CDATA[$F{(A.YEARTODATE-B.YEARTOMONTH)}]]></textFieldExpression>
</textField>
</band>
</detail>
</jasperReport>