You can insert a single data item anywhere in your report using the singleton object. The singleton object retrieves only the first row value for that query. Inserting a single data item is useful when you want to show a value that is independent from the rest of the values in the report or when you want to insert some boilerplate text, such as a company name and address. For example, you can add the total revenue value in the header of each page in a report.
You can associate multiple singleton objects to a single query to
optimize performance, such as when all the data items in the singleton
are from the same database table. In addition, two or more singletons
can reference data items from the same query. This is useful when
using a single query is more efficient to display a set of single
values than using multiple queries.
You can also filter the data item in the singleton. For example, you can show the total revenue for only the year 2007.
Queries that are associated to a singleton object are not supported when producing report output in delimited text (CSV) format.
In the Insertable Objects pane, on
the Toolbox tab ,
drag Singleton to the report.
An empty data container is created.
From the Insertable Objects pane, on the Source tab, drag a data item into the Singleton container.
If you want to change the query associated to the singleton object, in the Properties pane, double-click the Query property.
When the report is run, the first row value for the data item is retrieved.