DOM Datasource: How to sum the column values

Hi Team,
 
I have a report using DOM based Data source, in which i have a Grid which has one column and each row is binded with the DOM based data source since the input to Data Set Parameter Binding is different. I need to sum all these columns and display in the last row. Can you please confirm if there is any script available for storing the value populated at each row and sum the values and display in the last row.

Find more posts tagged with

Comments

Clement Wong

Create a footer row in your table. Then, you can just insert an Aggregation report item, with SUM as the function, and the Expression as the column you want to total.

sriram nagappan

Hi,
I am not using DB datasource. The datasource is based on DOM (Document Object Model) and each data element is individually binded to the DOM dataset. So i am not sure which datasource i need to bind and what expression to use. I have a idea to use Global variable and store the value populated at each data element and finally display the stored variable at the last row

sriram nagappan

Hi
In continuation to ablove.
I need help how to declare global variable and store the value populated at each data item and sum it and display in another data element

Clement Wong

I was assuming you were using a Scripted Data Source / Data Set. You can't create Computed Columns for a Script Data Set so you'll need to follow my suggestion from the previous post.

newbie321

<blockquote class="ipsBlockquote" data-author="sriram nagappan" data-cid="140635" data-time="1450541148">
<div>
Hi
In continuation to ablove.
I need help how to declare global variable and store the value populated at each data item and sum it and display in another data element
</div>
</blockquote>
 
As far as I know this is how you create local and global variables in BIRT through script: 
number =55; // global variable
var number =55; // local variable
 
so as you can see the keyword 'var' determines the scope of the variable. Birt uses Rhino Javascript. 
 
Hope this helps,

newbie321

<blockquote class="ipsBlockquote" data-author="Clement Wong" data-cid="140787" data-time="1450720768">
<div>
I was assuming you were using a Scripted Data Source / Data Set. You can't create Computed Columns for a Script Data Set so you'll need to follow my suggestion from the previous post.
</div>
</blockquote>
 
I am not sure if this does the trick, but there is a way to add more columns to the scripted data set. The calls are: 
 
StructureFactory.createResultSetColumn();
StructureFactory.createComputedColumn();
StructureFactory.createColumnHint();
 
etc etc. Please note, the above are just methods listings, not the actual program flow... 
 
The complete API ref can be found at <a data-ipb='nomediaparse' href='http://help.eclipse.org/mars/index.jsp'>http://help.eclipse.org/mars/index.jsp</a>under Birt Programmer Reference.
 
Hope this helps,

Clement Wong

@newbie321
Sorry, you are correct. What I meant was you can't create Computed Columns for a Scripted Data Set from the UI.
 
@sriram nagappan
There's no need for your design because I replied to your other thread that did have the design and sample data. The attached design in <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/37949-binding-with-scripted-data-set/?p=140793'>http://developer.actuate.com/community/forum/index.php?/topic/37949-binding-with-scripted-data-set/?p=140793</a>
includes the total amount, which was added via the method in <a data-ipb='nomediaparse' href='http://developer.actuate.com/community/forum/index.php?/topic/37773-dom-datasource-how-to-sum-the-column-values/?p=140603'>post #2</a> above.