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 that renders a link (<a> tag)
Html.Raw that prevents HTML-encoding of the content and allows you to render custom HTML code.
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
```
  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.