This documentation page assumes that you already have a SeekTable account. Create your free account by signing up.

Report HTML Formatting

SeekTable is a web-based tool and you can specify custom HTML formatting for table cells. This formattings is applicable for report web view, PDF and HTML exports (including the case when a report is placed into an email body). Technically HTML formatting can be configured for calculated cube members with help of special functions:

Html.Link to render a link (<a> tag).
This function affects cells in Excel exports!
Html.SetTextColor to set the color of the text (applied to cell's tag TH/TD).
This function affects cells in Excel exports!
Html.SetBackgroundColor to set background color of the text (applied to cell's tag TH/TD).
This function affects cells in Excel exports!
Html.Raw that allows you to render a custom HTML code inside the table cell. With 2nd argument it is possible to provide a different value for non-HTML exports (CSV, Excel, JSON).
Note: some tags are not allowed, like <script>, <iframe>, <link>, <meta>.

Conditional formatting in tables

You can specify customized cell style (color/background color, bold/italics, font size etc) based on cell values. The following expression highlights with red measure values that below some threshold:

Let's assume that Name of the measure you want to format is SumOfTotal
Go to Edit Cube Configuration and add new calculated measure:
- Set Type = Expression
- In Parameters click on + Value and set an expression:
```
SumOfTotal<200 ? Html.Raw( "<span style='color:red;'>"+Html.HtmlEncode(SumOfTotal)+"</span>", SumOfTotal) : SumOfTotal
```
  Or, if you want to have colors in the Excel export too:
```
Html.SetTextColor( Html.Raw( Format("{0:#.##}", new[]{SumOfTotal}), SumOfTotal),  SumOfTotal<200 ? "red" : null)
```
  Then add one more parameter to declare the name of measure that is used in the expression:
```
SumOfTotal
```
- Set Name = SumOfTotalFormatted
Create a report and use SumOfTotalFormatted measure for Values

Links and custom navigation

You can use HTML formatting for links rendering:

Let's assume that the cube has company_name and company_website_url dimensions
Go to Edit Cube Configuration and add new calculated dimension:
- Set Type = Expression
- Set Name = company_name_linked
- In Parameters click on + Value and set an expression:
```
Html.Link(company_website_url, company_name, true)
```
  Then add the following values to declare dimension names used in the expression:
```
company_name
```
```
company_website_url
```
Create a report and use company_name_linked dimension

In the same way you can render <img> tag and display images in the table cells.