Dynamic Columns based on a List of custom objetcs in model

[hgm]

I want to design a new report using a data model (Business Objects). My model contains a List of a custom object, which contains a property called Name among other properties. I want to be able to use the Name of these objects as my column names in a report. The length of the List can fluctuate (depending on the data). I intend to export the report to Excel.

To be more concrete, if I have this model:

Code: Select all

Model
  - Header
    - EvaluationUnits
      - Name
      - (other properties)

and let’s suppose that I have 5 EvaluationUnit objects in the EvaluationUnits property with the names: Name1, Name2, Name3, Name4 and Name5. Then I expect the report Header to look like so:

Code: Select all

Name1    Name2    Name3    Name4   Name5

Is it possible to build such a dynamic header (this would be the columns in the excel export)?

[HighAley]

Hello.

You could try to use Cross-Data band.
But you should repeat all structure of your Business Objects. Start with databand for Model, then Header, then EvaluationUnits.

Thank you.