Unable to Get Report to Preview in iReport 5.6.0

[Mictog]

I am having an issue with a pre-designed report on our OHM server when trying to load/edit/correct/render utilizing iReport Designer 5.6.0. 

Some background:  I have a report that i inherited (I have been using Jasper for about 3 months).  The end users would like some modifications to this report; all of which are minor.  I pulled the JRXML file and tried to load it into iReports 5.6.0.   This failed.  After a lot of research I decided to follow an answer where the expert suggested opening a new iReport file and copying and pasting the xml over.  I did this in small segments and found the issue and corrected it.  The report can now be seed in the designer.  Once the report was "visible" I reviewed all of the parameters.  The next step was to compile and see what we could see--Nothing;  The compilation is failing here:

Error filling pring... Error evaluating expression :
     Source text : StringUtils.equalsIgnorCase($P{DbyType}, "ORACLE")       ? "NVL"          : "ISNULL"

Thinking that this is easy enough to fix by just removing the parameter (note:  our server is MSSQL and will never be ORACLE for this system).  I went through and removed this parameter from the the XML.  This did not help.  It just simply asked to have another removed, and another, and another.  Some of these are actually needed.  With that I reverted and set the Parameter Default value to "MSSQL".  This issued a new error: 

Error filling print... Error evaluating expression :
     Source text  : MSSQL  (just a note i also tried this as "MSSQL")

I have exhausted seach engines, including this community, and cannot find an answer which works.  I do have a theory as to the root cause.  it is that "StringUtils.equalsIgnorCase" is the root problem (sidebar:  I am working on my desktop with iReport 5.6.0 and the server is separate and the report will render on the OHM server).  I am looking for a solution and want to really understand what is going on so that when this is experienced again I am ready to resolve it as quickly as possible.

 

Thank you. 

[hozawa]

It seems like a problem that is particular to your environment and to the jrxml file in question. Without the actual jrxml file and more detailed information on your environment, it's not possible to answer your question.