Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Parameter "Null Value"
LetsBIRT
When i Dont check the Is Required on the Parameter.
and select the default as "blank value". Why does it still show the "Null value" in the list?
Is there a way to get rid of it.
Thanks...LB
Find more posts tagged with
Comments
mwilliams
LB,
What you're probably gonna want to do is to make your own parameter page with a JSP file and pass the parameters to the report design. This way you can make it look how you want and can handle null values any way you'd like.
LetsBIRT
any sample available will really help.
Thanks
mwilliams
LB,<br />
<br />
This should help get you started:<br />
<br />
<a class='bbc_url' href='
http://birtworld.blogspot.com/2007/09/22-birt-tag-library-building-custom.html'>http://birtworld.blogspot.com/2007/09/22-birt-tag-library-building-custom.html</a>
;
LetsBIRT
Thank you.
niranjand
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="36157" data-time="1219256034" data-date="20 August 2008 - 11:13 AM"><p>
LB,<br />
<br />
<br />
This should help get you started:<br />
<br />
<br />
<a class='bbc_url' href='
http://birtworld.blogspot.com/2007/09/22-birt-tag-library-building-custom.html'>http://birtworld.blogspot.com/2007/09/22-birt-tag-library-building-custom.html</a><br
/></p></blockquote>
<br />
Hello,<br />
I am new to BIRT and am currently working with a JDBC data set for a BIRT report - which has a a few parameters in SQL e.g.:<br />
<br />
WHERE USERS.user_id = ?<br />
<br />
And the parameter value needs to be provided by user at runtime via a report parameter - which a drop-down list containing all users (with id as selected value).<br />
<br />
In the report parameter list, the first value (automatically inserted by BIRT) is "Null value". I need to retain it allow user to not filter data based on this parameter/ attribute. But when user selects "Null value" for this parameter, I get an error stating "cannot set prepared Statement null value. SQL Error#1: Unsupported feature". <br />
How can I take care of this scenario? Any help much appreciated.
mwilliams
So, you want to be able to have a value that gives them "all" as a selection so that this field is not limited in this case?
niranjand
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="81820" data-time="1314124067" data-date="23 August 2011 - 11:27 AM"><p>
So, you want to be able to have a value that gives them "all" as a selection so that this field is not limited in this case?<br /></p></blockquote>
Yes, you stated it correctly. When user selects "Null value"; I want to treat it as the result does not need to be filtered on that parameter/ column.
lrnrit
<blockquote class='ipsBlockquote' data-author="'niranjand'" data-cid="81892" data-time="1314250144" data-date="24 August 2011 - 10:29 PM"><p>
Yes, you stated it correctly. When user selects "Null value"; I want to treat it as the result does not need to be filtered on that parameter/ column.<br /></p></blockquote>
<br />
<br />
Hi ,<br />
<br />
Use NVL in SQL QUERY LIKE THIS :<br />
<br />
<br />
WHERE USERS.user_id = nvl(?,USERS.user_id)<br />
<br />
<br />
it will give all values when you will not enter any value ,<br />
Let me know if it works for you.<br />
<br />
lrnit
niranjand
<blockquote class='ipsBlockquote' data-author="'lrnrit'" data-cid="81895" data-time="1314256583" data-date="25 August 2011 - 12:16 AM"><p>
Hi ,<br />
<br />
Use NVL in SQL QUERY LIKE THIS :<br />
<br />
<br />
WHERE USERS.user_id = nvl(?,USERS.user_id)<br />
<br />
<br />
it will give all values when you will not enter any value ,<br />
Let me know if it works for you.<br />
<br />
lrnit<br /></p></blockquote>
<br />
<br />
It should have certainly occurred to me (to use nvl() function) - guess age is catching up on me.....<br />
I tried to change my report def per this suggestion. When I select a value for the parameter, it works okay. But when I select a "Null value" from the report parameter list; it still bombs with error message from attached screenshot (error.png). Also attached is the stacktrace I get from the error message pop-up (error.txt). Anything else that I am missing?
lrnrit
<blockquote class='ipsBlockquote' data-author="'niranjand'" data-cid="82242" data-time="1314948993" data-date="02 September 2011 - 12:36 AM"><p>
It should have certainly occurred to me (to use nvl() function) - guess age is catching up on me.....<br />
I tried to change my report def per this suggestion. When I select a value for the parameter, it works okay. But when I select a "Null value" from the report parameter list; it still bombs with error message from attached screenshot (error.png). Also attached is the stacktrace I get from the error message pop-up (error.txt). Anything else that I am missing?<br /></p></blockquote>
<br />
<br />
hi ,<br />
<br />
what version of birt ur using? Can you upload the rpt file so i could take a look?<br />
<br />
thanks<br />
<br />
lrnit
bcs0629
Hi, I see earlier in this thread there was a link to the BIRT Tag Library for 2.2, does 2.6.2 have the same functionality? I went through the example there and tried to use it with my version of BIRT but to no avail. I can't seem to find any support for doing this in 2.6.2
Thanks,
Bryan
mwilliams
Bryan,
The tag library stuff should be the same. I don't believe that anything has changed with that. What issue are you having?
