Description Sasikala 2010-10-15 00:08:07 EDT

Build Identifier: 2.6.1 , 2.5.2, 2.3.2

I have to load  the first parameter of the cascade based on the session username value.

I have used <method name="beforeOpen"><![CDATA[var username;]]>var username =reportContext.getHttpServletRequest().getSession().getAttribute("username");</method>

and 

 <list-property name="parameters">
                 <structure>
                    <property name="name">param_1</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">2</property>
                    <expression name="defaultValue">username</expression>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
			</list-property>

and 
<property name="queryText">
select c.country_name, s.state_name from country c, state s where s.country_id =c.country_id and username = ?	
</property>


But the value is not getting passed. Is there any way to pass the value

Reproducible: Always

Steps to Reproduce:
I have to load  the first parameter of the cascade based on the session username value.

I have used <method name="beforeOpen"><![CDATA[var username;]]>var username =reportContext.getHttpServletRequest().getSession().getAttribute("username");</method>

and 

 <list-property name="parameters">
                 <structure>
                    <property name="name">param_1</property>
                    <property name="nativeName"></property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                    <property name="position">2</property>
                    <expression name="defaultValue">username</expression>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
			</list-property>

and 
<property name="queryText">
select c.country_name, s.state_name from country c, state s where s.country_id =c.country_id and username = ?	
</property>


But the value is not getting passed. Is there any way to pass the value