04-15-2022 01:14 PM - last edited on 05-23-2023 08:56 AM by JackLacava
GOAL
Export cube view to Excel with Landscape printing orientation.
METHOD
There is a cube view setting on the Advanced tab, labeled as Landscape = True/False. I have set that setting to Landscape = True.
RESULT
After exporting to Excel, the cube view fails to take on a landscape orientation, instead being portrait orientation.
Does anyone know how to set the Excel orientation within the cube view?
04-19-2022 06:18 AM
The Cube View setting [Landscape] (True/False) applies only to PDF (report view), and not to Excel.
There is an existing enhancement request TFS20360 for this to be added to the Excel export for cube views. I suggest logging a ticket with support with your customer name, and asking for your customer name to be added to this TFS number.
I don't think there is a code-workaround for this at the moment. The only way to do this would be to implement your own export-to-Excel button on a dashboard , which would run an Extender rule which uses DevExpress (or similar) APIs to create the Excel workbook extract.
Regards
Chris