Command Line Operation - Settings and Examples

Format for running a report from the command line:
C:\Program Files\Easy View\EasyView.exe CMD OPT1=Setting1, OPT2=Setting2, OPT3=Setting3

Command Sections:

• The first section is always the full path to EasyView.exe. This is normally C:\Program Files\Easy View\EasyView.exe.
• The next section is always 'CMD'. This tells Easy View to expect more settings.
• The final section is the settings. These can vary depending on how the report will be run.

Options:

General Options

• R - Report File
  • Full path to the report file you want to run. (e.g. C:\MyReport.rpt)
• M - Run Mode
  • P - Preview Mode (default)
  • Q - Quick Print Mode
  • E - Export Mode
  • S - Run a Scheduled Report
• Man - Manual Mode
  • 0 - Run in automatic mode and do not prompt users for passwords etc. (default)
  • 1 - Run in manual mode. User will be prompted when required
• SN - Schedule Name
  • Specify the name of the schedule to run. A list of possibilities can be found in the 'Report Scheduler' tab.
• File - A configuration file can be used instead of specifying all of the commands at the command line.
  • Full path to the configuration file. (e.g. C:\MyConfig.clo)
• DD - Discard saved report data
  • 0 - Don't clear any data saved in the report file.
  • 1 - Clear all data saved in the report file. (default)

Login Settings

• SV - Database server name
  • Name of the database server or DSN name.
• DB - Database name
  • Name of the database you want to use.
• UN - User name
  • The user name used to login to a database.
• PW - Password
  • The password used to login to a database.

Report Parameters

• P1 - First parameter required by the report.
• P2 - Second parameter required by the report.
• P3 - Third parameter required by the report.
• P4 - Fourth parameter required by the report.
• P5 - Fifth parameter required by the report.

Printing Options

• P - Print out the report
  • 0 - Don't print a copy of the report. (default)
  • 1 - Print a copy of the report.
• C - Print Copies
  • Set the number of copies to print. (default is 1)
• SP - Select Printer
  • 0 - Do not bring up a dialog to select a printer. The default printer will be used. (default)
  • 1 - Bring up a dialog to select a printer. This is not recommended because the report will not be run until a user selects a printer.
• Prt - Sets the name of the printer to use
  • Use this option to set the name of a printer. The default Windows printer will be used if left blank.

General Export Options

• F - Export File
  • Full path to the export file name. (e.g. C:\MyReport.pdf)
• E - Export Format
  • Acrobat Format (PDF)
  • HTML 3.2
  • HTML 4.0
  • MS Excel 97-2000
  • MS Excel 97-2000 (Data Only)
  • MS Word
  • Rich Text Format
  • Separated Values (CSV)
  • Tab-separated text
  • Text
  • XML
• O - Overwrite File
  • 0 - Don't overwrite the export file if it already exists. The file will be given a new name (e.g. Export(1).pdf). (default)
  • 1 - Always overwrite the export file if it exists.
• Del - Delete the exported file when finished (only applies when the file is emailed)
  • 0 - Don't delete the file. (default)
  • 1 - Delete the file after sending the email.
• AP - Pages to export
  • 0 - Don't export all pages in the report. (Used with FP and LP options)
  • 1 - Export all pages in the report. (default)
• FP - First page to be exported (Only used when AP=0)
  • Number of the first page to be exported.
• LP - Last page to be exported (Only used when AP=0)
  • Number of the last page to be exported.

HTML Export Options

• HM - Break up into multiple HTML files
  • 0 - The entire report will be exported into 1 HTML file. (default)
  • 1 - Each page of the report will be exported into individual HTML files.
• HN - Page navigators (only used when HM=1)
  • 0 - Don't insert hyperlinks to navigate from page to page. (default)
  • 1 - Insert hyperlinks to navigate from page to page.
• HE - Embed HTML file into the email body (only used when S=1 and HM=0)
  • 0 - Don't embed the HTML file into the body of the email. (default)
  • 1 - Embed the HTML file into the body of the email.

XML Export Options

• XM - Allow multiple XML files
  • 0 - Don't allow multiple XML files.
  • 1 - Allow multiple XML files to be created when required. (default)

Excel Export Options

• EC - Constant column width
  • 0 - Don't use constant column widths. (works together with EA)
  • 1 - Use constant column widths. (default) (works together with EW)
