nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cascading Not working Properly

Demolisher

Hi,

I had created few reports for the version
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.16" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.3.0.v20080606 Build <2.3.0.v20080618-0630></property>

I had used the cascading parameters in this. Cascading is working fine for me in the Birt Designer but not working after integration. I am not getting any error. If I run the report without casacding I am able to get the report.

Ideally On click of 1 parameter the parameter in the follwing box should be filtered out, but this is not happening after Integartion.

Please suggest on the same

Find more posts tagged with

Comments

JasonW

Can you give more detail on your integration?

Jason

Demolisher

Hi,

we had integrated it in WAS 6.1.
The jars used as plugins are as follows.

com.lowagie.itext_1.5.4.v20080228
org.apache.derby.core_10.3.1.4
org.eclipse.birt.report.data.oda.jdbc_2.3.0.v20080610
org.eclipse.birt.report.data.oda.sampledb_2.3.0.v20080606
org.eclipse.birt.report.engine.fonts_2.3.0.v20080606
org.eclipse.core.runtime.compatibility.registry_3.2.200.v20080610
org.junit_3.8.2.v20080602-1318
org.mozilla.rhino_1.6.7.v20080214
org.w3c.sac_1.3.0.v20070710
apart from them, there are many jars present in the ReportEngine. I am mentioning the name of those which had birt in their package name.

org.eclipse.birt.api_1.0.0.jar
org.eclipse.birt.chart.device.extension_2.3.0.v20080424.jar
org.eclipse.birt.chart.device.svg_2.3.0.v20080526.jar
org.eclipse.birt.chart.engine_2.3.0.v20080606.jar
org.eclipse.birt.chart.engine.extension_2.3.0.v20080611.jar
org.eclipse.birt.chart.reportitem_2.3.0.v20080610.jar
org.eclipse.birt.core_2.3.0.v20080606.jar
org.eclipse.birt.data_2.3.0.v20080606.jar
org.eclipse.birt.data.aggregation_2.3.0.v20080606.jar
org.eclipse.birt.report.data.adapter_2.3.0.v20080606.jar
org.eclipse.birt.report.data.oda.jdbc.dbprofile_2.3.0.v20080606.jar
org.eclipse.birt.report.data.oda.xml_2.3.0.v20080606.jar
org.eclipse.birt.report.engine_2.3.0.v20080616.jar
org.eclipse.birt.report.engine.dataextraction_2.3.0.v20080611.jar
org.eclipse.birt.report.engine.dataextraction.csv_2.3.0.v200806102.jar
org.eclipse.birt.report.engine.emitter.html_2.3.0.v20080606.jar
org.eclipse.birt.report.engine.emitter.pdf_2.3.0.v20080606.jar
org.eclipse.birt.report.engine.emitter.prototype.excel_2.3.0.v20080606.jar
org.eclipse.birt.report.item.crosstab.core_2.3.0.v20080606.jar
org.eclipse.birt.report.model_2.3.0.v20080605.jar
org.eclipse.birt.report.model.adapter.oda_2.3.0.v20080523.jar

Please confirm that all the reports apart from the one using Chart and Crosstab are working fine,

JasonW

Did you write your own servlet? Or are you using the WebViewerExample app? If you wrote your own, cascading will have have be implemented in your code.

Jason

Demolisher

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="78014" data-time="1307369018" data-date="06 June 2011 - 07:03 AM">
Did you write your own servlet? Or are you using the WebViewerExample app? If you wrote your own, cascading will have have be implemented in your code. 
 
Jason </blockquote>
 
 
Hi Jason, 
 
