DataSource

DataSource is a text function that returns the application name, database, or alias table name of a grid. Use DataSource in a text box, text cell, or a row or column heading.

Syntax:

<<DataSource("GridName,InfoType")>>

Argument	Description
GridName	(Required) Any grid in a report, enclosed in quotes.
InfoType	(Required) One of the following keywords: App returns the application name. DB returns the database name. Alias returns the alias table name. To return the alias, the grid must have the alias table enabled. By default, the alias table is disabled. Name returns the database connection name associated with the specified grid. Note "Server" is not supported as an argument for InfoType. for Planning data sources.

Argument

Description

GridName

(Required) Any grid in a report, enclosed in quotes.

InfoType

(Required) One of the following keywords:

App returns the application name.
DB returns the database name.
Alias returns the alias table name. To return the alias, the grid must have the alias table enabled. By default, the alias table is disabled.
Name returns the database connection name associated with the specified grid.

Note

"Server" is not supported as an argument for InfoType. for Planning data sources.

Note:

All arguments are case insensitive.

Example

Insert data source information in your report:

<<DataSource("Grid1", DB)>>