Report with a variable number of columns

Kyle Jorgensen over 7 years ago

What would be the best approach to create a report with a variable number of columns?

I am creating a report that aggregates project cost data by customer and division that can be filtered by certain project attributes. I can create a DB view with a variable number of columns, but I'm not sure if Appian data types support a variable number of fields.

I've attached a mockup of what the base data looks like and what the report I am looking to create looks like.

Discussion posts and replies are publicly visible

Parents

0 jan.mensen1 over 7 years ago

I might be oversimplifying your request, but nonetheless: take the SAIL recipe for conditionally showing a column as a basis: http://ap.pn/2iNTKc9 Then you define an array of false and true per vendor that you can then apply as the condition to show or hide a column.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 jan.mensen1 over 7 years ago

I might be oversimplifying your request, but nonetheless: take the SAIL recipe for conditionally showing a column as a basis: http://ap.pn/2iNTKc9 Then you define an array of false and true per vendor that you can then apply as the condition to show or hide a column.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data