Creating a double bottom border in a custom report is a quick process:
1. Find the cell that needs the double bottom border.
2. If the row below the desired cell is not blank, insert a row below so that a blank row appears. It is in this blank row where the double bottom border will be applied.
3. To insert a new row below simply click the desired row where it should insert below, use the Insert option on the black navigation bar above the grid, and insert a row below the selected row.
4. In the blank row below the desired cell, click on the cell where the border should exist. For example, if cell D4 needs to show a double bottom border, click on cell D5 to apply the border.
5. In the screenshot below we see that the user has selected cell D12 because they wish to apply a border to cell D11 for Total Income value.
6. From the Home tab at the top of the grid, while still selecting the blank cell, click open the borders icon and apply both a Top and Bottom border to the cell. Hover over the options to see which is Top vs Bottom.
7. Once the Top and Bottom borders are applied to the cell, repeat if any other cells on the same row need to have the double border applied.
8. Once all cells on the same row have the top and bottom border applied click anywhere on the row, select the "Set Row Height" button at the top-right of the grid, and set the row height to 3 pixels.
9. If this double bottom border is the LAST cell in the report be sure to perform the below steps as the double bottom border will not appear in preview, exports or downloads if a formatting feature is the last item in the report. You must add a row with false data and hide the row below the border. This is because a formatted row without any data or text cannot be the last one in the report:
- migrate to a row below the double border formatted row and placed a value/text/number in a cell
- on that same row, right click the row header and "hide" the row with the fake information
- save the report