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; } } }

Syntax for Aggregation Filter

jballnik

Hey Gang,

I'm trying to display the total count of All workorders at the bottom of the report. I have two data fields because I want to display the total count where worktype = 'CM' and where worktype = 'PM'. I created an Aggregration Data Control and in my Filter Condition I have the following syntax:

dataSetRow["worktype"].value = "CM"

Nothing displays in the data control. I have attached a screenshot of the window in BIRT. Does anyone know the correct syntax for the filter?

thanks,
John

Find more posts tagged with

Comments

RCirne

<blockquote class='ipsBlockquote' data-author="'jballnik'" data-cid="69410" data-time="1287098434" data-date="14 October 2010 - 04:20 PM">
Hey Gang, 
 
I'm trying to display the total count of All workorders at the bottom of the report. I have two data fields because I want to display the total count where worktype = 'CM' and where worktype = 'PM'. I created an Aggregration Data Control and in my Filter Condition I have the following syntax: 
 
dataSetRow["worktype"].value = "CM" 
 
Nothing displays in the data control. I have attached a screenshot of the window in BIRT. Does anyone know the correct syntax for the filter? 
 
thanks, 
John </blockquote>
 
The expressions use JavaScript sintax, so you should try: 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>dataSetRow["worktype"].value == "CM"</pre>
 
Cheers