tree grid downloand/pdf ability

[dzimmerman]

Morning,

Just a general question, i am creating a new application and the requirements are to be able to download either to pdf or excl. Also to be able to expand to multiple level. I am trying to decide on a regular grid or a tree grid. could i link 2 regular grids (ie click on one row to show details in another grid)...this way i can use the download features in valence. Or do i use a tree grid but then i lose the ability to download to excel or pdf?

[sean.lanktree]

You can certainly use 2 separate grids to display your data. However, the PDF/Excel download will be limited to each one. Are you summarizing data? If so, maybe the Pivot Grid would fit your needs.

Otherwise, you could always add a download button and have it call an RPG program that then uses the vvOut_execSqlToSS/CSV to create your file. In this case you would likely need to populate a temp type table that has the columns you need and then populate it in your program. Then you can call vvOut_execSqlToSS/CSV to generate the file.