Skip to content

Sample Report: Using XSLT to display SEO characteristics

Mark-89 edited this page May 8, 2018 · 4 revisions

This sample will only work for versions higher than Reports 06.00.00!

The sample report in this short tutorial uses XSLT to display the SEO Characteristics of the site. If the texts are too long they get displayed in red.

  1. Go to a Reports module.
  2. Select Manage > Settings from the module actions menu.
  3. Go to the Data Source Settings section of the Report Settings tab.
  4. In the Title text box, enter SEO Characteristics.
  5. At Active Data Source, select DotNetNuke Data Source.
  6. In the Query text box, enter the query below:
    SELECT T.Title AS Title, T.Description AS Description, T.KeyWords AS Keyword FROM {oQ}Tabs AS T WHERE T.Title <> ''
  7. Go to the Display and Caching Settings section and mark the Show Info Pane and Auto Run Report check boxes.
  8. At Active Visualizer, select XSL Transformation Visualizer.
  9. In the Location: (Enter The Address Of The Link) text box, enter https://raw.githubusercontent.com/DNNCommunity/DNN.Reports/development/wiki.images/DNN%20Reports.xsl.
  10. Click the Update button.


Sample Report: Using XSLT to display SEO characteristics