Creating reports and dashboards | Stimulsoft community forum

Posted: **Wed Nov 25, 2015 3:06 pm**

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)?

Posted: **Fri Nov 27, 2015 10:36 am**

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.

Creating reports and dashboards | Stimulsoft community forum

Dynamic Columns based on a List of custom objetcs in model

Dynamic Columns based on a List of custom objetcs in model

Re: Dynamic Columns based on a List of custom objetcs in mod