Unable to reference a running count column in a dataset

kevinshih · 2011-02-02T03:55:17+00:00

Hi all, I have a computed column added to a dataset. It is configured with the following properties: Column Name: RECORD_COUNT Data Type: Integer Aggregation: RUNNINGCOUNT Expression: row["OID"} In the onFetch()…

kevinshih

Hi all, 
 
I have a computed column added to a dataset. It is configured with the following properties: 
 
Column Name: RECORD_COUNT 
Data Type: Integer 
Aggregation: RUNNINGCOUNT 
Expression: row["OID"} 
 
In the onFetch() method of the dataset, I have the following javascript: 
reportContext.setGlobalVariable("ucUserCount", row.RECORD_COUNT);
 
When I get the global variable later in the report, it is always null. If I change the onFetch() method to: 
reportContext.setGlobalVariable("ucUserCount", row.OID);
then the global variable returns with a value when I call it. 
 
Am I referencing the computed column incorrectly?

Find more posts tagged with

Comments

Hans_vd

Hi Kevin, 
 
The reference is probably right, but the computed column is not computed yet in the onFetch method. 
 
I got this from BIRT documentation: 
 
<blockquote class='ipsBlockquote' >onFetch: 
Called just after fetching each row before applying filters or calculating computed columns.</blockquote>
 
Is your dataset based on a database query? 
For most databases you can add what you need in the SELECT clause of the query. 
 
Hope this helps