Eclipse Community Forums: BIRT » Report of a database schema

Help

Home

Home » Eclipse Projects » BIRT » Report of a database schema

Show: Today's Messages :: Show Polls :: Message Navigator

Report of a database schema [message #691431]

Fri, 01 July 2011 08:50

Sascha Vogt
Messages: 14
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-

Report message to a moderator

Re: Report of a database schema [message #691436 is a reply to message #691431]

Fri, 01 July 2011 09:02

Richard A. Polunsky is currently offline

Richard A. Polunsky
Messages: 197
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

Report message to a moderator

Re: Report of a database schema [message #691450 is a reply to message #691436]

Fri, 01 July 2011 09:25

Sascha Vogt
Messages: 14
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-

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 20 01:05:08 EDT 2013