Data source editing

Double-clicking on an individual table in a data source component or right-clicking it and clicking Edit opens the Edit Data Source window, where the following parameters can be configured:

• Name in Source: The connection where this data source is located.
• Name: Reference to the data source used in Reporting.
• Alias: Alternative reference that can be more descriptive.
• Run : Checks the SQL statement validity.
• Edit Query : Opens a dedicated SQL query edit window.
• View Data : Checks the result of the input SQL query by displaying resulting data.
• Query Text: Used to input the SQL query.

Note For security and practical reasons, queries should be filtered and limited to display only authorized (allowed for the Viewer or Designer) and relevant (filtered by user set parameters) data. For additional information on database queries consult Database queries.

• Type: Define whether the statement is a Query or a Stored Procedure.
• Query Timeout: Define the execution time for the database query in seconds.

In the bottom part of the window, there are details on imported columns of the data source. To edit an existing column or parameter, locate it in the provided list. It is possible to expand or collapse the list for easier navigation. You can edit the data of the existing columns and/or parameters or do the following:

• New Column : Add a new column to the data source and define its data.
• New Calculated Column : Add a new calculated column to the data source and define its data.
• New Parameter : Add a new parameter to the data source.
• Delete : Delete a selected column or parameter (new or original).
• Retrieve Columns : Retrieve queried columns from the data source. If an imported column is modified, this will retrieve a copy of the original column and keep the modified version.

To finish, click Save a Copy to save a copy of this modified data source along with the original, or click OK to overwrite the original settings of this data source.