Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » 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 Go to next message
Dejan Vujanic is currently offline Dejan Vujanic
Messages: 66
Registered: October 2011
Member
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]

Report message to a 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 Go to previous message
Tomas Greif is currently offline Tomas Greif
Messages: 53
Registered: September 2010
Member
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

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

Report message to a moderator

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


Current Time: Fri Aug 01 05:55:10 EDT 2014

Powered by FUDForum. Page generated in 0.01732 seconds