nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to bind a dataset to a dataitem in a grid

haglo

I use eclipse 4.4.1, windows 8.1, java 7, birt 4.4.1 and the demo-database of birt.
 
I have a report in which i add a library.
The library has a grid with many dataitems binded to different datasets.
 
How can I add a dataset to a dataitem with java.
I want to make all with java.
 
My code in the moment is
<pre class="_prettyXprint _lang-">
for (Object handleObject : libraryHandleOrder.getComponents()
.getContents()) {
if (handleObject instanceof GridHandle) {
reportDesignHandle.getBody().add(
(DesignElement) ((GridHandle) handleObject)
.copy());
((GridHandle) handleObject).setDataSet(tmpOdaDataSetHandle);

.....

SlotHandle grRows = tmpGridHandle.getRows();
java.util.Iterator rowIterator = grRows.iterator();
while (rowIterator.hasNext()) {
Object rowSlotContents = rowIterator.next();
SlotHandle cellSlot = ((RowHandle) rowSlotContents)
.getCells();
java.util.Iterator cellIterator = cellSlot
.iterator();
while (cellIterator.hasNext()) {
Object cellSlotContents = cellIterator.next();
SlotHandle cellContentSlot = ((CellHandle) cellSlotContents)
.getContent();
java.util.Iterator cellContentIterator = cellContentSlot
.iterator();
while (cellContentIterator.hasNext()) {
Object cellContent = cellContentIterator
.next();
if (cellContent instanceof DataItemHandle) {
((DataItemHandle) cellContent)
.setDataSet(tmpOdaDataSetHandle);
}

}
}
}</pre>
from code above is the following codeimportant, but it don't work at me
<pre class="_prettyXprint _lang-">
if (cellContent instanceof DataItemHandle) {
((DataItemHandle) cellContent).setDataSet(tmpOdaDataSetHandle);
}
</pre>

Find more posts tagged with

Comments

JFreeman

Are you receiving any errors with this code?
 
What is the behavior you are seeing when this is not working?

haglo

I have solved the problem 
the problem was, that there was another Grid in a Cell of the Grid.
 
This is now my working Code 

<pre class="_prettyXprint _lang-">
public void iterateRecursiveThroughGrid(GridHandle gridHandle,
OdaDataSetHandle odaDataSetHandle1, OdaDataSetHandle odaDataSetHandle2) {
try {
gridHandle.setDataSet(odaDataSetHandle1);
SlotHandle grRows = gridHandle.getRows();
java.util.Iterator rowIterator = grRows.iterator();
while (rowIterator.hasNext()) {
// Get RowHandle objects.
Object rowSlotContents = rowIterator.next();
SlotHandle cellSlot = ((RowHandle) rowSlotContents).getCells();
java.util.Iterator cellIterator = cellSlot.iterator();
while (cellIterator.hasNext()) {
Object cellSlotContents = cellIterator.next();
SlotHandle cellContentSlot = ((CellHandle) cellSlotContents)
.getContent();
java.util.Iterator cellContentIterator = cellContentSlot
.iterator();
while (cellContentIterator.hasNext()) {
Object cellContent = cellContentIterator.next();
if (cellContent instanceof GridHandle) {
((GridHandle) cellContent)
.setDataSet(odaDataSetHandle1);
iterateRekursiveThroughGrid((GridHandle) cellContent, odaDataSetHandle1, odaDataSetHandle2);
}
if (cellContent instanceof DataItemHandle) {
((DataItemHandle) cellContent)
.setDataSet(odaDataSetHandle1);
}
if (cellContent instanceof TableHandle) {
((TableHandle) cellContent)
.setDataSet(odaDataSetHandle2);
}
}
}
}
} catch (SemanticException e) {
e.printStackTrace();
}
}
</pre>

JFreeman

Can you check what type of class cellContent is registering as?
Something like: cellContent.getClass().getName();

haglo

With 
<pre class="_prettyXprint _lang-">
if (cellContent instanceof GridHandle) {
System.out.println("GridClassName: " + cellContent.getClass().getName());
}
</pre>
I get:
GridClassName: org.eclipse.birt.report.model.api.GridHandle

JFreeman

I'm glad to hear you got it solved.
Thanks for posting your solution.