• Documentation
  InstallationUsing the Kentico interfaceDeveloping websitesConfiguring KenticoManaging usersSecuring websitesDeploying websitesManaging website contentMultilingual websitesMacro expressionsExternal utilitiesIntegrating 3rd party systemsCustom developmentE-commerce featuresOn-line marketing featuresIntranet featuresCommunity featuresRunning Kentico on Windows AzureReferences
• Tutorial
  Using the Kentico interfaceManaging content - The basicsSite development overviewCreating pages using the portal engineWalkthrough - Creating a new site using the Portal engineCreating pages using ASPX templatesWalkthrough - Creating a new site using ASPX templates

Switch to the View tab to see the report table.

Creating a new graph

1. Switch back to the report's General tab.
2. Click New in the Graphs section below the layout editor.
3. Enter the following values:

   • Display name: Favorite Page Templates

   • Query:

     SQL

     Copy

     SELECT TOP 5 PageTemplateDisplayName AS [Template Name], COUNT(PageTemplateDisplayName) AS [Usage]
      FROM View_CMS_Tree_Joined
      LEFT JOIN CMS_PageTemplate 
      ON CMS_PageTemplate.PageTemplateID = View_CMS_Tree_Joined.DocumentPageTemplateID
      WHERE PageTemplateDisplayName IS NOT NULL AND PageTemplateIsReusable = 1
      GROUP BY PageTemplateDisplayName
      ORDER BY COUNT(PageTemplateDisplayName) DESC

   • Graph type: Pie chart

   • Drawing style: Pie

   • Title: Favorite page templates

   • Series -> Display item value: Disabled (not checked)

4. Click Save & Close.
5. Place the cursor in the layout editor on a new line under the table.
6. Select the graph from the list in the Graphs section.
7. Click Insert.
   • The system adds a string like %%control:ReportGraph?PagesByPageTemplate.MostFavoritePageTemplates%% into the text area.
8. Click Save to save the changes.

 If you now switch to the View tab, you can see the report graph.

Creating new values

1. Switch back to the report's General tab.
2. Click New in the Values section below the layout editor.
3. Enter the following values:

   • Display name: Number of pages with page template

   • Query:

     SQL

     Copy

     SELECT COUNT(DocumentID)
      FROM View_CMS_Tree_Joined
      WHERE DocumentPageTemplateID IS NOT NULL

   • Is stored procedure: no

   • Formatting string: Pages with template: {0}

4. Click Save & Close.
5. Place the cursor in the layout editor under the graph.
6. Select the new value from the list in the Values section.
7. Click Insert.
   • The system adds a string like %%control:ReportValue?PagesByPageTemplate.NumberOfPagesWithPageTemplate%% into the text area.
8. Click Save.

 If you switch to the View tab, you can see the text of the value.

Defining report parameters

1. Switch to the Parameters tab.
2. Click New field and enter the following values:
   • Field name: UserID
   • Field type: Integer number
   • Default value: 53
   • Field caption: Created by user
   • Form control: User selector
3. Click Save.

Now you need to add the parameter to your queries. For the purposes of this example, modify only the table query.

1. Switch to the General tab.

2. Select Pages by page template in the Table list.

3. Click ... next to the New button and select Edit.

4. Modify the table SQL query like this:

   SQL

   Copy

   SELECT PageTemplateDisplayName AS [Template Name], DocumentNamePath AS [Document]
    FROM View_CMS_Tree_Joined
    LEFT JOIN CMS_PageTemplate
    ON CMS_PageTemplate.PageTemplateID = View_CMS_Tree_Joined.DocumentPageTemplateID
    WHERE PageTemplateDisplayName IS NOT NULL AND DocumentCreatedByUserID = @UserID
    ORDER BY PageTemplateDisplayName

   This adds the parameter to the WHERE condition of the query. All parameters that you define can be used in the query using the @<ParameterFieldName> expression.

5. Click Save & Close.

Now switch to the View tab. You can see that the report has a filter:

The table now only displays template names of documents that were created by the user specified in the filter.