how to use IsEmpty()?

[shivareddyk]

hi,

how to use IsEmpty()? when we are defining Fields in Crosstab.

(          i am using like this ,but still i am getting error in crosstab

IIf(IsEmpty(Rows[PARTICULARS][Level 3]),null,Rows[PARTICULARS][Level 3])    )

 

erroroutput as: Error filling print... Invalid field mapping "IIf(IsEmpty(Rows[PARTICULARS][Level 3]),null,Rows[PARTICULARS][Level 3])".
line 1:1: unexpected token: IIf  net.sf.jasperreports.engine.JRRuntimeException: Invalid field mapping "IIf(IsEmpty(Rows[PARTICULARS][Level 3]),null,Rows[PARTICULARS][Level 3])".      at net.sf.jasperreports.olap.JROlapDataSource.init(JROlapDataSource.java:313)      at net.sf.jasperreports.olap.JROlapDataSource.<init>(JROlapDataSource.java:121)      at net.sf.jasperreports.olap.JRMondrianDataSource.<init>(JRMondrianDataSource.java:41)      at net.sf.jasperreports.olap.JRMondrianQueryExecuter.createDatasource(JRMondrianQueryExecuter.java:85)      at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:681)      at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:601)      at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1247)      at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:877)      at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:119)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:435)      at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:271)      at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:955)      at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)      at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) 
Print not filled. Try to use an EmptyDataSource...

 

let us know any one pls........

 

Post Edited by shivareddyk at 09/24/2010 05:47

[shivareddyk]

any idea to fix the above issue?