Eclipse Community Forums: BIRT » New dataset(type) with ODA

Home » Archived » BIRT » New dataset(type) with ODA

New dataset(type) with ODA [message #75539]

Mon, 19 September 2005 10:29

Eclipse User

Originally posted by: peter.fopma.ifbag.com

Is is possible to define a new dataset type using ODA.
Does ODA provide a way to alter the visualisation of the
dataset? Could someone point out an example how ODA is
used?

I would like to reuse existing business logic where data is
organized in a grid with row and column headers. Instead of
implementing a scripted datasource where the dataobject is
referenced from data report objects, I would like to find a
way to include the existing object as new dataset(type).
And possibly add the data to the report via drag and drop...

If my request is too confusing, a link to an example using
ODA is greatly appreciated.

Thanks,
Peter

Re: New dataset(type) with ODA [message #75590 is a reply to message #75539]

Mon, 19 September 2005 12:10

Eclipse User

Peter,
An example of an ODA is in the source under
org.eclipse.birt.report.data.oda.flatfile and
org.eclipse.birt.report.data.oda.flatfile.ui.
I believe all the types in ODA have to be converted to a type the engine can
understand.
To add a whole new type, would probally require changes to the engine.
You may be better off looking at the report item extension such as the
rotated text example create your own control that calls your object and
includes it. That example is under
org.eclipse.birt.sample.reportitem.rotatedtext.

Jason Weathersby
BIRT PMC

"Peter Fopma" <peter.fopma@ifbag.com> wrote in message
news:a5411f7f7ecda121e7e7f4cdc64f4d0c$1@www.eclipse.org...
> Is is possible to define a new dataset type using ODA.
> Does ODA provide a way to alter the visualisation of the
> dataset? Could someone point out an example how ODA is
> used?
>
> I would like to reuse existing business logic where data is
> organized in a grid with row and column headers. Instead of
> implementing a scripted datasource where the dataobject is
> referenced from data report objects, I would like to find a
> way to include the existing object as new dataset(type).
> And possibly add the data to the report via drag and drop...
>
> If my request is too confusing, a link to an example using
> ODA is greatly appreciated.
>
> Thanks,
> Peter
>

Re: New dataset(type) with ODA [message #75831 is a reply to message #75590]

Tue, 20 September 2005 08:56

Eclipse User

Originally posted by: peter.fopma.ifbag.com

Jason,
from looking at the examples mentioned it looks as if the
IAdvancedQuery is the interface of choice when trying to
use a structured dataset.

Is this meant for datasets where a list of results
could possibly consist of lists itself (a tree?) - maybe realized as
multiple resultsets!? Or is this just wishful thinking from
my part and I did not understand the true nature of ODA?

Is the visualization of the resultset done according to the meta-data?
Is this implemented in Version 1.0.1 or in Version 2.0MR1
or not yet at all?

Thanks
Peter

Re: New dataset(type) with ODA [message #76015 is a reply to message #75831]

Tue, 20 September 2005 13:59

Eclipse User

Peter,
Good question.
I believe the advanced query is not available until 2.0. That said it is
used for things like multiple result sets and complex output parameters.
Using the gui portiion of an ODA would allow you to show the complex
structure in the designer,while you are in the data set creation. I believe
this still requires somewhere that the data types be converted to something
the engine can understand. I will check this.

Jason Weathersby
BIRT PMC

"Peter Fopma" <peter.fopma@ifbag.com> wrote in message
news:c17550ee181fcabc9bfb587ea1faee12$1@www.eclipse.org...
> Jason,
> from looking at the examples mentioned it looks as if the
> IAdvancedQuery is the interface of choice when trying to
> use a structured dataset.
>
> Is this meant for datasets where a list of results
> could possibly consist of lists itself (a tree?) - maybe realized as
> multiple resultsets!? Or is this just wishful thinking from
> my part and I did not understand the true nature of ODA?
>
> Is the visualization of the resultset done according to the meta-data?
> Is this implemented in Version 1.0.1 or in Version 2.0MR1
> or not yet at all?
>
> Thanks
> Peter
>

Re: New dataset(type) with ODA [message #78054 is a reply to message #76015]

Fri, 30 September 2005 04:16

Eclipse User

Originally posted by: peter.fopma.ifbag.com

Jason,

I think I am slowly getting somewhere. I managed to modify
the flatfile-ODA Datasource and trace where all the Interfaces
belong.
Unfortunately changing the Connection-class to return an
IAdvancedQuery instead of a simple IQuery and modifing the
DataSetMetaData to claim that the Query now supports
multiple resultsets as well as multiple open resultsets
and named resultsets shows no difference at all.

I use the BIRT Version 2.0 Maintenancerelease 1. Should the
advancedQuery be supported in this version or am I trying
in vain!?

Thanks for your help

Peter

Re: New dataset(type) with ODA [message #79063 is a reply to message #78054]

Tue, 04 October 2005 13:13

Eclipse User

Peter,

I am pretty sure its not in M1.

Jason Weathersby
BIRT PMC
"Peter Fopma" <peter.fopma@ifbag.com> wrote in message
news:dcbdf3788952f67f571ddc8cb24d563b$1@www.eclipse.org...
> Jason,
>
> I think I am slowly getting somewhere. I managed to modify
> the flatfile-ODA Datasource and trace where all the Interfaces
> belong.
> Unfortunately changing the Connection-class to return an
> IAdvancedQuery instead of a simple IQuery and modifing the
> DataSetMetaData to claim that the Query now supports multiple resultsets
> as well as multiple open resultsets
> and named resultsets shows no difference at all.
>
> I use the BIRT Version 2.0 Maintenancerelease 1. Should the
> advancedQuery be supported in this version or am I trying
> in vain!?
>
> Thanks for your help
>
> Peter
>

Previous Topic:	Is there any way to create a CSV format reports in BIRT?
Next Topic:	Simple Master Page Footer visibility

Goto Forum:

-=] Back to Top [=-

Current Time: Sat Jul 19 03:01:51 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter