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 ChristineH
Certified Lead Developer
over 7 years ago

We have been able to implement a report (SAIL Interface) with a variable number of columns. Our use case is that there are any unknown number of vendors submitting. We need to see each vendor as a column to compare the details. We do this with a combination of gridcolumn and applycomponents.
I will see if some of my teammates can reply with more direction.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 7 years ago

We have been able to implement a report (SAIL Interface) with a variable number of columns. Our use case is that there are any unknown number of vendors submitting. We need to see each vendor as a column to compare the details. We do this with a combination of gridcolumn and applycomponents.
I will see if some of my teammates can reply with more direction.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data