Legacy Reports Modification

CA SDM lets you modify legacy reports or design your own reports. You can:
casm172
CA SDM lets you modify legacy reports or design your own reports. You can:
  • Modify legacy Summary, Detail, and Analysis reports to contain exactly the information you need, such as additional fields.
  • Produce a new report with any information available from the database in a format that is useful to you.
  • Pass arguments of variable information into the report by including command line arguments. Arguments can be values or expressions, such as the current value of a field or an SQL WHERE clause expression.
  • Generate reports at the command line, from a script file, or from a menu option.
Follow these steps:
  1. Design the report:
    • Decide what data you want to include in the report.
    • Create a report template that contains SQL-like queries, expressions, and functions to manipulate data, and statements to format the data for the printed page.
  2. Generate the report from:
    • The command line
    • A CA SDM menu option
    • A script file
If you have a third-party database system you can use its report generating tools to create reports with data from the CA SDM database. CA SDM provides several database views that simplify the process of creating modified reports using third-party database systems. See the documentation for your database system for information about reporting on databases.
Modify Crystal Reports
Before you can display any of these reports, the following conditions apply:
  • You must make the Crystal reports available to the Crystal Report Selector by copying them to the Crystal directory: $NX_ROOT/bopcfg/rpt.
  • Your database client must be up and running, with connectivity established to the database server running on the same or another computer. If you are using a CA SDM Client to run your Crystal or Access reports you need to have installed a database client for the specific database and have established connectivity with the database server in order to run these reports.
After creating any custom Crystal reports, perform the following:
  1. Copy custom Crystal reports to the following crystal directory:
    $NX_ROOT/bopcfg/rpt
  2. Add the file names of custom Crystal reports to the following configuration file:
    crystal.cfg
You can then access the Crystal reports by clicking Start on the taskbar, and then choosing Reporting, Service Desk Reporting (Crystal Reports) from the CA SDM menu (accessible from the Programs menu). The Service Desk Reporting (Crystal) window appears.
CA SDM clients cannot be upgraded. Therefore, if you create and use Crystal reports on the CA SDM Server and you plan to upgrade your version of CA SDM, you need to copy all custom reports to a different location so you will not lose them. Following the upgrade, copy the reports back to the $NX_ROOT/bopcfg/rpt Crystal directory and modify the crystal.config file to make them accessible from the Report Selector.