Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Report of a database schema
Report of a database schema [message #691431] Fri, 01 July 2011 12:50 Go to next message
Sascha Vogt is currently offline Sascha Vogt
Messages: 16
Registered: March 2011
Junior Member
Hi,

I have a question regarding a report. Is it possible to generate
multiple tables in birt out of one dataset? Like for example I want to
display a whole database schema.

So the report should look like:

Report of <database>

<table1>
<col1-name> | <col1-datatype>
....

and the same for table2 and so on

Obviously I don't want to manually create a paragraph for each table in
the (unknown) database.

Greetings
-Sascha-
Re: Report of a database schema [message #691436 is a reply to message #691431] Fri, 01 July 2011 13:02 Go to previous messageGo to next message
Richard A. Polunsky is currently offline Richard A. Polunsky
Messages: 199
Registered: July 2009
Location: Houston TX
Senior Member

Why do you want to create separate tables? You could just have one table and group by schema_tablename.

I suppose you could create separate tables on the fly but that would require a lot of java code.

Richard
Re: Report of a database schema [message #691450 is a reply to message #691436] Fri, 01 July 2011 13:25 Go to previous message
Sascha Vogt is currently offline Sascha Vogt
Messages: 16
Registered: March 2011
Junior Member
Hi Richard,

Am 01.07.2011 15:02, schrieb Richard A. Polunsky:
> Why do you want to create separate tables? You could just have one
> table and group by schema_tablename.
Because I would like to add text paragraphs in between. The database
schema example was just a simplified example. I have an unknown number
of "groups" in my original datasource and I have some "common"
information for each group which would need to be put in front of the
"details" table which is then the "rows" of the group entries.

> I suppose you could create separate tables on the fly but that would
> require a lot of java code.
Would it be possible to have sub-reports and a parametrized dataset to
achieve something like this (I'm a BIRT beginner, so I'm not sure what
features overall BIRT has to offer for particular problems. I don't even
know if there exist parametrized datasets and if there is a possiblity
to loop over a parameter list and execute sub-reports for each list entry).

Greetings
-Sascha-
Previous Topic:How to make the where clause optional on dataset SQL query??
Next Topic:Reports Not working while upgrading from Birt 2.6.1. to Birt 3.7
Goto Forum:
  


Current Time: Wed Oct 01 20:22:20 GMT 2014

Powered by FUDForum. Page generated in 0.04274 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software