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 Kyle Jorgensen over 7 years ago

Thanks for all the feedback. The issue I am having is not around conditionally displaying fields, but rather allowing the interface to be able to handle additional customer accounts being added without requiring modifications. If a new customer is added to the customer table then the report should have an additional column added without any designer update to the interface.
@ravitejavj The users would prefer to have this functionality within Appian reports rather than having a xlsx file download. The max column approach sounds like it could work; how do you map the CDT to the underlying view in that case?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Kyle Jorgensen over 7 years ago

Thanks for all the feedback. The issue I am having is not around conditionally displaying fields, but rather allowing the interface to be able to handle additional customer accounts being added without requiring modifications. If a new customer is added to the customer table then the report should have an additional column added without any designer update to the interface.
@ravitejavj The users would prefer to have this functionality within Appian reports rather than having a xlsx file download. The max column approach sounds like it could work; how do you map the CDT to the underlying view in that case?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data