total.count() function in birt 2.5.2

Hey,

i had the expression total.count()==0 to hide a row in a table in the birt 2.2.2 version that works fine.

Now i'm using the birt 2.5.2 version and it doesn't work.

What is the solution ?

thanks

Vincent

Find more posts tagged with

Comments

JRS

Hi, 
 
the problem is that there are no Total. functions since BIRT 2.3. I really don't understand why they did this but it is this way anyhow. 
Normally the functions do work if you just use them in a script by writing them manually. 
Maybe you should create a hidden aggregation field where you do the count and then put a filter on the table with 
<pre class='_prettyXprint _lang-auto _linenums:0'>Aggregation != 0</pre>
 
This should work even if it isn't such a nice solution. Importing reports from older versions do have some really annoying bugs! I did feel some of them by my own

Regards, 
 
JRS

johnw

You can do the same thing with the aggregation component. If you add in the aggregation component, it adds in a Table Binding expression. so if drop in an aggregation component and name it "Aggregation", you can reference it the same was as Total.count by doing row["Aggregation"].

They did this in newer versions as it is much more flexible, being able to use aggregate expressions in charts and other benefits that were harder to do using the Total functions in BIRT 2.2 and below.

Technically, you might be able to drop in the plugin from the older version that had the Total.* functions, but I haven't tried it and don't know what the results would be.