Adding dynamic header label

The basic of the report is that I need to create a table with a variable number of columns, this table then needs to be sortable and have the dynamic names for the headers which come from the data.
 
As for the variable number of column in a table I am using something based on this:
 
<a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/files/file/617-add-column-to-table-dynamically/ '>http://developer.actuate.com/community/forum/index.php?/files/file/617-add-column-to-table-dynamically/  </a>(Which has been a huge help!) 
 
The sorting part I think I can figure out. (if not, I'll do have a separate post.)
 
The part I can't get is getting the information for the first row of the data set into the header, not the column names, the actual first row of data. I have tried a variety of possibilities but to no avail. (Again all based off of the above file.)
 
I am probably just missing something or don't know the right words to search for but I haven't located how to do this, even after reviewing some of the java help pages.
 
My latest brain child, which does not work, is this(Note: this is using the example from above and modifying it):
<pre class="_prettyXprint">
var myheader = mytable.getHeader( ).get( 0 );
tcell = myheader.getCells( ).get( 3 );
// var mylabel = elementFactory.newLabel( null );
// mylabel.setText( "ScriptColumn" );
tcell.getContent( ).add( mytable.getDetail( ).get( 0 ) );
</pre>
Any hint or help would be great.

Find more posts tagged with

Comments

Matthew L.

Try this:
<pre class="_prettyXprint _lang-js">
var tableHandle = reportContext.getDesignHandle().findElement("MyTable"); //Find a table called MyTable
var dataItem = tableHandle.getDetail().get(0).getCells().get(3).getContent().get(0).copy(); //Copy first detail row 'get(0)' 4th cell from left 'get(3)' first element in cell 'get(0)'
var thCell = tableHandle.getHeader().get(0).getCells().get(3); //Get CellHandle of first header row 'get(0)' 4th cell from left 'get(3)'
thCell.getContent().drop(0); //Remove old element label
thCell.getContent().add(dataItem); //Add new element 'dataItem'
</pre>

Matthew L.

After re-reading the post this example might be useful for you as well: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/24254-creating-column-dynamically/page-2#entry132987'>http://developer.actuate.com/community/forum/index.php?/topic/24254-creating-column-dynamically/page-2#entry132987</a>
 
Also I modified the previous code example and added a loop so that the entire first detail row now becomes the first header row (for reference):
<pre class="_prettyXprint">
var tableHandle = reportContext.getDesignHandle().findElement("MyTable"); //Find a table called MyTable
for(i=0;i<tableHandle.getColumnCount();i++){ //Loop through each column in the table
var dataItem = tableHandle.getDetail().get(0).getCells().get(i).getContent().get(0).copy(); //Copy first detail row 'get(0)' 4th cell from left 'get(3)' first element in cell 'get(0)'
var thCell = tableHandle.getHeader().get(0).getCells().get(i); //Get CellHandle of first header row 'get(0)' 4th cell from left 'get(3)'
thCell.getContent().drop(0); //Remove old element label
thCell.getContent().add(dataItem); //Add new element 'dataItem'
}
</pre>

stimepy

This seems to work! Thank you! I'd give hugs or some such thing but.... internet...