sreport Command—Store Report Definition in a Database

The sreport command writes a Report Writer report definition into the specified database. You can also use this command in conjunction with the copyrep command to copy a report from one database to another, or from one owner to another. For a complete description of sreport, see the Character-based Querying and Reporting Tools User Guide.

The sreport command has the following format:

sreport dbname |vnode::dbname[/server_class] filename [-s] [-uusername]
[-Ggroupid]

• dbname

  Specifies the name of the database that is to contain the report, and the vnode and server_class, if required, as described in Standard Flags and Parameters.

• filename

  Specifies the name of a text file containing report-formatting commands for one or more reports. If you do not specify a full directory path name, Report-By-Forms assumes the current directory.

  Report-By-Forms prompts you for this parameter if you do not include it on the command line.

  The default extension for this file is .rw.

• -s

  Suppresses status messages.

• -uusername

  Specifies the effective user for the session, as described in Standard Flags and Parameters.

• -Ggroupid

  Specifies a group identifier, as described in Standard Flags and Parameters.

  On VMS, enclose this parameter in double quotation marks ("Ggroupid").

sreport Example

This command stores report definitions in the repdef.rw file into the Reports Catalog of the mydb database:

sreport mydb repdef.rw