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:

1. Let's assume that Name of the measure you want to format is SumOfTotal
2. 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
3. Create a report and use SumOfTotalFormatted measure for Values

Links and custom navigation

You can use HTML formatting for links rendering:

1. Let's assume that the cube has company_name and company_website_url dimensions
2. 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

3. 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.