Skip to main content This browser is no longer supported. Show Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Working with Labels
In this articleLabels are string constants displayed in the Business Central client that can be translated into multiple languages, such as captions, descriptions, or messages. This way, the user interface can be displayed in different languages. For more information on how translation is carried out in Dynamics 365 Business Central, see Multilanguage development. Label syntaxLabels have a specific syntax defined by a text constant followed by three optional parameters. They must be comma-separated, but the order of the parameters is not enforced. The parameters that you can set are described in the following table.
Using labelsA label can take the form of four different AL structures. It can be the property value of certain page and report properties, the label data type variable and a report or a page label. The different possibilities are explained in more detail below. PropertiesThe label syntax is used in properties that are set to display text on the user interface. It applies to the following properties:
The following example shows the label syntax when it is used as property value for the Caption property.
Label data typeThe Label Data Type denotes a string variable used to define error messages, questions, captions, tokens, or other text constants displayed to the user. The following code sample illustrates how to use the Label data type.
The Label variable names should have an approved suffix. For more information, see CodeCop Rule AA0074. Report labelsReport labels are used by RDL and Word report layouts as, for example, the caption for a field, the title for a chart, or the title for the report itself. For a code example on how to use report labels for an RDL layout, see Walkthrough: Designing a Report from Multiple Tables. Report labels are defined inside the
Page labelsPage labels are used to display plain text on a page, such as instructions or
informative texts. You can find several examples of page labels in the Rapidstart Services Wizard in page Page labels are defined by a
See AlsoWorking with labels FeedbackSubmit and view feedback for
The maximum row count for a chart query limits the number of rows in the base query, not the number of rows displayed. Your base query exceeds the maximum row count of %0. Please apply a filter to reduce the number of records in your base query.
The maximum row count for a Group By query limits the number of rows in the base query, not the number of rows displayed. Your base query exceeds the maximum row count of %0. Please apply a filter to reduce the number of records in your base query.
Group By Sort
Subscription
Column %0
3D
Actions
Actions Menu
Add
Add Subscription
Aggregate
Aggregates are displayed after each control break and at the end of the report.
Aggregation
Average
Count
Maximum
Median
Minimum
Mode
Sum
All
All Columns
Alternative
Alternative Default: %0
and
Apply
Ascending
As of %0
Average %0
between
Background Color
blue
Bottom
Calendar
Cancel
Category
Cell
Chart
Initializing...
Chart Type
Choose report download format
clear
Column
Columns
Column Heading
Column Heading Menu
Column Information
contains
does not contain
in
is not in the last
is not in the next
is in the last
is in the next
is not null
is null
like
not in
not like
matches regular expression
Computation
Create a computation using column aliases.
(B+C)*100
INITCAP(B)||', '||INITCAP(C)
CASE WHEN A = 10 THEN B + C ELSE B END
Compute
Control Break
Control Breaks
Count Distinct
Count Distinct
Count %0
Daily
Report data as of %0 minutes ago.
Date
Day
Default
Default Report Type
Delete
Delete Checked
Would you like to delete these report settings?
Would you like to perform this delete action?
Delete Report
Descending
Description
Single Row View
Direction
Disable
Disabled
Display
Displayed
Displayed Columns
Display in Report
Down
Download
- Do not aggregate -
Do Not Display
Edit Alternative Default
Edit Chart Settings
Edit Chart
Edit Filter
Edit Group By
Edit Highlight
Email Address
Bcc
Body
Cc
Frequency
Email has not been configured for this application. Please contact your administrator.
See attached.
Subject
To
Enable
Enabled
Enable/Disable
Error
Examples
Examples:
Exclude Null Values
Expand/Collapse
Expression
Filter
Filter Expression
Filters
Filter Type
Select columns to search.
Flashback
A flashback query enables you to view the data as it existed at a previous point in time.
Unable to perform flashback request.
Format
Format Mask
Function
Functions / Operators
Functions
Go
Group By
Group By Column
green
Horizontal Column
Help
An Interactive Report displays a predetermined set of columns. The report may be further customized with an initial filter clause, a default sort order, control breaks, highlighting, computations, aggregates and a chart. Each Interactive Report can then be further customized and the results can be viewed, or downloaded, and the report definition can be stored for later use. <p/> An Interactive Report can be customized in three ways: the search bar, actions menu and column heading menu.
The actions menu is used to customize the display of your Interactive Report.
Aggregates are mathematical computations performed against a column. Aggregates are displayed after each control break and at the end of the report within the column they are defined. <p/> <ul><li><b>Aggregation</b> allows you to select a previously defined aggregation to edit.</li> <li><b>Function</b> is the function to be performed (e.g. SUM, MIN).</li> <li><b>Column</b> is used to select the column to apply the mathematical function to. Only numeric columns will be displayed.</li></ul>
You can include one chart per Interactive Report. Once defined, you can switch between the chart and report views using links below the search bar. <p/> <ul><li><b>Chart Type</b> identifies the chart type to include. Select from horizontal bar, vertical bar, pie or line.</li> <li><b>Label</b> allows you to select the column to be used as the label.</li> <li><b>Axis Title for Label</b> is the title that will display on the axis associated with the column selected for Label. This is not available for pie chart.</li> <li><b>Value</b> allows you to select the column to be used as the value. If your function is a COUNT, a Value does not need to be selected.</li> <li><b>Axis Title for Value</b> is the title that will display on the axis associated with the column selected for Value. This is not available for pie chart.</li> <li><b>Function</b> is an optional function to be performed on the column selected for Value.</li></ul>
Clicking on any column heading exposes a column heading menu. <p/> <ul><li><b>Sort Ascending icon</b> sorts the report by the column in ascending order.</li> <li><b>Sort Descending icon</b> sorts the report by the column in descending order.</li> <li><b>Hide Column</b> hides the column.</li> <li><b>Break Column</b> creates a break group on the column. This pulls the column out of the report as a master record.</li> <li><b>Column Information</b> displays help text about the column, if available.</li> <li><b>Text Area</b> is used to enter case insensitive search criteria (no need for wild cards). Entering a value will reduce the list of values at the bottom of the menu. You can then select a value from the bottom and the selected value will be created as a filter using '=' (e.g. column = 'ABC'). Alternatively, you can click the flashlight icon and the entered value will be created as a filter with the 'LIKE' modifier (e.g. column LIKE '%ABC%').<li><b>List of Unique Values</b> contains the first 500 unique values that meet your filters. If the column is a date, a list of date ranges is displayed instead. If you select a value, a filter will be created using '=' (e.g. column = 'ABC').</li></ul>
Computations allow you to add computed columns to your report. These can be mathematical computations (e.g. NBR_HOURS/24) or standard Oracle functions applied to existing columns (some have been displayed for example, others, like TO_DATE, can also be used). <p/> <ul><li><b>Computation</b> allows you to select a previously defined computation to edit.</li> <li><b>Column Heading</b> is the column heading for the new column.</li> <li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li> <li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li> <li><b>Computation</b> is the computation to be performed. Within the computation, columns are referenced using the aliases displayed.</li> </ul> <p/> Below computation, the columns in your query are displayed with their associated alias. Clicking on the column name or alias will write them into the Computation. Next to Columns is a Keypad. These are simply shortcuts of commonly used keys. On the far right are Functions. <p/> An example computation to display Total Compensation is: <p/> <pre>CASE WHEN A = 'SALES' THEN B + C ELSE B END</pre> (where A is ORGANIZATION, B is SALARY and C is COMMISSION)
Used to create a break group on one or several columns. This pulls the columns out of the Interactive Report and displays them as a master record.
To view the details of a single row at a time, click the single row view icon on the row you want to view. If available, the single row view will always be the first column. Depending on the customization of the Interactive Report, the single row view may be the standard view or a custom page that may allow update.
Allows the current result set to be downloaded. The download formats will differ depending upon your installation and report definition but may include CSV, XLS, PDF, or RTF.
Used to add or modify the where clause on the query. You first select a column (it does not need to be one that is displayed), select from a list of standard Oracle operators (=, !=, not in, between), and enter an expression to compare against. The expression is case sensitive and you can use % as a wildcard (for example, STATE_NAME like A%).
Performs a flashback query to allow you to view the data as it existed at a previous point in time. The default amount of time that you can flashback is 3 hours (or 180 minutes) but the actual amount will differ per database.
Highlighting allows you to define a filter. The rows that meet the filter are highlighted using the characteristics associated with the filter. <p/> <ul><li><b>Name</b> is used only for display.</li> <li><b>Sequence</b> identifies the sequence in which the rules will be evaluated.</li> <li><b>Enabled</b> identifies if the rule is enabled or disabled.</li> <li><b>Highlight Type</b> identifies whether the Row or Cell should be highlighted. If Cell is selected, the column referenced in the Highlight Condition is highlighted.</li> <li><b>Background Color</b> is the new color for the background of the highlighted area.</li> <li><b>Text Color</b> is the new color for the text in the highlighted area.</li> <li><b>Highlight Condition</b> defines your filter condition.</li></ul>
If you have customized your Interactive Report, the report settings will be displayed below the Search Bar and above the report. If you have saved customized reports, they will be shown as tabs. You can access your alternate views by clicking the tabs. Below the tabs are the report settings for the current report. This area can be collapsed and expanded using the icon on the left. <p/> For each report setting, you can: <ul><li><b>Edit</b> by clicking the name.</li> <li><b>Disable/Enable</b> by unchecking or checking the Enable/Disable check box. This is used to temporarily turn off and on the setting.</li> <li><b>Remove</b> by click the Remove icon. This permanently removes the setting.</li></ul> <p/> If you have created a chart, you can toggle between the report and chart using the Report View and Chart View links shown on the right. If you are viewing the chart, you can also use the Edit Chart link to edit the chart settings.
Resets the report back to the default settings, removing any customizations that you have made.
Saves the customized report for future use. You provide a name and an optional description.
At the top of each report page is a search region. The region provides the following features: <p/> <ul><li><b>Select columns icon</b> allows you to identify which column to search (or all).</li> <li><b>Text area</b> allows for case insensitive search criteria (no need for wild cards).</li> <li><b>Rows</b> selects the number of records to display per page.</li> <li><b>[Go] button</b> executes the search.</li> <li><b>Actions Menu icon</b> displays the actions menu (discussed next).</li></ul> <p/> Please note that all features may not be available for each report.
Used to modify the columns displayed. The columns on the right are displayed. The columns on the left are hidden. You can reorder the displayed columns using the arrows on the far right. Computed columns are prefixed with <b>**</b>.
Used to change the column(s) to sort on and whether to sort ascending or descending. You can also specify how to handle nulls (use the default setting, always display them last or always display them first). The resulting sorting is displayed to the right of column headings in the report.
Hide Column
Highlight
Highlights
Highlight Condition
Highlight Type
Highlight When
Interactive Report Help
Invalid
Invalid computation expression. %0
%0 is in the last %1
%0 is in the next %1
%0 is not in the last %1
%0 is not in the next %1
Keypad
Label
Axis Title for Label
Last Day
Last Hour
Last Month
Last Week
Last %0 Days
Last %0 Hours
Last %0 Years
Last Year
Line
The query is estimated to exceed the maximum allowed resources. Please modify your report settings and try again.
Maximum %0
This query returns more then %0 rows, please filter your data to ensure complete results.
Median %0
%0 minutes ago
Minimum %0
Month
Monthly
More Data
Move
Move All
Name
New Aggregation
- New Category -
New Computation
>
Next Day
Next Hour
Next Month
Next Week
Next %0 Days
Next %0 Hours
Next %0 Years
Next Year
No
- No End Date -
- None -
No aggregation defined.
No column information available.
No computation defined.
Nulls Always First
Nulls Always Last
Null Sorting
Flashback time must be numeric.
Sequence must be numeric.
Operator
orange
Other
Percent of Total Count %0 (%)
Percent of Total Sum %0 (%)
Percent of Total Count
Percent of Total Sum
Pie
<
Primary
Primary Report
Private
Public
red
Remove
Remove Aggregate
Remove All
Remove Control Break
Remove Filter
Remove Flashback
Remove Highlight
Rename Report
Report
Reports
Report does not exist.
Report Settings
< Report View
Reset
Restore report to the default settings.
Row
Rows
Row %0 of %1
Row Order
Rows Per Page
Row text contains
Save
Saved Report
Saved Report = "%0"
Save as Default
The current report settings are used as the default for all users.
Save Report
Search
Search Bar
Search Report
- Select Category -
- Select Column -
Select Columns
Computed columns are prefixed with **.
- Select Function -
- Select Sort Column -
Select Value
Sequence
Sort
Sort Ascending
Sort Column
Sort Descending
space
Status
Ending
Starting From
Sum %0
Text Color
days
hours
minutes
months
weeks
years
Top
Unauthorized
Column Heading must be unique.
Highlight Name must be unique.
unsupported data type
Up
Please enter a valid color.
Please enter a valid format mask.
Value
Axis Title for Value
Value Required
Vertical Column
View Chart
View Detail
View Group By
View Icons
View Report
Week
Weekly
Working Report
%0 days
%0 hours
%0 minutes
%0 months
%0 weeks
%0 years
Year
yellow
Yes
As Default Report Settings
As Named Report
Only displayed for developers
Expression 2
Invalid set of rows requested, the source data of the report has been modified.
Report
Reporting Period
Reset Pagination
Primary Default
%0 - %1 of %2 |