Conditional SQL statement and parameters

I have a parameter called fromSchedDate. Based on what is entered, the SQL statement does 1 of two things. Below is the statement. 
 
The else works just fine. But if the If condition is met, nothing shows. I've pulled the statement into my SQL database and it works just fine. I must be missing something. Any help someone comes up with would be appreciated. 
 
I've attached the fromSchedDate setup below, in case it is relevant.

Find more posts tagged with

Comments

mwilliams

If you comment out the if/else statement, except for the code within the "if" statement, does it work then?

Hans_vd

Hi, 
 
<blockquote class='ipsBlockquote' ><pre class='_prettyXprint _lang-auto _linenums:0'>if(fromDate == "1900-01-01")</pre></blockquote>
In this line you are evaluating a date variable against a string. You can't do that. 
 
Take a look at this few lines of code, the date parameter value is converted to a string that has the same format as the literal: 
<pre class='_prettyXprint _lang-auto _linenums:0'>importPackage( Packages.java.text );
var myDate = new SimpleDateFormat("yyyy-MM-dd", reportContext.getLocale());
if (myDate.format(params["dateParam"].value)=="2012-01-01") {
// do if stuff
}
else {
// do else stuff
}</pre>
 
As you are not really using the default date value, an even better solution could be to make the parameter optional and remove the default value. You can then check in your code if the parameter is empty by doing: 
<pre class='_prettyXprint _lang-auto _linenums:0'>if (params["dateParam"]==null) {
// do if stuff</pre>
 
 
Hope this helps

TheShadraq

Okay. Thanks guys. I will work it and let you know what I come up with.

TheShadraq

Alright. I have tackled this from a number of ways and the only way I can get through this without an error is to simply change the parameter to Data type: String and use null instead of my turn-of-the-century date. 
 
Everything works just as expected if the dates are not null. The report shows blank if the dates are null. As per Mike's suggestion, I tested the report on simply the If statement as well and it runs just fine. The issue still seems to be hanging on my If. 
 
I even went through and removed all my bisibility entries in the Layout, just to be sure 
 
Any ideas?

TheShadraq

To get this to work, I employed Hans' idea of making the date not required. This allowed for a ligitimate null value. 
 
Thanks again for you help you guys.