1

How would I create variable sub-headers in a BIRT list..

The original BIRT list is as follows:

Sys_ID | Sys_Name  |  App_ID |  App_Name   
----------------------------------------
S1     | ABR       |  A1     |  ABR: Bim
S1     | ABR       |  A2     |  ABR: Dip
S1     | ABR       |  A3     |  ABR: Saw
S2     | TIP       |  B1     |  TIP: Yop
S2     | TIP       |  B2     |  TIP: gum
S3     | GOO       |  C1     |  GOO: res

I want to implement BIRT to show the following:

Sys_ID | Sys_Name  |  App_ID |  App_Name   
----------------------------------------
S1     | ABR       |         |
S1     | ABR       |  A1     |  ABR: Bim
S1     | ABR       |  A2     |  ABR: Dip
S1     | ABR       |  A3     |  ABR: Saw
S2     | TIP       |
S2     | TIP       |  B1     |  TIP: Yop
S2     | TIP       |  B2     |  TIP: gum
S3     | GOO       |         |
S3     | GOO       |  C1     |  GOO: res

The Sys and App data are all implemented in one BIRT data set.

Can anyone please help?

talon
  • 123
  • 1
  • 12

1 Answers1

1

That is easy and one of the strengths of BIRT. When you place a table on the report (or just drag-and-drop the whole dataset) you see the result as in your original list.

If you want the table to be grouped by Sys_name, you can do so. Select the table, open the properties Editor and open the Groups tab. Click add. Select the Sys_name attribute as the Group-on parameter. (take a look at the other options, they speak for themselves) Now click OK. In the table you will see that two rows are added. A group header and a group footer. The group header will also include the selected group by attribute in the first column. You can change this to be any attribute that is the same for the group or something that is an aggregation of the group (like the number of elements in it).

Jeroen
  • 1,638
  • 3
  • 23
  • 48
  • Thank you so much Jeroen. Your guidance helped perfectly. I got the sub-header working on my report. Thanks again for your help :) – talon Feb 19 '17 at 23:00