Aggregation Extension

Hi Everybody,
I am creating some birt(plugin) custom function by extending
"org.eclipse.birt.data.engine.api.aggregate" which
is required in my report.the function is aggregate all
the value of particular column (column datatype is String.)
belong to group.basically function aggregate(concat) string
group by column.
this function is available in new birt(2.3.1). but in our
application we are using birt(2.2.1) and eclipse 3.3(europa).
Actually i am created string aggregate function & its working
fine with all the row.but i can,t aggregate(concat) string value
group by some column.
i use it like "Total.Concatenation(row[subject])" it return string that
aggregate all subject column value.& i need string that aggregate all
subject belong to particular group.
if there any javaScript code that is use in
place of group by or any other solution please reply.

Thanks & Regards'
Paritosh

Find more posts tagged with

Comments

johnw

I actually have this aggregation done. I thought I had writen an article on it, but I guess I wrote the aggregator and not the article

This will be for versions of BIRT prior to 2.3.

Send me an email and I will send it to you.

paritosh

Hi johnW, 
Thanks for your reply.But actually Now I created Aggregation 
Extension plugin for Birt 2.2.1. I just Created that by follow the 
instruction given in the following link. 
 
".<a class='bbc_url' href='http://download.eclipse.org/birt/downloads/exampl/extension'>http://download.eclipse.org/birt/downloads/exampl/extension</a> /aggregate/aggregate.html" 
 
then i Deploy this by creating .jar and put that into plugin folder 
of eclipse. that custom Function is working fine in eclipse IDE. 
and report gives right result . 
but when i us this .jar in our Web application (birt Runtime folder) 
& generate the Particular report that give runtime error. & particular 
column where we use custom function gives message. 
 
"org.eclipse.birt.data.engine.core.DataException: Error happens when try to read value of column: Aggsubs. This might cause by a runtime error in the evaluation of bindings expression" 
 
so how we use that aggregation plugin in our web application .Is there 
any registry file or other file in Birt-runtime where we should mention 
the plugin name. 
If you have any idea please reply. 
 
Thank & Regards' 
Paritosh.

johnw

How did you generate your Jar? Did you use the Eclipse Export? Or did you open up the plugin.xml or Manifest.MF file, go tot he Overview tab, and follow the Export plugin wizard?

paritosh

I generate plugin jar file by using Eclipse Export ->Deployable plugin &
fragments.And that jar is working fine with Eclipse by putting jar into
plugin folder of eclipse.But when i use that jar in our application
"Reportengine" plugin folder it is not working or Report engine can't load
that jar at runtime.
Is there any difference between these two way to generate jar file.
Please guide me.

Thanks & regards'
Paritosh .

johnw

No, they both start the same thing, just making sure you were using the deployable plugin option.

Only other thing I can think of is to extract the jar in the plugins folder. create a directory under the plugins folder with the exact name that your jar file is, minus the extension. Then extract the jar to that directory. I've had some issues similar in the past with the web app, and this usually fixes it.

paritosh

Hi John,
thanks for your guidance & suggestion .actually there is some property
are missing in my plugin in the runtime Tab of the MANIFEST.MF .so i
think that the reason "birt report Engine" can't load it at runtime . But
now that problem is resolved and plugin .jar is working fine. in our Web
apps.

Again thanks for your useful replies.

Regards,
Paritosh