Showing results for 
Search instead for 
Did you mean: 

Excel Render does not display sub datasets and PDF render crashes.


Excel Render does not display sub datasets and PDF render crashes.

 The current excel render dosen't take care of sub-datasets even though they show up in the xml of the report content. 


Is there a way to override the current Excel render and write our own? If not then where is the code for the current excel render?  Below are the details:



The Analysis Report


Modeling Score Card.PNG

When it is exported to Excel it does not display values for the items in the sub dataset.

Modeling Score Card excel.PNG


In order to display the icons in the cell we created out own render.  Below is a code snipit.


Adding sub dataset to parent with render


Dataset subSet = null;


if (reportType.equals(ReportType.FM_MODELING_SCORE_CARD)) {

subSet = c.calculateObjectiveIndicatorForProject(obj, objectsByMetaClass, excluded);

} else {

subSet = c.calculateObjectiveIndicatorForObject(obj, describing_diagrams, excluded);



if (subSet != null) {


int indicatorId = reportContent.addDataset(subSet);

View indicatorView = new View(indicatorId, false, true);



dataset.addItem(indicatorView, (x + 1) + "," + y);


} else {

Text item = new Text("", false);

dataset.addItem(item, (x + 1) + "," + y);





Creating the sub-dataset.

percentage = deliverables.getPercentageCompleteForObject(obj);


String indicatorId = getIndicatorId(percentage);


if (!indicatorId.equals("")) {

MegaObject i = root.getObjectFromID(indicatorId);


subSet.addItem(new MegaObjectProperty(i.megaField(), "~Z20000000D60[Short Name]"), "1,1");


isApplicable = true;




return subSet;


}else if(percentage == -1){

subSet.addItem(new Text("N/A", false), "1,1");

isApplicable = false;

return subSet;




Tags (4)