12-04-2023 09:17 AM
Hi team
How do I create a border across rows and columns, essentially creating a box around them? The use case is for showing the detailed amounts for a subtotal in the AFS, contained within the box - as seen in the screenshot attached. When trying to add borders to a cell, it automatically applied the border selection to the rest of the rows as well.
12-04-2023 09:19 AM
12-05-2023 08:26 AM - edited 12-05-2023 08:27 AM
Hi @AllisonM
Where are you looking to apply this?
I'm don't believe it is possible in cube views, but I'm sure it can be done in Excel or PDF reports using conditional formatting. The logic would depend on how you have configured your cube view, so we'd need a bit more information on how you are building the report to give advice.
Mark
12-05-2023 08:45 AM
Hi @MarkBird
Thank you for your reply! Yes, it would be for Excel and PDF reports. The cube view is setup as follows:
Allison
12-05-2023 09:45 AM - edited 12-05-2023 09:46 AM
A starter for 10 (note, it only applies the excel formatting for now):
You could try adding something like this to the default cell format of the cube view:
If (ColName Contains 'LEFT') Then
ExcelLeftBorderColor = Black,
ExcelLeftBorderLineStyle = Thin,
Else If (ColName Contains 'RIGHT') Then
ExcelRightBorderColor = Black,
ExcelRightBorderLineStyle = Thin,
End If
If (RowName Contains 'TOP') Then
ExcelTopBorderColor = Black,
ExcelTopBorderLineStyle = Thin,
ExcelLeftBorderLineStyle = None,
ExcelRightBorderLineStyle = None,
End If
If (RowName Contains 'BOTTOM') Then
ExcelBottomBorderColor = Black,
ExcelBottomBorderLineStyle = Thin,
ExcelLeftBorderLineStyle = None,
ExcelRightBorderLineStyle = None,
End If
It would require that you add 'LEFT' / 'TOP' etc to the relevant rows and columns, e.g. :
AssetArise > 'Asset Arise LEFT'
ContrRec > 'ContrRec RIGHT'
12-06-2023 07:09 AM
I tried this, as well as variations of this condition, but it won't work because of the way I've set up the rows and columns. Thank you though! It'll definitely come in handy with other reports.
Reasons it won't work:
12-06-2023 07:34 AM
Where there's a will, there's a way!
A few things that you could try:
1) If you know the member name of the first and last members you could change the if statement to look at the member name instead of the column name "If (ColE1MemberName Contains..."
The same could apply to rows using RowE1MemberName
2) You could add a 'blank' column as the first and last columns use additional settings to change the columns widths, font colour, etc of these columns.
Mark