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

How to pass dynamic value in parameter after Scheduling a report?


udit.rajput2010

Recommended Posts

Hi,

I have design a report using two parameter, Calling a procedure(Input 2 values). I have deployed this report on Jasper Report Server, Configuring Both parameter First parameter using single Select Query with dynamic value When I run the report. It is working fine. But When I schedule the report it picks single value That was picked when i was scheduled. Not picking Dynamic Value. Give me the right way. please help me.

Parameter1 Query

SELECT ABC_TEST_REQUEST_S.NEXTVAL Val_Request_id,ABC_TEST_REQUEST_S.CURRVAL Request_id FROM DUAL

jrxml Code

<?xml version="1.0" encoding="UTF-8"?>
<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1  -->
<!-- 2017-03-16T17:43:19 -->
<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="HelpAge_Donation_Report" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="632e0004-5d14-4ed9-846e-02edb387d8f4">
    <property name="com.jaspersoft.studio.data.sql.tables" value=""/>
    <property name="com.jaspersoft.studio.data.defaultdataadapter" value="My Simple JDBC"/>
    <parameter name="Parameter1" class="java.lang.String"/>
    <parameter name="Parameter2" class="java.lang.String"/>
    <queryString language="plsql">
        <![CDATA[{call xxhi_ext_cust_import_pkg.AR_CUSTOMER_IMPORT($P{Parameter1},$P{Parameter2})}]]>
    </queryString>
    <field name="Field_1" class="java.lang.String"/>
    <field name="Field_2" class="java.lang.String"/>
    <background>
        <band splitType="Stretch"/>
    </background>
    <title>
        <band height="55" splitType="Stretch"/>
    </title>
    <pageHeader>
        <band height="35" splitType="Stretch"/>
    </pageHeader>
    <columnHeader>
        <band splitType="Stretch"/>
    </columnHeader>
    <detail>
        <band height="130" splitType="Stretch"/>
    </detail>
    <pageFooter>
        <band splitType="Stretch"/>
    </pageFooter>
    <lastPageFooter>
        <band height="52"/>
    </lastPageFooter>
    <summary>
        <band splitType="Stretch"/>
    </summary>
</jasperReport>

Regards

Udit

 


 

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...