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)
Not displaying null value in layout
Iira
Dear All,
Plz find attached report.
I createdone report(parameter group) filter as text box
ranging from 0 to ZZZZZZZZZ.
However, null values doesn't fall in this range.
Kindly help.
Attached report will make you more clear.
Find more posts tagged with
Comments
mwilliams
Hi Iira,
If you only want to see 0-ZZZZZ, why do you want null values? Or is this a makeshift "All"? I guess one thing you could do would be to dynamically build your where clause based on your parameter values entered. If saying you want 0-ZZZZ means that you want nulls, if you get a 0 for the first value, you could make your where clause bring in everything except what is beyond the last value. If it's not 0, you can build it how you currently have it.
To do this, you'd just leave the where statement off in your dataSet editor and check your parameters and add the necessary where statement in the beforeOpen script with something like:
this.queryText = this.queryText + " where ......"
Iira
<p class='bbc_right'></p><blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="71398" data-time="1292422864" data-date="15 December 2010 - 07:21 AM"><p>
Hi Iira,<br />
<br />
If you only want to see 0-ZZZZZ, why do you want null values? Or is this a makeshift "All"? I guess one thing you could do would be to dynamically build your where clause based on your parameter values entered. If saying you want 0-ZZZZ means that you want nulls, if you get a 0 for the first value, you could make your where clause bring in everything except what is beyond the last value. If it's not 0, you can build it how you currently have it.<br />
<br />
To do this, you'd just leave the where statement off in your dataSet editor and check your parameters and add the necessary where statement in the beforeOpen script with something like:<br />
<br />
this.queryText = this.queryText + " where ......"<br /></p></blockquote>
Iira
It is not clear to me...
Can you provide me one example.
mwilliams
I haven't been able to find a way to make the SQL to include null values when using a where statement. I'll keep looking into it. You could make a checkbox parameter or something that said something like "select all (ignores start/end paramters)" and if that is checked, don't add the where statement.
