Dynamic Row Insert into a Table

Hi,<br />
<br />
New to BIRT and the Forum.<br />
<br />
I know this topic has been discussed a couple of times.<br />
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/16624-how-to-add-a-detail-row-to-tablehandle/'>16624-how-to-add-a-detail-row-to-tablehandle</a><br />
<a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/17109-rowoperationparameters/'>17109-rowoperationparameters</a><br />
<br />
Unfortunately I can't seem to get my rows to insert. My table is named configTable and I am inserting data from a data set retrieved from a DB. As the data from the data set is inserted into the rows of the table, (withtin the Row's onCreate event) I'm evaluating the data for specific criteria. When my condition is met I'm trying to insert a row but I'm getting the exception <br />
<br />
"Wrapped org.eclipse.birt.report.model.api.elements.SemanticError: The insert operation on the element "configTable" is forbidden."<br />
<br />
//within Report Design initialize event<br />
importPackage (Packages.org.eclipse.birt.report.model.api); <br />
<br />
//within configTable row onCreate event<br />
configTable = reportContext.getReportRunnable().designHandle.getDesignHandle().findElement("configTable");<br />
elementFactory = reportContext.getReportRunnable().designHandle.getElementFactory();<br />
row = this.getRowData();<br />
<br />
if ( condition ) {<br />
for ( x=0; x < rowsToCreate; x++ ) {<br />
rowParm = new RowOperationParameters(2, -1, tableRowCount);<br />
configTable.insertRow(rowParm);<br />
//myNewRow = configTable.getDetail().get(1);<br />
//tblCell = myNewRow.getCells().get(12);<br />
//label = elementFactory.newLabel("tblCell");<br />
//label.setText("test");<br />
//tblCell.getContent().add(label);<br />
<br />
tableRowCount++;<br />
} <br />
} <br />
<br />
tableRowCount is created and initialized in the configTable onPrepare event and is just a counter to help me keep track of where I am (there's probably a better way to manage that - I just haven' found it yet). If I understand the RowOperationParameters parameters, the third parameter is the nth detail row index to be added to the table? When I change the third parameter to anything greater that 1 I am getting the exception which makes me think I'm not using RowOperationParameters correctly.<br />
<br />
Any help or suggstions are appreciated. Thanks in advance,<br />
Rich

Find more posts tagged with

Comments

mwilliams

I'm pretty certain you have to add the row in the beforeFactory script of the report design. I think the onCreate event is too late. I'll let you know if I find out differently though.

Tilley

Thanks for the response - it gives me something to consider. Unfortunately since the ReportDesign beforeFactory fires before the onFetch events of the dataset I'm using for the configTable, it doesn't seem like I will be able to eval the dataset to create the table rows. Ugh - back to the drawing board...

Thanks again,
Rich

mwilliams

Can you explain more about what you're trying to accomplish? How do the rows of each dataSet relate? Can you show samples of the data from both?

Tilley

Thanks for sticking with me on this.

Background:
The users I'm designing the report for have an existing report (excel spreadsheet - manually maintained) that they've asked me to reproduce. It basically lists the parts that can be used to build a larger assembly. Within our manufacturing resource planning, based on part availability, alternate parts can be used as substitutes to the preferred part. This report identifies the qualified alternate parts. The relationship between the preferred part to the alternate is 1 to many, however, it is common to have no alternate part.

Layout:
The report is broken into 2 main sections (side by side in the report): Section 1 is the primary part with attribute columns detailing the nomenclature, stock number, qty required, etc. Section 2 is the alternate part with the similar attribute data as the primary part.

Design:
I have 2 data sets (coming from an Oracle db), called Config_Detail and Alt_Config_Detail. I have hidden tables for each data set at the top of my report. As each row in the tables are created (onCreate event), I'm adding these parts and their attributes to 2 global hashmaps (one for primary parts and one for alternate parts) for use in the 2 main sections of the report.

