Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Column binding, display multiple records
Migrateduser
Hi,
I am trying to display multiple records in a table column.
I have two tables X and Y. X table has hasMany relationship with Y table.
X table has below attributes:
1.Status
2.Type
3.CompletionTime
Y table has below attributes:
1.Y-Type
2.CreatedCount
3.UpdatedCount
I want to display all the records(Y) that are associated for each X record in same row.
Result table column names are 'Status','Type','CompletionTime','Y-data'. In 'Y-data' column I want to display records from Y table like below:
Y-Type:STS
CreatedCount:2
UpdatedCount:1
Y-Type:TST
CreatedCount:4
UpdatedCount:3
I have added column binding to Y-data column, and bind a data set which is returning multiple records(from Y table) based on X id, but report is displaying only one record
Please suggest me on this.
This is my first post and I am very new to birt report, please let me know if I miss any thing
Thanks
Find more posts tagged with
Comments
There are no comments yet