BIRT, ppt - one slide per value in a category

#1

hi all,

I am struggling with BIRT. I want to use it to prepare standardized ppt project reports. The resulting ppt file should contain one slide per project value in the dataset.

Creating a one-slider report works very well, where I struggle is to loop over the projects:

  • in the Advanced BIRT Example workflow, it is shown that this can be done by putting the data to report in a Table report item, and then using the Table > Groups > Expression + Page Break option to limit the content of the table to whatever matches the expression (here, the project), and move to a new slide

  • what I want to achieve is more complicated, in the sense that the report is built on nested Grids :

but the Grid Report item does not have a Groups tab that I could use to loop over the project values, just like with the Table item.

So to summarize, the Grid gives me the flexibility to customize the report as I want, Table is not flexible but allows for the creation of one slide per project …What could be the way to go forward?

Thanks a lot in advance!!

0 Likes

#2

Hi @scfranck !

Welcome to our forum!

One possile way is to put the table report itens inside each part of the grid item. This would make it work!

Cheers,
Ana

1 Like

#3

Thanks Ana,

I figured out, for those interested this is how I did it:

  1. Create a 1*1 Grid
  2. Drag the dataset from the Data Set View panel in the Grid. This creates a Table object
  3. Select only the column containing the Identifier (one slide per value in that column)
  4. Remove the Header and Footer rows, remove the data object from the cell, leaving an empty table
  5. In the 11 Table contained in the 11 Grid, build up your report structure by adding one grid or more, configured as desired. You may need to nest Grids to obtain the desired outcome
  6. Within that Grid’s cells, drag the dataset again and keep in each cell the property of interest and the Project; this will create a Table object
  7. Remove the Header and Footer rows, delete the Project column, keep only the property of interest
  8. Add Text objects when needed
  9. In each of the “inner” tables, go to Filters and add a property: row[“Identifier”] equal to row._outer[“Identifier”]
  10. In the outer 1*1 Table, go to Properties and add a Page Break after, Always
2 Likes