How to generate Columnar (or label) report
Hi everyone,
I need to generate a columnar (or label) report in BIRT. Is there anyone know how to do it? Please help me out.
My report will look like this
City 1
customer1 customer2 customer3 customer4
customer5 customer6 customer7 customer8
City 2
customer1 customer2 customer3 customer4
customer5 customer6 customer7 customer8
Each customer is a record from dataset.
Thanks
I need to generate a columnar (or label) report in BIRT. Is there anyone know how to do it? Please help me out.
My report will look like this
City 1
customer1 customer2 customer3 customer4
customer5 customer6 customer7 customer8
City 2
customer1 customer2 customer3 customer4
customer5 customer6 customer7 customer8
Each customer is a record from dataset.
Thanks
0
Comments
-
Hi Michael,
I can group data by city, but I don't know how to display records in multiple columns
Let me make it clear
My final report will look like this
Los Angeles City
John Smith Angie White Ann William
323-123-789 818-278-1246 323-145-1237
Bob Brown Daniel Wong Edna Hall
323-123-789 818-278-1246 323-145-1238
Whitier City
Daniel Lee Phil Smith Miachael Nguyen
626-123-789 626-278-1246 626-175-4123
Bill William John Diaz Johnny Rice
562-123-789 626-278-1246 562-145-1237
Please advise. Thanks0 -
hvh,
The best I can get right now is using what hewb described. It ends up looking more like this though:
City 1
LastName1 Phone#1 LastName2 Phone#2 LastName3 Phone#3
LastName4 Phone#4 LastName5 Phone#5 LastName6 Phone#6
City 2
etc...
If I come up with anything better, I'll let you know.
Regards,
MichaelWarning No formatter is installed for the format ipb0 -
Thanks Michael and hewb for your response,
After reading subreport section in the book, I came up with a solution
1. I have master list that binding to city data set
2. In the list details, I have a grid with 3 columns ( or any). Each columns will have a table that binding to customer data set. This data set is linked to city data set in master list by cityID. Then I use row number to filter data for each column.
I finally got the layout that I want. Just little concern about performance.
I don't know if anyone has better solution.
Regards.
hvh0 -
hvh,
I was working on that exact same thing and was going to suggest that. It looks to me that that's going to be the only way to achieve what you're looking for. That might be a good example to post up on the devShare!
Regards,
MichaelWarning No formatter is installed for the format ipb0 -
hvh,
Based on the description of you report design, you might run into performance issues with larger data set, since it appears that a data set query has to be run for each column within a group.
I have attached a sample report design that shows how a similar report is done against the Customers table in the BIRT sample database. This report is optimized for performance, in that only a single query is run. The keys to this report design are:
(1) The outer table is the only one bound to the data set. All the inner lists use the outer table's data set.
(2) 3 side-by-side lists (placed in a 1x3 grid) in the outer table's group footer simulates a columnar layout. Visibility rules (set on the inner-most grid that contains the Name and Phone data items) filters the lists so that each list only displays 1/3 of the rows.
Note that this design is created in BIRT 2.2.0. Please open with this version of BIRT or later (or any Actuate 9SP3+ BRDPro).
Hope this helps.
Gary Xue0
Categories
- All Categories
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management