This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

Embed your report into website publish to web

With SeekTable "Get Shareable Link" function you can easily embed saved reports in other web pages, such as in blog posts, websites, through emails or social media, on any device. Embedded reports update as the underlying data changes, or when you change them in your SeekTable account. The person accessed embedded report don't need to have SeekTable account; this means that the report you publish can be viewed by anyone on the Internet who knows the link.

How to embed the report with an iframe

  1. In the report view publish your report to web and get its public link (menu "Share"→"Get Link"). If you don't see "Get Link" item please ensure that you saved the report.
  2. Insert into your web page iframe HTML element:
    <iframe border="0" frameborder="0" 
        width="800"
        height="600"
        src="https://www.seektable.com/public/report/52e164d33144441582d6b9114eec12e8"></iframe>
    
    In src attribute specify your link of the published report; with width and height specify desired report size.
  3. As result you should get something like that (this is a report from demo.seektable.com.):

    If you want to hide report name this is possible with adding show_report_name=false parameter to the report public URL (this option works only when report is embedded with IFRAME).

Hint: you can easily organize custom web dashboards by embedding several reports on one web page.

User-defined report parameters

If cube of the report has parameters (any non-CSV data source) you can provide them with report_parameters in a query string of public report URL, for example:

In this way you can enable user-defined report parameters for the report embedded into your web page:

You may use js code from this JSFiddle example and adopt it for your own parameters and input controls.

Advanced publishing/embedding paid subscription option

Users with this paid subscription option can use advanced features of published reports that are listed below.
If you are interested in trial please contact us.

Enable exports for published report

To display export buttons specify export=pdf,excel parameter (comma-separated list of supported formats) which enables "Export to <format>" buttons at the ending of the report:

https://www.seektable.com/public/report/52e164d33144441582d6b9114eec12e8?export=pdf,excel

Supported formats are: pdf, csv, excel, html, json, excelpivottable (this one works only for pivot table reports).

By default only data that is visible in the report web view is exported; if you want to export all data (disregard pagination and report "Limits" settings) you can specify rows/columns limit for export with export_limit=1000 parameter. Max possible value is export_limit=50000.

When report is embedded with IFRAME it is possible to place custom export buttons in the "host" web page and initiate export with javascript as illustrated by this JSFiddle example.

Enable sorting / pagination

Advanced publishing option enables pagination if published report has large pivot table (normally only current 'page' is displayed for such reports).
In addition to that, you can allow users to change table sorting by adding sort=true parameter:

https://www.seektable.com/public/report/52e164d33144441582d6b9114eec12e8?sort=true

Enable inputs for report parameters

You can enable inputs for entering parameters by viewers by adding parameter=filter_year,filter_country:

https://www.seektable.com/public/report/1b0509d283904b4995f6968bdd4793f7?parameter=filter_year,filter_country
filter_year and filter_country are parameter names specified in the cube configuration. Parameter order is important: inputs are displayed exactly in this order.

Refresh a report page automatically

Public report page can be refreshed automatically after some interval: users can keep public report link opened in the web browser and it will refresh automatically (without need to manually force page refresh). To enable auto-refresh add refresh_interval=5 parameter (interval value in minutes) to the report public URL , for example:

https://www.seektable.com/public/report/52e164d33144441582d6b9114eec12e8?refresh_interval=5

This feature is useful if you want to display real-time dashboard on office wall TV screen.
Note: minimal refresh interval is 5 minutes. If you need more frequent updates consider usage of self-hosted SeekTable: in this case you'll able to use refresh_interval=1 (every minute) refresh.

Apply user-defined parameters without IFRAME reload

If you use report parameters for embedded report data filtering you can avoid ugly IFRAME reload and refresh the report with new parameters in the following way (JSFiddle example):

var reportParams = {filter_year:1997};
var msg = JSON.stringify( {"action":"refresh","args":[reportParams]} );
window.frames.iframeName.postMessage(msg, "*");