05-30-2023 04:57 PM - last edited on 05-31-2023 05:40 AM by JackLacava
Hello,
I'm currently trying to build a CV for my team. In the column filter I have time as the first member filter and account as the second member filter, but when I put as my account name A#None:Name(" ") it still gives a the WF Time. Is there a way to make it show as blank? Sort of like the account? I have a parameter created where it makes the background and text to be the same color and I would think it would also make everything show as blank, but it doesn.
This is the parameter for the blank row
Thanks,
Will
Solved! Go to Solution.
05-30-2023 10:57 PM
For Blank columns, please try updating the Member Expansion 1 as T#|WFTime|:Name( )
05-31-2023 02:37 AM
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 If
You 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
05-30-2023 10:57 PM
For Blank columns, please try updating the Member Expansion 1 as T#|WFTime|:Name( )
06-02-2023 11:28 AM
Thanks AK. That did the trick.
05-31-2023 02:37 AM
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 If
You 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
06-02-2023 11:27 AM
Thanks Dimitrios! I will updated my parameter to include that!
Will