display data in BIRT
Options
Dear Open text community,
I am new to birt and sql, kindly be with me if its a very basic question for u.
I have two tables in DB
1.COMPANY- companyid, name, phone, address, and other info
2.COMPANY_OWNER- company id, ownername , percentage share
my requirement is as below
display a simple table report ,one row per company and in that row one cell contains all (owners - % )for a company.
PFA for more clarification
0
Comments
-
Create a Data Set that joins the Company and Owner database tables.
Create a table on the report from the Data Set.
Add a Group to the table and group on company_id.
Add an aggregation for the table group of type Concatenate.
The expression should be something like: row["Owner"] + " - " + row["percentage_share"]
For the separator, use \nWarning No formatter is installed for the format ipb0
Categories
- All Categories
- 108 Developer Announcements
- 49 Articles
- 100 General Questions
- 122 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management