Kentico CMS 6.0 Context Help

New/Edit value button

New/Edit value button

Previous topic Next topic Mail us feedback on this topic!  

New/Edit value button

Previous topic Next topic JavaScript is required for the print function Mail us feedback on this topic!  

This form is used for defining report values. You can switch to the Preview tab at any time to see the output of the value. You can find descriptions of particular value properties in the following table:

 

Display name

The name of the value shown in the user interface

Code name

Name used in your code

Query

Here you can add the SQL query used to retrieve data to be displayed by the value.

 

For security reasons, the Edit SQL queries permission for the Reporting module is necessary to edit this property.

Is stored procedure

Indicates if the query is a stored procedure or not.

Formatting string

You can format the displayed value using the standard .NET expressions. Examples:

{0} - displays the value

{0:F1} - displays the value as a floating point number with one digit displayed after the decimal point

You can find more details in .NET Framework documentation.

 

More resources can be found at:

 

Developer's Guide -> Modules -> Reporting -> Overview

Developer's Guide -> Modules -> Reporting -> Creating a new report -> Creating a new Value