How to show Time header in a column to show blank in a CV
- 2 years ago
For Blank columns, please try updating the Member Expansion 1 as T#|WFTime|:Name( )
- 2 years ago
Hey WillVitale, AK's recommendation should do the trick. Also to make your life easier in your parameter you can add the below statement, and then just rename the columns you need as dividers to include the word "blank". (same applies to Rows, just use RowName instead).
If (ColName Contains 'Blank') Then
ReportNoDataNumberFormat = [" "], Bold = False, ReportUseTopBorder = False, BackgroundColor = Transparent, GridLinesColor = Transparent, NegativeTextColor = Transparent, SelectedGridLinesColor = Transparent, TextColor = Transparent, WriteableBackgroundColor = Transparent
End IfYou can then update your "Cell Format" default and all blank columns / rows will update automatically.
In addition, under Header Format; you can add ShowDimensionImages = False (just makes it a bit prettier)
Hope that helps!
Dimitrios