cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

FM_MEGA
Super Contributor

 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);

 

indicatorView.addRenderer(INDICATOR_RENDER);

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;

 

i.release();

 

return subSet;

 

}else if(percentage == -1){

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

isApplicable = false;

return subSet;

}

 

 

0 Replies