Is it possible the have expand/collapse option similar to Excel in App studio reports or when I export a report to excel can I have few columns have expand/collapse option?
Hello @Sethupathy T can you be more specific please? It is not clear to me what you want, could you share some screenshots please?
BR,
VH
Hi, In the attached screenshots few records were grouped and we can Expand/Collapse the records in Excel. Is it possible to achieve it in App studio reports and when exported to Excel, will the Group/Ungroup feature be available in Excel file?
I don't believe that is possible in App Studio. You can achieve some of the collapsing/expanding using a hyperblock, but it doesn't export to Excel with the grouping. The Excel integration tool may be a better solution but that would require you to maintain a duplicate report if you still wanted to view it the report in EPM.
Thanks Arnie! will work on it
If I remember correctly, it was implemented (by Heiko +- 199?-200?), but I’m not sure how far it got — it was never fully enabled. Still, there are some parts of the code that handle it. Unfortunately, we definitely never implemented export to Excel.
If you need to hide or show rows/columns, you can use a variable to control the row height. You can set it as a number for the size, or simply TRUE/FALSE to switch visibility. However, Excel does not support controlling size by variable — during export it just takes the current size and exports it as is. (If I remeber implementation..)
And of course, for dynamic and hierarchical data retrieved from the database, you can take advantage of the Hyperblock feature, as Arnie suggested…
