Home
Analytics
Concatenate 2 groups as a single group in the table - BIRT report
sridhark
In my report, table have 2 groups as shown below in the attached image (GroupTable.jpg)
First group is 'IFT-Information Analyzer'(group #1) and sub group of this is 'Documentation Team'(group #2). The result displays fine. But i need to make some changes as below.
a) How can i concatenate these 2 groups as a single group in group #1 and display the same result? i mean make one group as 'IFT-Information Analyzer - Documentation Team' in group #1 and delete the sub group #2
b) Presently group #1 ('IFT-Information Analyzer') text wrap it in the 2 lines with respect to the size of the dipslay name 'Id' as this is larger in size. How can i make this text in a single line without dependent on size of the 'ID'. Basically, it should shrink or grow in a single line in the table.
By the way, am using BIRT 2.3.2 version.
Find more posts tagged with
Comments
mwilliams
Hi sridhark,
For a, there is an "expression builder" button next to the "Group on" text box in the group editor. You can write and expression that concatentates those two fields together as the "group on" value.
For b, you can click in the summary column and drag over into the id column in your header to select both cells, then right click in the selected area and choose "merge cells". This should allow your group header info to work across the entire area.
Hope this helps. Let me know if you have any questions.
sridhark
Thanks Michael for your quick reply:)
I am able to complete those changes. But I am not able to do the paging for my big report even though the settings for 'Page Break' property set as below in attached image.
Do i need to make any other changes to enable paging?
mwilliams
sridhark,
What are you trying to do with your paging?
sridhark
Basically, My report generates around 300 rows in the table. It looks like long list in the single page with scroll bar. Can i make the paging to limit the display in a single page 50 rows and then make in 6 pages like that (for 300 rows)?
mwilliams
sridhark,
If you want 50 detail rows per page, you should select the table, go down to the property editor's page break section and put 50 in as the page break interval.
sridhark
Even though i set Page Break section (pasted image in one of the conversation above), my report didn't get generate with page enabled. The result displays in single page. Is there any other option that i need to set for?
mwilliams
sridhark,
How are you running your report? In the web viewer? Or just in the preview screen?
sridhark
Micheal, I am running report in web viewer.
mwilliams
Can you attach your actual report so I can see what all you're doing?