Home » Archived » BIRT » Creating Datasets/Data Sources Programmatically
| Creating Datasets/Data Sources Programmatically [message #38937] |
Fri, 20 May 2005 06:46  |
Eclipse User |
|
|
|
Hi,
In our application we are aiming towards the automatic generation of
reports, to do this we need to programmatically create datasets and/or
datasources. I would like to know if there is a way to do this without
going through the datasource and dataset wizards.
I would greatly appreciate any help on this matter.
Thanks and regards
Nathan
|
|
|
| Re: Creating Datasets/Data Sources Programmatically [message #38973 is a reply to message #38937] |
Fri, 20 May 2005 14:51  |
| Eclipse User |
|
|
|
Nathan,
There are two ways to create designs (including data sources and data sets)
programmatically.
First, you can use the DE API. It provides a complete set of functions to
create report elements including data sources and data sets. You can even
start with an existing file if some of the content is the same from one
report to the next (data source, page headers, titles, styles, or whatever.)
See the following for an introduction:
http://www.eclipse.org/birt/index.php?page=deploy/de-api.htm l
Second, you can directly create the XML design file using your favorite text
or XML tool. The scripting approach works best if the generated designs
follow a fairly fixed pattern. For example, a single data set, a tabular
layout, standard styles, etc. Simply create a design that is typical, then
identify the bits that will change. (Data set query, column headings, column
contents.) There is a brief intro to this idea at:
http://www.eclipse.org/birt/index.php?page=deploy/viewer-php .html
I've done a simple prototype of the scripted approach using PHP and can make
that available if it would be helpful.
- Paul
Paul Rogers
BIRT PMC
"Nathan McKeown" <nathan.mckeown@scapatech.com> wrote in message
news:d6kf0n$sbo$1@news.eclipse.org...
> Hi,
>
> In our application we are aiming towards the automatic generation of
> reports, to do this we need to programmatically create datasets and/or
> datasources. I would like to know if there is a way to do this without
> going through the datasource and dataset wizards.
>
> I would greatly appreciate any help on this matter.
>
> Thanks and regards
>
> Nathan
|
|
|
| Re: Creating Datasets/Data Sources Programmatically [message #48609 is a reply to message #38973] |
Tue, 21 June 2005 06:25 |
| Eclipse User |
|
|
|
Hi,
Thanks for the help, I have now made some good progress using the DE API
route to produce my reports.
I am however, still having difficulties trying to format the reports
(using grouped headings etc.), with data coming from the ResultSet I
have generated?
Thanks
Nathan
Paul Rogers wrote:
> Nathan,
>
> There are two ways to create designs (including data sources and data sets)
> programmatically.
>
> First, you can use the DE API. It provides a complete set of functions to
> create report elements including data sources and data sets. You can even
> start with an existing file if some of the content is the same from one
> report to the next (data source, page headers, titles, styles, or whatever.)
> See the following for an introduction:
>
> http://www.eclipse.org/birt/index.php?page=deploy/de-api.htm l
>
> Second, you can directly create the XML design file using your favorite text
> or XML tool. The scripting approach works best if the generated designs
> follow a fairly fixed pattern. For example, a single data set, a tabular
> layout, standard styles, etc. Simply create a design that is typical, then
> identify the bits that will change. (Data set query, column headings, column
> contents.) There is a brief intro to this idea at:
>
> http://www.eclipse.org/birt/index.php?page=deploy/viewer-php .html
>
> I've done a simple prototype of the scripted approach using PHP and can make
> that available if it would be helpful.
>
> - Paul
>
> Paul Rogers
> BIRT PMC
>
> "Nathan McKeown" <nathan.mckeown@scapatech.com> wrote in message
> news:d6kf0n$sbo$1@news.eclipse.org...
>
>>Hi,
>>
>>In our application we are aiming towards the automatic generation of
>>reports, to do this we need to programmatically create datasets and/or
>>datasources. I would like to know if there is a way to do this without
>>going through the datasource and dataset wizards.
>>
>>I would greatly appreciate any help on this matter.
>>
>>Thanks and regards
>>
>>Nathan
>
>
>
|
|
|
Goto Forum:
Current Time: Wed May 21 23:08:16 EDT 2025
Powered by FUDForum. Page generated in 0.02977 seconds |
Home