I have a cube view that I have a spacer columns in. I would like to keep these columns but need their width narrowed when I export it the CV to a report.
Here is what it currently looks like when I run the cube view:
The spacers here are perfect.
But here is what it looks like when I export to a report:
The spacers revert back to full width. Is there a way to get them not to do this? Additionally, is there a way to get rid of the dashes in the title rows? It is set to an intersection that will never have data so I could have a clean title row in the CV, but shows the dashes like this when I export it as a report.
Really looking for how best I can control/adjust the formatting of any CV I generate into a report.
Hi - There are three sections for the header and cell formatting: cube view, Excel, Report
If you go to header format scroll down to the Report section there'll be a ReportColumWidth. In the screenshot below, I have set mine to 15 but you may have to try it out with different numbers to get your desired look.
There'll also be a section for ReportNoDataNumberFormat in the cells. I usually put a # there and that might fix your issue with the dash.