[Unmerge columns in new excel sheet]

i had this sort of problem, when cells are starting at different point in the other row. For example Row 1 had two columns with 10 and 30 width and Row 2 had four columns with width of 10 each. both rows are starting at the same point(left and top). Please note, my report did not multiple sheet like in your requirement. Hope it helps

[How to use subdataset field value in Scriplet]

HI,

I have created a subdataset and using it for filling the crosstab. I need to do some caluclations on subdataset data in my custom scriplet.

When i get try to pull the values using getVariableValue/getFieldValue, I am getting below error. Any help is much appreciated in advance.

leaseexpirations is a feild of subdataset.

When i use:

this.getVariableValue("leaseexpirations");

Caused by: net.sf.jasperreports.engine.JRScriptletException: Variable not found : leaseexpirations 
    at net.sf.jasperreports.engine.JRAbstractScriptlet.getVariableValue(JRAbstractScriptlet.java:128) 
    at com.yieldstar.rms.pub.reports.ExpirationSummaryStatsScriplet.decideRedColor(ExpirationSummaryStatsScriplet.java:13) 
    at Expiration32Summary32Statistics_1358849276434_145563.evaluate(Expiration32Summary32Statistics_1358849276434_145563:220) 
    at net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:190) 
    ... 21 more 

 

 

When i use:

this.getFieldValue("leaseexpirations");

 

Caused by: net.sf.jasperreports.engine.JRScriptletException: Field not found : leaseexpirations 
    at net.sf.jasperreports.engine.JRAbstractScriptlet.getFieldValue(JRAbstractScriptlet.java:114) 
    at com.yieldstar.rms.pub.reports.ExpirationSummaryStatsScriplet.decideRedColor(ExpirationSummaryStatsScriplet.java:14)

 

Kind Regards,

Srihari Gouru

[Scriptlet works in crosstab?]

Can't we use the scriplets in crosstabs now also?