As for the 2 sections of the report ... its made up of one table with a header row and a detail row. The detail row contains 12 columns. The first 6 columns contain Data items which are bound to the Config_Detail dataset. The second 6 columns contain empty labels (for the alt. part number data). My approach is to evaluate the hashmap data for each primary part (within each Row onCreate event) and determine how many alternative parts exist. If an alt. part exists I'm updating the alt labels with the data from the alt. hashmap.

Problem:
My problem occurs only when there is more than one alternate part associated with a single primary part. Since the configTable essentially reflects a 1-to-0..1 association between primary part and alt. part, I need to dynamically create a row that has no values for the primary part and but contains the details of the nth alt. part. Unfortunately, I apologize, I can't submit the report to you for consideration - it currently contains company sensitive data.

Problem Example (consider the ___ as whitespace:
Primary Part 1 | Alternate Part 1.1
____________ | Alternate Part 1.2
____________ | Alternate Part 1.3
Primary Part 2 | Alternate Part 2.1
Primary Part 3 |
Primary Part 4 | Alternate Part 4.1
____________ | Alternate Part 4.2
____________ | Alternate Part 4.3
____________ | Alternate Part 4.4

I originally tried to combine the Config_Detail and Alt_Config_Detail data sets into one query but based on table structures there was no way to join that data into one query.

One last thought as I'm writing ... since the first 6 columns are bound to the data set, is the report melting down during the row create commands because of the data binding? Is BIRT saying that it can't create a row dynamically because it can't resolve where in the data set to bind the new dynamic row to?

Thanks again for your time. Any thoughts or suggestions are appreciated,
Rich

Hans_vd

<blockquote class='ipsBlockquote' ><p>there was no way to join that data into one query</p></blockquote>
What was the problem then?<br />
Because joining them together in the query would make the setup of the report much easier.<br />
<br />
Regards<br />
Hans

Tilley

I completely agree with you Hans - I wish I knew of a way to produce one query. I spent quite a bit of time in the early stages of this report's development trying to produce a single query to return a result set fitting the table layout I needed. Based on the way the data is related in the DB, I was unable to join (inner, outer, or both) the tables in a way to produce the single data set. I'm thinking I may be able to use a Ref Cursor to collect the data so that I could use it for the report. I haven't worked with BIRT and Ref Cursors yet and I'm trying to stick with the scripting design approach - I just feel like what I'm trying to accomplish is possible. I'm probably missing one or 2 pieces of the puzzle. Either that or, following that analogy, I'm trying to force the pieces together from two different puzzles

I appreciate the feedback - Regards,
Rich

Hans_vd

Of course I have no idea of the complexity of your data model, but in my opinion, if you can do the joining in a script, you certainly can do it in the query too.

You would indeed need to perform an outer join.

Regards
Hans

Sai krishna

<div>Hello michale,</div>
<div> </div>
<div>I have issue with the Crosstab.</div>
<div> </div>
<div>Query: I have a crosstab which prints 2 columns. 1st column is the name and 2nd one is the value per date. My query is explained below:</div>
<div> </div>
<div>Consider the crosstab as :</div>
<div>Name Nov</div>
<div>a 1</div>
<div>b 2</div>
<div>c 3</div>
<div>d 4</div>
<div> </div>
<div>Now i have to add a new row in between the above rows. Where that row is the calcuation of the 2 above rows.</div>
<div> </div>
<div>Name Date</div>
<div>a 1</div>
<div>b 2</div>
<div>c+d 7</div>
<div>c 3</div>
<div>d 4</div>
<div> </div>
<div>I want to display the crosstab like this. How to add that row which contains the calculated data on particular rows(not for all rows). I am new to this BIRT. Could you please help me from this issue.</div>
<div> </div>
<div>Sorry for my English.</div>
<div> </div>
<div>Thanks a lot in advance.</div>
<div>Sai Krishna</div>