search cancel

Export SQL Script to Clipboard and SQL Script to File option are grayed out for report. How to enable these options.

book

Article ID: 229890

calendar_today

Updated On:

Products

CA Client Automation - IT Client Manager

Issue/Introduction

Export SQL Script to Clipboard and SQL Script to File option are grayed out for report. How to enable these options. 

Environment

Release : 14.5

Component :

Resolution

The Reporter can export a SQL script, containing the SQL used for creating a result set (Right-click a Report Template and choose “Export | SQL script to file” or “Export | SQL script to clipboard”. This script is only valid for use on the database it was exported from. The script can be viewed in a text editor, or can be run from a SQL utility, for trouble shooting or performance testing.
Report Templates containing logical (non-DB) fields, e.g. Drives [All], cannot be expressed in a SQL script, as they require local processing. The SQL script export options will be unavailable for templates containing logical fields.

In Report, any field where we have multiple rows needs to be processed so cannot be exported to SQL format.

For Example:

Attachments