• EW - Column width (Used when EC=1)
  • Column with in points (default is 48)
• EA - Area type (Used when EC=0)
  • 1 - Report Header
  • 2 - Page Header
  • 3 - Group Header
  • 4 - Detail (default)
  • 5 - Group Footer
  • 7 - Page Footer
  • 8 - Report Footer
• ED - Convert date to string
  • 0 - Don't convert date values to strings. (default)
  • 1 - Convert date values to strings.
• EP - Page breaks
  • 0 - Don't insert page breaks into file.
  • 1 - Insert page breaks into file. (default)
• EH - Tab has column headings
  • 0 - No column headings on tabs.
  • 1 - Column headings on tabs. (default)
• ET - Tabular format
  • 0 - Don't use tabular format. (default)
  • 1 - Use tabular format.
• EF - Worksheet Functions
  • 0 - Don't use worksheet Functions. (default)
  • 1 - Use worksheet Functions.

Email Settings

• S - Send Email
  • 0 - Don't send the exported file in an email. (default)
  • 1 - Email the exported file.
• To - Email "To" Recipient
  • Email addresses of any recipients for the "To:" box. (e.g. user@mail.com; user2@mail.com)
• Cc - Email "Cc" Recipient
  • Email addresses of any recipients for the "Cc:" box. (e.g. user@mail.com; user2@mail.com)
• Bcc - Email "Bcc" Recipient
  • Email addresses of any recipients for the "Bcc:" box. (e.g. user@mail.com; user2@mail.com)
• Sub - Email Subject
  • Subject text of the email.
• Msg - Email Message
  • Message body of the email.
  • If you want to add line breaks into the message body you must use \n where you want each carriage return.
• T - Email Type
  • MAPI - Send the email using MAPI. (default)
  • SMTP - Send email using the specified SMTP server.

Examples:

• Preview:
  C:\Program Files\Easy View\EasyView.exe CMD R=C:\BlankReport.rpt
• Quick Print:
  C:\Program Files\Easy View\EasyView.exe CMD M=Q,R=C:\BlankReport.rpt
  • Optional:
  • C=2 - Number of copies to print. (default is 1)
  • SP=1 - Select the printer (default is 0) (only works when MAN=1)
  • Prt=SomePrinterName (overrides the default Windows printer)
• Export:
  C:\Program Files\Easy View\EasyView.exe CMD M=E,R=C:\BlankReport.rpt,E=MS Word,F=C:\BlankReport
  • Optional:
  • P=1 - Send report to printer. (default is 0)
  • C=2 - Number of copies to print. (default is 1)
  • O=1 - Overwrite an existing export file. (default is 0)
  • Del=1 - Delete the file when the export is completed. (default is 0)
  • AP=0 - Don't export all pages. (default is 1)
  • FP=1 - First page to export.
  • LP=9 - Last page to export.
• Export with email:
  C:\Program Files\Easy View\EasyView.exe CMD M=E,R=C:\BlankReport.rpt,S=1,E=MS Word,F=C:\BlankReport,To=user@mail.com,Sub=Mail Subject,Msg=Mail Body
  • Optional:
  • T=SMTP - Set the email handler to an SMTP server.
  • P=1 - Send report to printer. (default is 0)
  • C=2 - Number of copies to print. (default is 1)
  • O=1 - Overwrite an existing export file. (default is 0)
  • Del=1 - Delete the file when the export is completed. (default is 0)
  • AP=0 - Don't export all pages. (default is 1)
  • FP=1 - First page to export.
  • LP=9 - Last page to export.
• From Config File :
  C:\Program Files\Easy View\EasyView.exe CMD File=C:\Mail.clo
  • If you add any of the options to this one it will override the corresponding setting in the config file.

Changing the separator character: You can change the the default separator character from a comma to another character by modifying the command line settings.

Examples:
Before: C:\Program Files\Easy View\EasyView.exe CMD M=Q,R=C:\BlankReport.rpt
After: C:\Program Files\Easy View\EasyView.exe CMD [?] M=Q,R=C:\BlankReport.rpt

This example changes the separator character from the default comma to a question mark. This setting can be changed to any single character as long as it does not violate any Windows command line rules (like using < or > for example). The character must be the first setting after the CMD text and be surrounded by [ on the left and ] on the right.

<< Previous - Next >>