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 Add Report Parameter to Grid using Design API

grather

I am trying to add to a grid the value of a report parameter using the Design API
 
For images and data elements
 
The pattern is
 
ElementFactory factory = rDesign.getElementFactory();
 
newImage = factory.newImage(imgName); 
newImage.setURL(imgName); 
newImage.setSource("file");
 
 
or for text it is
 
ElementFactory factory = rDesign.getElementFactory(); 
TextItemHandle newTextItem = null; 
newTextItem = factory.newTextItem(secName); 
newTextItem.setContentType("HTML"); 
newTextItem.setContent(text);
 
 
then I just add this to the grid
 
But I am not able to figure out how to add an existing reportParameter so it can be displayed

When I do it using the designer I end up in my XML
But not sure how using the designAPI
<div><data id="5794"></div>
<div> <list-property name="boundDataColumns"></div>
<div> <structure></div>
<div> <property name="name">employeeSelect</property></div>
<div> <expression name="expression" type="javascript">params["employeeSelect"]</expression></div>
<div> <property name="dataType">string</property></div>
<div> </structure></div>
<div> </list-property></div>
<div> <property name="resultSetColumn">employeeSelect</property></div>
<div> </data></div>
<div> </div>

Find more posts tagged with

Comments

Matthew L.

Using Data Elements can be tricky at first. However below is a simple example on how to accomplish this.
For an example of using Data Elements in a table, see this post: <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/24254-creating-column-dynamically/?p=132987'>http://developer.actuate.com/community/forum/index.php?/topic/24254-creating-column-dynamically/?p=132987</a>
 
To assign a Data Element a Parameter Value you must first create a Computed Column Binding:
<pre class="_prettyXprint _lang-js">
var computedColumn = StructureFactory.createComputedColumn(); //Create an empty computed column structure
computedColumn.setName("MyParam"); //Set the reference name
computedColumn.setExpression("params[\"MyParameter\"]"); //Set the expression
</pre>
Then you can bind the Computed Column to the Data Element and reference the Computed Column name in the Data Element's Expression (ResultSetColumn):
<pre class="_prettyXprint _lang-js">
var dataItemHandle = elementFactory.newDataItem(null); //Create new data item
dataItemHandle.getColumnBindings().addItem(computedColumn); //Add column binding
dataItemHandle.setResultSetColumn("MyParam"); //Set value based on column binding reference name
</pre>
Then the Data Element can be added to a Grid Cell:
<pre class="_prettyXprint _lang-js">
var gridHandle = reportContext.getDesignHandle().findElement("MyGrid"); //Get grid handle
gridHandle.getCellContent(1, 1).add(dataItemHandle); //Add data element to grid cell
</pre>
Below is a full code example. See attached report for a working example.
<pre class="_prettyXprint _lang-js">
importPackage(Packages.org.eclipse.birt.report.model.api); //For StructureFactory

reportDesignHandle = reportContext.getDesignHandle(); //Get report design handle
elementFactory = reportDesignHandle.getElementFactory(); //Get element factory

var computedColumn = StructureFactory.createComputedColumn(); //Create an empty computed column structure
computedColumn.setName("MyParam"); //Set the reference name
computedColumn.setExpression("params[\"MyParameter\"]"); //Set the expression

var dataItemHandle = elementFactory.newDataItem(null); //Create new data item
dataItemHandle.getColumnBindings().addItem(computedColumn); //Add column binding
dataItemHandle.setResultSetColumn("MyParam"); //Set value based on column binding reference name

var gridHandle = reportContext.getDesignHandle().findElement("MyGrid"); //Get grid handle
gridHandle.getCellContent(1, 1).add(dataItemHandle); //Add data element to grid cell

</pre>

grather

Thank you so much.
I was struggling with this.
 
I solved my problem in a simpler way.
 
I created a TextItemHandle
and set the content to "<VALUE-OF>params[\"" + param + "\"].value</VALUE-OF>");
and set the ContentType = HTML
 
This worked for me.
I will try you solution as well. Plus it gives me anidea about how to do aggregation as well. Which is my next task
 
Again thank you so much