Simple Grouping problem [message #48664] |
Tue, 21 June 2005 15:06 ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
Originally posted by: pavlov.clockbs.com
Hi to all,
I am impresses by the BIRT project and impatient to evaluate it for
inclusion in our new projects. I have very few knowledge about it, so
please excuse my stupid mistakes if any.
After I successfully launched my first report with ScriptedDataSet I
decided to group it by the first field. immediately I received
"Error1:Failed to render Table".
Where can I read more about grouping definition?
Thank you.
Veselin Pavlov
|
|
|
|
Re: Simple Grouping problem [message #52571 is a reply to message #51107] |
Wed, 29 June 2005 11:50 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Eclipse User![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=) |
|
|
|
Originally posted by: pavlov.clockbs.com
On Thu, 23 Jun 2005 22:12:55 -0700, Rima Kanguri wrote:
> For more information on table/list grouping, refer to group section in
> the spec. http://www.eclipse.org/birt/ref/ROM_List_and_Table_SPEC.pdf
>
> --Rima
>>
>> After I successfully launched my first report with ScriptedDataSet I
>> decided to group it by the first field. immediately I received
>> "Error1:Failed to render Table".
>>
Well reading of the specs didn't help me. When I am working with JDBC
dataset everything is OK, but with the scripted dataset I am still having
the same problem.
I am doing the grouping the same way with both datasets. The
only scripted code is on "open" and "fetch" event of the scripted dataset.
My question is - Is there something special when grouping scripted
datasets or ... a bug is hiding somewhere :) ?
Vesko
|
|
|
|
|
|
Re: Simple Grouping problem [message #54776 is a reply to message #54327] |
Thu, 07 July 2005 11:52 ![Go to previous message Go to previous message](theme/Solstice/images/up.png) ![Go to next message Go to next message](theme/Solstice/images/down.png) |
Paul Kuit![Friend of Eclipse Friend](/donate/web-api/friends_decorator.php?email=paul.kuit%40comsol.com.br) Messages: 11 Registered: July 2009 |
Junior Member |
|
|
Ok, now everything is working I did some benchmarking, and unfortunately the
results are very bad. So bad that I have to abandon my solution reusing the
Hibernate POJOS and use plain old boring JDBC after all!
I got a Collection with 4000 'complex' objects and I copy the values from
the Java Objects into the javascript data set rows like this;
while (results.hasNext()){
Employee emp = results.next();
row.name = emp.name;
row.department = ""+emp.position.unity.process.description;
/*
(equivalent to;
row.department = "" +
emp.getPosition().getUnity().getProcess().getDescription();
*/
}
In the report I do a grouping on row.department.
But this process of copying the values in Javascript variables takes about 3
minutes (PIII, 850Mhz)!
Make the report with JDBC, so without the need to do this while loop,
executes immediately!
"Stavros Kounis" <gounis@clubmobil.com> wrote in message
news:daghbr$6ab$1@news.eclipse.org...
> Hi Paul
>
> i see that you (finally) have find a solution (you are fast). can you
> please add this in your comment in my blog entry [1]?
>
> [1] http://tools.osmosis.gr/blog/archives/2005/06/birt_and_objec t.html
>
> thnx
>
> stavros
>
> "Paul Kuit" <paul.kuit@comsol.com.br> wrote in message
> news:daeead$t3h$1@news.eclipse.org...
>> Found a solution..
>>
>> The object assigned to the field in the data set was a Java String, which
>> is implemented as this NativeJavaObject?
>>
>> So when I made a new String inside the fetch method of the DataSet
>> JavaScript
>>
>> row["foo"] = ""+foo.getValue();
>>
>> the String would be able to be compared.
>>
>>
>>
>> "Paul Kuit" <paul.kuit@comsol.com.br> wrote in message
>> news:dadt8e$4ep$1@news.eclipse.org...
>>> Having the exact same problem...
>>>
>>> The logs tell me there is a ClassCastException during a compare, but the
>>> group by value is a String Object.
>>>
>>> When I change the output column type to String instead of Any, the
>>> report renders, but shows me the object representation String instead of
>>> it
|
|
|
|
Powered by
FUDForum. Page generated in 0.03963 seconds