Database Reference
In-Depth Information
Figure 9-29.
The Create Named Query dialog window
Named Calculation
Named calculations allow you to modify a portion of the underlying SQL statement that is used by a data source
view. A named calculation is similar to a named query, except that you add only a SQL expression to an existing
statement, rather than using a whole SQL statement.
To create a new named calculation, right-click the data source table and select New Name Calculation from
the context menu. This launches the Create Named Calculation dialog window. Provide a name and description
for the calculation, followed by the SQL expression that defines the results to be returned when the underlying
SQL statement runs.
For example, let's say we want to have a fancy version of a month's name available for reporting purposes. By
creating a named calculation (Figure
9-30
), you are able to add a new column to the data source view table using
this SQL code:
'The Month of'
+
MonthName
+
'in the year'
+
YearName
.