We are trying to take 1 parameter from the JSP. and if that parameter is not present then we will take the cascading parameters. Please find the attached design 
<?xml version="1.0" encoding="UTF-8"?> 
<report xmlns="<a class='bbc_url' href='http://www.eclipse.org/birt/2005/design'>http://www.eclipse.org/birt/2005/design"</a> version="3.2.16" id="1"> 
<property name="createdBy">Eclipse BIRT Designer Version 2.3.0.v20080606 Build <2.3.0.v20080618-0630></property> 
<property name="units">in</property> 
<text-property name="title">ACH Returns from Received Live Items v20110609</text-property> 
<html-property name="description">Template with Chart followed by table, plus Master Page with Header and Footer</html-property> 
<method name="initialize"><![CDATA[importPackage(Packages.java.io); 
 
fos = new java.io.FileOutputStream(reportContext.getParameterValue("RP_Log_Path") + "//" + reportContext.getParameterValue("RP_User")+ "_PVACH_Returns_from_Received_Live_Items_1.log"); 
printWriter = new java.io.PrintWriter(fos); 
printWriter.println("ReportDesign.initialize"); 
printWriter.println("*************************************************************************************"); 
printWriter.println("Passed parameters"); 
printWriter.println("RP_Internal_External=" + reportContext.getParameterValue("RP_Internal_External")); 
printWriter.println("RP_ReportBank: RecordID=" + reportContext.getParameterValue("RP_ReportBank") + "-" + reportContext.getParameterDisplayText("RP_ReportBank")); 
printWriter.println("*************************************************************************************"); 
 
//initialize the value 
reportContext.setPersistentGlobalVariable("errorMessage",""); 
reportContext.setPersistentGlobalVariable("debugMessage",""); 
reportContext.setPersistentGlobalVariable("reportRegion",reportContext.getParameterValue("RP_ReportRegion")+"+"); 
 
 
var reportBank = reportContext.getParameterValue("RP_Bank"); 
if(reportBank==null || reportBank == "") { 
reportBank = reportContext.getParameterValue("RP_ReportBank"); 
} 
if(reportBank.constructor.toString().indexOf("Array") != -1) { 
if(reportBank!=null && reportBank.length!=0 && reportBank[0]!="ALL") 
{ 
//multi-select 
var index; 
var reportBanks = reportBank[0]; 
for(index=1;index<reportBank.length;index++) { 
reportBanks = reportBanks + ", " + reportBank[index]; 
} 
reportContext.setPersistentGlobalVariable("reportBank",reportBanks); 
} else { 
reportContext.setPersistentGlobalVariable("reportBank","ALL"); 
} 
} else if(reportBank!=null && reportBank.length!=0) { 
reportContext.setPersistentGlobalVariable("reportBank",reportBank); 
} 
 
var reportBankTR = reportContext.getParameterValue("RP_BankTR"); 
if(reportBankTR==null || reportBankTR == "") { 
reportBankTR = reportContext.getParameterValue("RP_ReportBankTR"); 
} 
if(reportBankTR.constructor.toString().indexOf("Array") != -1) { 
if(reportBankTR!=null && reportBankTR.length!=0 && reportBankTR[0]!="ALL") 
{ 
//multi-select 
var index; 
var reportBankTRs = reportBankTR[0]; 
for(index=1;index<reportBankTR.length;index++) { 
reportBankTRs = reportBankTRs + ", " + reportBankTR[index]; 
} 
reportContext.setPersistentGlobalVariable("reportBankTR",reportBankTRs); 
} else { 
reportContext.setPersistentGlobalVariable("reportBankTR","ALL"); 
} 
} else if(reportBankTR!=null && reportBankTR.length!=0) { 
reportContext.setPersistentGlobalVariable("reportBankTR",reportBankTR); 
} 
 
//has no effect 
/********/ 
//reportContext.setParameterValue("RP_ReportFI","Allx"); 
//reportContext.setParameterDisplayText("RP_ReportFI","Allx2"); 
//reportContext.setParameterValue("RP_ReportBank","Allx"); 
//reportContext.setParameterDisplayText("RP_ReportBank","Allx2"); 
//reportContext.setParameterValue("RP_ReportCustomer","Allx"); 
//reportContext.setParameterDisplayText("RP_ReportCustomer",reportContext.getParameterValue("RP_FI")); 
//var parmFI = reportContext.getDesignHandle().findParameter("RP_ReportFI"); 
//reportContext.setPersistentGlobalVariable("debugMessage", "RP_ReportFI: " + parmFI.getDefaultValue()); 
//parmFI.setDefaultValue("test");]]></method> 
<method name="beforeFactory"><![CDATA[//query = this.getDataSet("FinancialInstitutions").queryText 
//query = reportContext.getParameterValue("RP_Bank"); 
//query = this.getReportElement("RP_Bank"). 
//query = reportContext.getPersistentGlobalVariable("debugMessage"); 
//this.getDynamicText("DebugTextElement").valueExpr = "query;"; 
if(reportContext.getOutputFormat() != "pdf"){ 
//reportContext.getDesignHandle().findElement("RP_Color").setProperty("Hidden",true); 
}]]></method> 
<method name="afterRender"><![CDATA[printWriter.println("*************************************************************************************"); 
printWriter.println("ReportDesign.afterRender"); 
printWriter.println("*************************************************************************************"); 
printWriter.close();]]></method> 
<text-property name="displayName">PV_ACH_Forward_Activity</text-property> 
<property name="iconFile">/templates/blank_report.gif</property> 
<parameters> 
<scalar-parameter name="RP_StartDate" id="254"> 
<property name="valueType">static</property> 
<property name="dataType">date</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">Enter Start Date (mm/dd/yyyy)</text-property> 
<property name="concealValue">false</property> 
<property name="isRequired">true</property> 
<property name="controlType">text-box</property> 
<property name="defaultValue">01/01/2008</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Custom</property> 
<property name="pattern">MM/dd/yyyy</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_EndDate" id="255"> 
<property name="valueType">static</property> 
<property name="dataType">date</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">Enter End Date (mm/dd/yyyy)</text-property> 
<property name="concealValue">false</property> 
<property name="isRequired">true</property> 
<property name="controlType">text-box</property> 
<property name="defaultValue">3/30/2013</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Custom</property> 
<property name="pattern">MM/dd/yyyy</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_SummaryLevel" id="289"> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">Enter Summary Level</text-property> 
<property name="controlType">list-box</property> 
<property name="mustMatch">true</property> 
<property name="fixedOrder">true</property> 
<property name="defaultValue">Daily</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
<list-property name="selectionList"> 
<structure> 
<property name="value">Daily</property> 
<property name="label">Daily</property> 
</structure> 
<structure> 
<property name="value">Weekly</property> 
<property name="label">Weekly</property> 
</structure> 
<structure> 
<property name="value">Monthly</property> 
<property name="label">Monthly</property> 
</structure> 
<structure> 
<property name="value">Quarterly</property> 
<property name="label">Quarterly</property> 
</structure> 
<structure> 
<property name="value">Yearly</property> 
<property name="label">Yearly</property> 
</structure> 
</list-property> 
</scalar-parameter> 
<cascading-parameter-group name="RP_EntitySelection" id="2456"> 
<text-property name="promptText">Limit the report to:</text-property> 
<property name="dataSetMode">multiple</property> 
<parameters> 
<scalar-parameter name="RP_ReportBank" id="2459"> 
<property name="valueType">dynamic</property> 
<property name="dataType">string</property> 
<property name="paramType">multi-value</property> 
<text-property name="promptText">Bank</text-property> 
<property name="isRequired">true</property> 
<property name="controlType">list-box</property> 
<property name="dataSetName">Banks</property> 
<expression name="valueExpr">row["BANKID"]</expression> 
<expression name="labelExpr">row["BANKID"]</expression> 
<property name="fixedOrder">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_ReportBankTR" id="2611"> 
<property name="valueType">dynamic</property> 
<property name="dataType">string</property> 
<property name="paramType">multi-value</property> 
<text-property name="promptText">Bank TR</text-property> 
<property name="isRequired">true</property> 
<property name="controlType">list-box</property> 
<property name="dataSetName">TRs</property> 
<expression name="valueExpr">row["BANKTR"]</expression> 
<expression name="labelExpr">row["BANKTR"]</expression> 
<property name="fixedOrder">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
</parameters> 
</cascading-parameter-group> 
<scalar-parameter name="RP_ReportNetwork" id="1519"> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">Limit report to network:</text-property> 
<property name="controlType">list-box</property> 
<property name="mustMatch">true</property> 
<property name="fixedOrder">true</property> 
<property name="defaultValue">ALL</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
<list-property name="selectionList"> 
<structure> 
<property name="value">ALL</property> 
<property name="label">All Items</property> 
</structure> 
<structure> 
<property name="value">S</property> 
<property name="label">ACH Network Items (FED+EPN)</property> 
</structure> 
<structure> 
<property name="value">F</property> 
<property name="label">FED Items Only</property> 
</structure> 
<structure> 
<property name="value">E</property> 
<property name="label">EPN Items Only</property> 
</structure> 
<structure> 
<property name="value">O</property> 
<property name="label">On-Us Items Only</property> 
</structure> 
</list-property> 
</scalar-parameter> 
<scalar-parameter name="RP_Show_Query_Information" id="352"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">boolean</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">Check box to show SQL query information:</text-property> 
<property name="controlType">check-box</property> 
<property name="defaultValue">false</property> 
<property name="distinct">true</property> 
<structure name="format"/> 
</scalar-parameter> 
<scalar-parameter name="RP_Internal_External" id="469"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="defaultValue">Internal</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_Log_Path" id="1151"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="defaultValue">c:\temp</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_User" id="1226"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_JNDI_Name_SCDC" id="1227"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="controlType">text-box</property> 
<property name="defaultValue">jdbc/SCDC_DS</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_Heading_Line_1" id="1233"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_Heading_Line_2" id="1234"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_Heading_Line_3" id="1235"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_FI" id="2398"> 
<property name="hidden">true</property> 
<text-property name="helpText">This is the FI of the user</text-property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">FI</text-property> 
<property name="concealValue">false</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_Bank" id="2469"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">Bank</text-property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_Customer" id="2470"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">Customer</text-property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_BankTR" id="2613"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_Region" id="2614"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="isRequired">false</property> 
<property name="controlType">text-box</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_Color" id="2642"> 
<property name="hidden">false</property> 
<text-property name="helpText">Only effects PDF output</text-property> 
<property name="valueType">static</property> 
<property name="dataType">boolean</property> 
<property name="paramType">simple</property> 
<text-property name="promptText">PDF Output Option</text-property> 
<property name="controlType">radio-button</property> 
<property name="fixedOrder">true</property> 
<property name="defaultValue">false</property> 
<property name="distinct">true</property> 
<structure name="format"/> 
<list-property name="selectionList"> 
<structure> 
<property name="value">true</property> 
<property name="label">Color</property> 
</structure> 
<structure> 
<property name="value">false</property> 
<property name="label">B/W (Printer Friendly)</property> 
</structure> 
</list-property> 
</scalar-parameter> 
<scalar-parameter name="RP_JNDI_Name_SCDCHIST" id="2643"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="controlType">text-box</property> 
<property name="defaultValue">jdbc/SCDCHIST_DS</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
<scalar-parameter name="RP_JNDI_Name_PV" id="2644"> 
<property name="hidden">true</property> 
<property name="valueType">static</property> 
<property name="dataType">string</property> 
<property name="paramType">simple</property> 
<property name="controlType">text-box</property> 
<property name="defaultValue">jdbc/PV_DS</property> 
<property name="distinct">true</property> 
<structure name="format"> 
<property name="category">Unformatted</property> 
</structure> 
</scalar-parameter> 
</parameters> 
<data-sources> 
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="PV" id="130"> 
<method name="beforeOpen"><![CDATA[var reportLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportLevel == "Daily" || reportLevel == "Weekly") 
{ 
this.setExtensionProperty("odaJndiName",reportContext.getParameterValue("RP_JNDI_Name_SCDCHIST")); 
} else { 
this.setExtensionProperty("odaJndiName",reportContext.getParameterValue("RP_JNDI_Name_SCDCHIST")); 
}]]></method> 
<property name="odaDriverClass">com.ibm.db2.jcc.DB2Driver</property> 
<property name="odaJndiName">jdbc/SCDC_DS</property> 
</oda-data-source> 
</data-sources> 
<data-sets> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Banks" id="252"> 
<structure name="cachedMetaData"/> 
<property name="dataSource">PV</property> 
<method name="beforeOpen"><![CDATA[importPackage(Packages.java.io); 
 
fos = new java.io.FileOutputStream(reportContext.getParameterValue("RP_Log_Path") + "//" + reportContext.getParameterValue("RP_User")+ "_PVACH_Returns_from_Received_Live_Items_2.log"); 
printWriter = new java.io.PrintWriter(fos); 
reportContext.setParameterValue("RP_ReportBank","ALL"); 
//reportContext.setParameterDisplayText("RP_ReportBank","ALL"); 
try { 
var bank = reportContext.getParameterValue("RP_Bank"); 
if(bank!=null && bank!="" && bank!="ALL") { 
//restrict to customer 
//replace the entire query 
this.queryText = "select '" + bank + "' as BANKID FROM sysibm.sysdummy1"; 
} else { 
//var reportFI; 
var reportBank; 
var reportTR; 
//var reportCustomer; 
 
 
// --{bankSelectCondition} 
reportBank = reportContext.getParameterValue("RP_Bank"); 
if(reportBank==null || reportBank=="") { 
reportBank = reportContext.getParameterValue("RP_ReportBank"); 
} 
 
if(reportBank!=null &&amp reportBank.constructor.toString().indexOf("Array") != -1){ 
//if(reportBank.constructor.toString().indexOf("Array") != -1) { 
if(reportBank!=null && reportBank.length!=0 
&& reportBank[0]!="ALL" && reportBank[0]!="") 
{ 
//multi-select 
var index; 
var reportBanks = "'" + reportBank[0] + "'"; 
for(index=1;index<reportBank.length;index++) { 
reportBanks = reportBanks + ",'" + reportBank[index] + "'"; 
} 
this.queryText = this.queryText.replace("--{bankSelectCondition}", 
"and BANKID in (" + reportBanks + ") "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
//} 
} else if(reportBank!=null && reportBank.length!=0 && reportBank!="ALL") { 
//in the development environment this returns a single select 
this.queryText = this.queryText.replace("--{bankSelectCondition}", 
"and BANKID = '" + reportBank + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
 
//--{banktrSelectCondition} 
//multi-select 
reportTR = reportContext.getParameterValue("RP_BankTR"); 
if(reportTR==null || reportTR=="") { 
reportTR = reportContext.getParameterValue("RP_ReportBankTR"); 
} 
//reportContext.setPersistentGlobalVariable("debugMessage", reportTR + "Constructor: " + reportTR.constructor); 
//in the development environment the parameter seems to be passed as a string 
//instead of an array of strings. Skip it if not an array. 
 
if(reportTR!=null && reportTR.constructor.toString().indexOf("Array") != -1 ){ 
//if(reportTR.constructor.toString().indexOf("Array") != -1) { 
if(reportTR!=null && reportTR.length!=0 
&& reportTR[0]!="ALL" && reportTR[0]!="") 
{ 
//multi-select 
var index; 
var reportTRs = "'" + reportTR[0] + "'"; 
for(index=1;index<reportTR.length;index++) { 
reportTRs = reportTRs + ",'" + reportTR[index] + "'"; 
} 
this.queryText = this.queryText.replace("--{banktrSelectCondition}", 
"and BANKTR in (" + reportTRs + ") "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
//} 
} else if(reportTR!=null && reportTR.length!=0 && reportTR!="ALL") { 
this.queryText = this.queryText.replace("--{banktrSelectCondition}", 
"and BANKTR = '" + reportTR + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
 
 
//--{timeSelectCondition} 
var start = reportContext.getParameterValue("RP_StartDate").toString(); 
var end = reportContext.getParameterValue("RP_EndDate").toString(); 
this.queryText = this.queryText.replace("--{timeSelectCondition}", 
" and BUSINESSDATE between '" + start + 
"' and '" + end + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
} catch(e) { 
this.queryText = "select 'Exception!' as BANKID FROM sysibm.sysdummy1"; 
} 
reportContext.setParameterValue("RP_ReportBank","ALL"); 
//reportContext.setParameterDisplayText("RP_ReportBank","ALL"); 
 
//reportContext.setPersistentGlobalVariable("debugMessage", "Bank Query: " + this.queryText); 
printWriter.close();]]></method> 
<property name="queryText"> SELECT 0 as SORTORDER, 'ALL' as BANKID FROM sysibm.sysdummy1 
union 
( 
select distinct 1 as SORTORDER, BANKID as BANKID 
from DAILYRETURNACTIVITY as DAILYRETURNACTIVITY 
where NOT BANKID IS NULL 
and NOT BANKID = '' 
--{timeSelectCondition} 
 
) 
order by SORTORDER, BANKID 
</property> 
</oda-data-set> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="Return_Activity" id="1258"> 
<structure name="cachedMetaData"/> 
<property name="dataSource">PV</property> 
<method name="beforeOpen"><![CDATA[importPackage(Packages.org.eclipse.birt.report.model.api); 
importPackage(Packages.org.eclipse.birt.report.model.api.elements); 
importPackage(Packages.com.ibm.icu.util); 
importPackage(Packages.org.eclipse.birt.data.engine.api); 
 
 
try { 
// var reportFI; 
var reportBank; 
var reportTR; 
//var reportCustomer; 
 
 
// --{fiSelectCondition} 
 
// --{bankSelectCondition} 
reportBank = reportContext.getParameterValue("RP_Bank"); 
if(reportBank==null || reportBank=="") { 
reportBank = reportContext.getParameterValue("RP_ReportBank"); 
} 
if(reportBank.constructor.toString().indexOf("Array") != -1) { 
if(reportBank!=null && reportBank.length!=0 
&& reportBank[0]!=null && reportBank[0]!="ALL" && reportBank[0]!="") 
{ 
//multi-select 
var index; 
var reportBanks = "'" + reportBank[0] + "'"; 
for(index=1;index<reportBank.length;index++) { 
reportBanks = reportBanks + ",'" + reportBank[index] + "'"; 
} 
this.queryText = this.queryText.replace("--{bankSelectCondition}", 
"and BANKID in (" + reportBanks + ") "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
} else if(reportBank!=null && reportBank.length!=0 && reportBank!="ALL") { 
//in the development environment this returns a single select 
this.queryText = this.queryText.replace("--{bankSelectCondition}", 
"and BANKID = '" + reportBank + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
 
//--{banktrSelectCondition} 
//multi-select 
reportTR = reportContext.getParameterValue("RP_BankTR"); 
if(reportTR==null || reportTR=="") { 
reportTR = reportContext.getParameterValue("RP_ReportBankTR"); 
} 
//reportContext.setPersistentGlobalVariable("debugMessage", reportTR + "Constructor: " + reportTR.constructor); 
//in the development environment the parameter seems to be passed as a string 
//instead of an array of strings. Skip it if not an array. 
if(reportTR.constructor.toString().indexOf("Array") != -1) { 
if(reportTR!=null && reportTR.length!=0 && reportTR[0]!="ALL") 
{ 
//multi-select 
var index; 
var reportTRs = "'" + reportTR[0] + "'"; 
for(index=1;index<reportTR.length;index++) { 
reportTRs = reportTRs + ",'" + reportTR[index] + "'"; 
} 
this.queryText = this.queryText.replace("--{banktrSelectCondition}", 
"and BANKTR in (" + reportTRs + ") "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
} else if(reportTR!=null && reportTR.length!=0 && reportTR!="ALL") { 
this.queryText = this.queryText.replace("--{banktrSelectCondition}", 
"and BANKTR = '" + reportTR + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
 
 
//--{timeSelectCondition} 
var start = reportContext.getParameterValue("RP_StartDate").toString(); 
var end = reportContext.getParameterValue("RP_EndDate").toString(); 
this.queryText = this.queryText.replace("--{timeSelectCondition}", 
" and BUSINESSDATE between '" + start + 
"' and '" + end + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
 
//--{SummaryLevel} 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly") { 
this.queryText = this.queryText.replace("BUSINESSDATE as BUSINESSDATE", 
"YEAR(BUSINESSDATE) as BUSINESSDATE"); 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} else if(reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("BUSINESSDATE as BUSINESSDATE", 
 
"CASE " + 
"WHEN MONTH(BUSINESSDATE) between 1 and 3 " + 
"then YEAR(BUSINESSDATE) || '-Q1' " + 
"WHEN MONTH(BUSINESSDATE) between 4 and 6 " + 
"then YEAR(BUSINESSDATE) || '-Q2' " + 
"WHEN MONTH(BUSINESSDATE) between 7 and 9 " + 
"then YEAR(BUSINESSDATE) || '-Q3' " + 
"ELSE YEAR(BUSINESSDATE) || '-Q4' " + 
"END as BUSINESSDATE"); 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} else if(reportSumLevel=="Monthly") { 
this.queryText = this.queryText.replace("BUSINESSDATE as BUSINESSDATE", 
"CONCAT(CONCAT(YEAR(BUSINESSDATE),'-')," + 
"LPAD(MONTH(BUSINESSDATE),2,'0'))" + 
" as BUSINESSDATE"); 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} else if(reportSumLevel=="Weekly") { 
this.queryText = this.queryText.replace("BUSINESSDATE as BUSINESSDATE", 
"BUSINESSDATE - " + 
"(DAYOFWEEK(BUSINESSDATE) - 1) days as BUSINESSDATE "); 
} else { //Daily is the default 
// 
 
} 
// --{networkSelectCondition} 
var reportNetwork = reportContext.getParameterValue("RP_ReportNetwork"); 
if(reportNetwork!=null && reportNetwork!="" && reportNetwork!="ALL" && reportNetwork !="S") 
{ 
this.queryText = this.queryText.replace("--{networkSelectCondition}", 
"and ENDPOINT = '" + reportNetwork + "'"); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
 
if(reportNetwork!=null && reportNetwork!="" && reportNetwork!="ALL" && reportNetwork =="S" ) 
if(reportNetwork ="S") 
{ 
this.queryText = this.queryText.replace("--{networkSelectCondition}", 
"and ENDPOINT in ('F','E ')"); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
 
 
 
 
} catch(e){ 
//replace the query so that the user doesn't get more info than they are entitled to 
this.queryText = "select 'error' as PLATFORMID," + 
"'error' as FIID," + 
"'error' as BANKID, " + 
"'error' as BANKTR, " + 
"'error' as BUSINESSDATE," + 
"0 as ORIGINATEDTXNCOUNT, 0.0 as ORIGINATEDCREDITAMOUNT, 0.0 as ORIGINATEDDEBITAMOUNT," + 
"0 as RECEIVEDTXNCOUNT, 0.0 as RECEIVEDCREDITAMOUNT, 0.0 as RECEIVEDDEBITAMOUNT " + 
"FROM sysibm.sysdummy1"; 
reportContext.setPersistentGlobalVariable("errorMessage", 
"An exception occurred while preparing query Forward_Activity: " + 
e.message); 
 
//throw "An exception occured while setting up query Forward_Activity: " + e.message; 
} 
 
//reportContext.setPersistentGlobalVariable("debugMessage", this.queryText);]]></method> 
<property name="queryText">SELECT DRA.REGION as PLATFORMID, 
DRA.FINANCIALINSTID as FIID, 
DRA.BANKID as BANKID, 
DRA.BANKTR as BANKTR, 
DRA.BUSINESSDATE as BUSINESSDATE, 
DRA.SEC as SEC , 
DRA.RETURNREASON as RETURNREASON, 
DRA.CREDITCOUNT as CREDITCOUNT, 
DECIMAL(DRA.CREDITAMOUNT) as CREDITAMOUNT , 
DRA.DEBITCOUNT as DEBITCOUNT , 
DECIMAL(DRA.DEBITAMOUNT) as DEBITAMOUNT, 
NRRC.LONGDESCRIPTION as LONGDESCRIPTION 
FROM DAILYRETURNACTIVITY DRA , NACHARETURNREASONCODES NRRC 
WHERE TRANSACTIONTYPE = 'R' 
AND DRA.RETURNREASON = NRRC.RXXCODE 
AND NRRC.UNAUTHORIZEDINDICATOR ='U' 
 
--{bankSelectCondition} 
--{banktrSelectCondition} 
 
--{timeSelectCondition} 
--{networkSelectCondition} 
 
 
</property> 
</oda-data-set> 
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="TRs" id="2609"> 
<structure name="cachedMetaData"/> 
<property name="dataSource">PV</property> 
<method name="beforeOpen"><![CDATA[try { 
var banktr = reportContext.getParameterValue("RP_BankTR"); 
if(banktr!=null && banktr!="") { 
//restrict to customer 
//replace the entire query 
this.queryText = "select '" + banktr + "' as BANKTR FROM sysibm.sysdummy1"; 
} else { 
//var reportRegion; 
//var reportFI; 
var reportBank; 
var reportTR; 
//var reportCustomer; 
 
 
 
// --{fiSelectCondition} 
 
// --{bankSelectCondition} 
reportBank = reportContext.getParameterValue("RP_Bank"); 
if(reportBank==null || reportBank=="") { 
reportBank = reportContext.getParameterValue("RP_ReportBank"); 
} 
 
if(reportBank!=null && reportBank.constructor.toString().indexOf("Array") != -1){ 
//if(reportBank.constructor.toString().indexOf("Array") != -1) { 
if(reportBank!=null && reportBank.length!=0 
&& reportBank[0]!=null && reportBank[0]!="ALL" && reportBank[0]!="") 
{ 
//multi-select 
var index; 
var reportBanks = "'" + reportBank[0] + "'"; 
for(index=1;index<reportBank.length;index++) { 
reportBanks = reportBanks + ",'" + reportBank[index] + "'"; 
} 
this.queryText = this.queryText.replace("--{bankSelectCondition}", 
"and BANKID in (" + reportBanks + ") "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
//} 
} else if(reportBank!=null && reportBank.length!=0 && reportBank!="ALL") { 
//in the development environment this returns a single select 
this.queryText = this.queryText.replace("--{bankSelectCondition}", 
"and BANKID = '" + reportBank + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
 
//--{banktrSelectCondition} 
//multi-select 
reportTR = reportContext.getParameterValue("RP_BankTR"); 
if(reportTR==null || reportTR=="") { 
reportTR = reportContext.getParameterValue("RP_ReportBankTR"); 
} 
//reportContext.setPersistentGlobalVariable("debugMessage", reportTR + "Constructor: " + reportTR.constructor); 
//in the development environment the parameter seems to be passed as a string 
//instead of an array of strings. Skip it if not an array. 
 
if(reportTR!=null && reportTR.constructor.toString().indexOf("Array") != -1 ){ 
//if(reportTR.constructor.toString().indexOf("Array") != -1) { 
if(reportTR!=null && reportTR.length!=0 
&& reportTR[0]!="ALL" && reportTR[0]!="") 
{ 
//multi-select 
var index; 
var reportTRs = "'" + reportTR[0] + "'"; 
for(index=1;index<reportTR.length;index++) { 
reportTRs = reportTRs + ",'" + reportTR[index] + "'"; 
} 
this.queryText = this.queryText.replace("--{banktrSelectCondition}", 
"and BANKTR in (" + reportTRs + ") "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
//} 
} else if(reportTR!=null && reportTR.length!=0 && reportTR!="ALL") { 
this.queryText = this.queryText.replace("--{banktrSelectCondition}", 
"and BANKTR = '" + reportTR + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
 
 
//--{timeSelectCondition} 
var start = reportContext.getParameterValue("RP_StartDate").toString(); 
var end = reportContext.getParameterValue("RP_EndDate").toString(); 
this.queryText = this.queryText.replace("--{timeSelectCondition}", 
" and BUSINESSDATE between '" + start + 
"' and '" + end + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
} catch(e) { 
this.queryText = "select 'Exception!' as BANKTR FROM sysibm.sysdummy1"; 
} 
reportContext.setParameterValue("RP_ReportBank","ALL"); 
reportContext.setParameterDisplayText("RP_ReportBank","ALL"); 
//reportContext.setPersistentGlobalVariable("debugMessage", "Bank Query: " + this.queryText);]]></method> 
<property name="queryText"> SELECT 0 as SORTORDER, 'ALL' as BANKTR FROM sysibm.sysdummy1 
union 
( 
select distinct 1 as SORTORDER, BANKTR as BANKTR 
from DAILYRETURNACTIVITY as DAILYRETURNACTIVITY 
where NOT BANKTR IS NULL 
and NOT BANKTR = '' 
--{bankSelectCondition} 
--{timeSelectCondition} 
 
) 
order by SORTORDER, BANKTR 
</property> 
</oda-data-set> 
</data-sets> 
<styles> 
<style name="crosstab" id="4"> 
<property name="borderBottomColor">#CCCCCC</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
<style name="crosstab-cell" id="5"> 
<property name="borderBottomColor">#CCCCCC</property> 
<property name="borderBottomStyle">solid</property> 
<property name="borderBottomWidth">1pt</property> 
<property name="borderLeftColor">#CCCCCC</property> 
<property name="borderLeftStyle">solid</property> 
<property name="borderLeftWidth">1pt</property> 
<property name="borderRightColor">#CCCCCC</property> 
<property name="borderRightStyle">solid</property> 
<property name="borderRightWidth">1pt</property> 
<property name="borderTopColor">#CCCCCC</property> 
<property name="borderTopStyle">solid</property> 
<property name="borderTopWidth">1pt</property> 
</style> 
<style name="BackgroundBlue" id="779"> 
<property name="backgroundColor">#4B6987</property> 
</style> 
<style name="BackgroundLightGrey" id="

JasonW

can you attach the report instead of posting the xml? If you are trying to get a request variable are you using reportContext.getHttpServletRequest().getParameter("parmname");

Jason

Demolisher

<blockquote class='ipsBlockquote' data-author="'JasonW'" data-cid="78188" data-time="1307561281" data-date="08 June 2011 - 12:28 PM">
can you attach the report instead of posting the xml? If you are trying to get a request variable are you using reportContext.getHttpServletRequest().getParameter("parmname"); 
 
Jason </blockquote>
 
Hi, 
 
I am getting error while uploading the file, so i thought of posting the XML. 
we are having one reports.jsp 
In which we are taking the values from the cookie 
 
for(int i=0; i<cookies.length; i++) { 
Cookie cookie = cookies; 
if (cookie.getName().equals("PV_USERID")) { 
userID = cookie.getValue(); 
} 
if (cookie.getName().equals("PV_BANKID")) { 
BankID = cookie.getValue(); 
} 
if (cookie.getName().equals("COOKIE_USER_INTERNAL_EXTERNAL")) { 
Internal_External = cookie.getValue(); 
} 
if (cookie.getName().equals("PV_CUSTOMERID")) { 
CustomerID = cookie.getValue(); 
} 
if (cookie.getName().equals("PV_SITEID")) { 
SiteID = cookie.getValue(); 
} 
if (cookie.getName().equals("PV_FIID")) { 
FIID = cookie.getValue(); 
} 
} 
 
and then forwarding the same. 
<jsp:forward page="<%=forwardPage %>"> 
<jsp:param name="RP_User" value="<%=userID %>"/> 
<jsp:param name="RP_Bank" value="<%=BankID %>"/> 
<jsp:param name="RP_Customer" value="<%=CustomerID %>"/> 
<jsp:param name="RP_FI" value="<%=FIID %>"/> 
<jsp:param name="RP_StartDate" value="<%=StartDate %>"/> 
<jsp:param name="RP_EndDate" value="<%=EndDate %>"/> 
<jsp:param name="RP_Historical_Range_Start_Date" value="<%=StartDate %>"/> 
<jsp:param name="RP_Historical_Range_End_Date" value="<%=EndDate %>"/> 
<jsp:param name="RP_Internal_External" value="<%=Internal_External %>"/> 
<jsp:param name="HP_BusinessEntityType" value="<%=BusinessEntityType %>"/> 
<jsp:param name="HP_BusinessEntityID" value="<%=BusinessEntityID %>"/> 
<jsp:param name="RP_Log_Path" value="<%=LogPath %>"/> 
<jsp:param name="RP_JNDI_Name_SCDC" value="<%=JNDIName_SCDC %>"/> 
<jsp:param name="RP_JNDI_Name_SCDCHIST" value="<%=JNDIName_SCDCHIST %>"/> 
<jsp:param name="RP_JNDI_Name_PV" value="<%=JNDIName_PV %>"/> 
<jsp:param name="RP_Heading_Line_1" value="<%=headingLine1 %>"/> 
<jsp:param name="RP_Heading_Line_2" value="<%=headingLine2 %>"/> 
<jsp:param name="RP_Heading_Line_3" value="<%=headingLine3 %>"/> 
</jsp:forward> 
 
other operartiions are also involved in the same.All the param name starting with the RP_*** are the parameters used in the Report. and we are trying to get those parameters in the following manner in the report. 
 
reportBank = reportContext.getParameterValue("RP_Bank"); 
 
Actaully we are checking the condition that if the parameter is present in the cookie then it should get picked up else all the value regarding the same(Bank in this case) should be picked up. 
 
// --{bankSelectCondition} 
reportBank = reportContext.getParameterValue("RP_Bank"); 
if(reportBank==null || reportBank=="") { 
reportBank = reportContext.getParameterValue("RP_ReportBank"); 
} 
 
if(reportBank!=null &&amp reportBank.constructor.toString().indexOf("Array") != -1){ 
//if(reportBank.constructor.toString().indexOf("Array") != -1) { 
if(reportBank!=null && reportBank.length!=0 
&& reportBank[0]!="ALL" && reportBank[0]!="") 
{ 
//multi-select 
var index; 
var reportBanks = "'" + reportBank[0] + "'"; 
for(index=1;index<reportBank.length;index++) { 
reportBanks = reportBanks + ",'" + reportBank[index] + "'"; 
} 
this.queryText = this.queryText.replace("--{bankSelectCondition}", 
"and BANKID in (" + reportBanks + ") "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
} 
//} 
} else if(reportBank!=null && reportBank.length!=0 && reportBank!="ALL") { 
//in the development environment this returns a single select 
this.queryText = this.queryText.replace("--{bankSelectCondition}", 
"and BANKID = '" + reportBank + "' "); 
var reportSumLevel = reportContext.getParameterValue("RP_SummaryLevel"); 
if(reportSumLevel=="Yearly" || reportSumLevel=="Monthly" || reportSumLevel=="Quarterly") { 
this.queryText = this.queryText.replace("DAILYRETURNACTIVITY", "MONTHLYRETURNACTIVITY"); 
} 
}

JasonW

I am not certain if this will help but in your jsp page that forwards to the viewer you could check your parameters and if you want the cascaed parameter in the report to not be shown add this to the url:
&__parameterpage=false

Jason