Eclipse Community Forums: BIRT » Is it possible to create "n" GUI tables for "n" records within the database

Home » Archived » BIRT » Is it possible to create "n" GUI tables for "n" records within the database(Separate GUI Table for each record in the database)

Is it possible to create "n" GUI tables for "n" records within the database [message #824320]

Mon, 19 March 2012 10:31

Eclipse User

I think that "for loop" is needed for this.

I have one table with n records. Let's say it is my table T1.

T1:

ID|STATUS
1 NEW
2 OPEN
3 NEW

T2:

ID|DESCRIPTION
1 DESC1
1 DESC2
2 DESC3

I would like to create NOT ONE table using birt that will show this information, but SEPARATE table for each record in T1 which will show information for both table:

Template and result will be like this:

ID: 1 STATUS: NEW

DESCRIPTION: DESC1
DESCRIPTION: DESC2

And then below that second table (n=2)

ID: 2 STATUS: OPEN

DESCRIPTION: DESC3

And then below third table (n=3)

ID: 3 STATUS: NEW

DESCRIPTION: null

Is this possible?
I will have n separate tables because of n records in T1 and I will have as many descriptions as there are records in T2 table.

Thanks for help.

[Updated on: Mon, 19 March 2012 10:32] by Moderator

Re: Is it possible to create "n" GUI tables for "n" records within the database [message #824361 is a reply to message #824320]

Mon, 19 March 2012 11:25

Eclipse User

Hi,
I guess you only need to separate tables visually, right? I have attached example where grouping is used (birt 2.6.1).

--- edit
For complete reference I have added similar example using filters on slave table.

Tomas

Attachment: test.PNG
(Size: 6.86KB, Downloaded 219 times)
Attachment: new_report_1.rptdesign
(Size: 19.02KB, Downloaded 303 times)
Attachment: new_report_1.rptdesign
(Size: 29.18KB, Downloaded 260 times)

[Updated on: Mon, 19 March 2012 11:32] by Moderator

Previous Topic:	Use multiple schema in a birt report
Next Topic:	report issue

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 21:32:50 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter