Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Crosstab hiding of columns and rows does not reflect when export to excel/pdf
Crosstab hiding of columns and rows does not reflect when export to excel/pdf [message #1222274] Fri, 20 December 2013 03:06
Ben Tot is currently offline Ben Tot
Messages: 1
Registered: December 2013
Junior Member
I have monthyear for column dimension and modelnames for row dimension. I need to display all monthyears and modelnames regardless if a modelname was used for that monthyear. In order to accomplish this, I did outerjoin in my dataset. I was able to accomplish this however, there is an extra blank column and blank row in the generated report. I was able to remove this also by using the following code:

if(cellInst.getDataValue("MONTHYEAR") == ""){
    cellInst.getStyle().setDisplay("none");
}
if(cellInst.getDataValue("MODELDESCRIPTION") == ""){
    cellInst.getStyle().setDisplay("none");
}


Thus, the extra blank column and blank row was removed. However, when I tried to export to excel, the blank column and blank row still shows. When I export to pdf, only the blank column shows.

I even tried this in onRender(), however nothing happens

if(cellInst.getDataValue("MONTHYEAR") == ""){
    reportContext.getDesignHandle().getElementByID(cellInst.getCellID()).setStringProperty("width","0px"); 
}
if(cellInst.getDataValue("MODELDESCRIPTION") == ""){
    reportContext.getDesignHandle().getElementByID(cellInst.getCellID()).setStringProperty("width","0px"); 
}


Please advise.
Previous Topic:Deploying birt in tomcat
Next Topic:No Euro Symbol
Goto Forum:
  


Current Time: Thu Oct 23 16:09:24 GMT 2014

Powered by FUDForum. Page generated in 0.03037 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software