Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
parameter field to be non-mandatory
S.M.
i want the parameter mandatory option to go away.
when i dont select any value from the list it should give all the values present for that report.
is there any way to disable the mandatory option?
please help...
its really very urgent...
BIRT Report Designer Version is 4.2.2
Find more posts tagged with
Comments
Tubal
You can set the parameter to be optional in your parameter properties, and it will no longer be required (the red asterisk will go away).<br />
<br />
Depending on your dataset, you may need to modify your beforeOpen event to change your query if it detects an empty parameter.<br />
<br />
for example:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>if(params["companyName"]==null){
this.queryText = this.queryText.replace("WHERE companyName = ?","");
}</pre>
<br />
To remove your WHERE clause from your query.