gtamang47 Posted February 11, 2019 Share Posted February 11, 2019 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:The selected JRXML could not be parsed. You might have selected the wrong file.How to solve the issue?? Link to comment Share on other sites More sharing options...
Solution darth_fader Posted February 11, 2019 Solution Share Posted February 11, 2019 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-procedure-jasperreports-serverIf 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? Link to comment Share on other sites More sharing options...
gtamang47 Posted February 12, 2019 Author Share Posted February 12, 2019 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> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now