create a dynamic table

[dzimmerman]

I need a way to create a dynamic table to be used as a datasource The number of columns will change based on the selection criteria see attached

[sean.lanktree]

Not sure that I am clear on your exact requirements. But maybe a combination of hiding/showing columns and changing column label text will help you. All of this can be done using app variables. Colors of cells can be derived through values of fields on each record so maybe you can include this in your data source. Do you already have a data source to feed this list?

[dzimmerman]

i wanted to build my data source on the fly inside of the rpg program as the number of columns and column headers will change.based on user selection. i guess i could try creating a generic table with what i think will be the maxinum number of columns needed and then hide columns and adjust the headings inside valence.