Command Line Operation - Edit Configuration File Manually

For the most part there isn't anything you can't do with the configuration file from the Command Line Wizard. If you are one of those people that like to do things the hard way, you can edit the configuration files manually.

The configuration files can be edited using any text editor like Notepad. By default the configuration files use a .clo extension but you can change this if it suits your needs better.

Format

The configuration files use the same type of format that is used in "ini" files. There are 4 main sections that you can enter the required settings into.

• MODE
  • Mode
    • P - Preview Mode (default)
    • Q - Quick Print Mode
    • E - Export Mode
    • S - Run a Scheduled Report
  • Man
    • 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
  • SchedName
    • Specify the name of the schedule to run. A list of possibilities can be found in the 'Report Scheduler' tab.
  • DiscardSavedData
    • 0 - Don't clear any data saved in the report file.
    • 1 - Clear all data saved in the report file. (default)
• LOGIN
  • Server
    • Name of the database server or DSN name.
  • Database
    • Name of the database you want to use.
  • UserName
    • The user name used to login to a database.
  • UserPass
    • The password used to login to a database.
• PARAM
  • 1
    • First parameter required by the report.
  • 2
    • Second parameter required by the report.
  • 3
    • Third parameter required by the report.
  • 4
    • Fourth parameter required by the report.
  • 5
    • Fifth parameter required by the report.
• PRINTING
  • Print
    • 0 - Don't print a copy of the report. (default)
    • 1 - Print a copy of the report.
  • Copies
    • Set the number of copies to print. The default is 1.
  • Select
    • 0 - Don't prompt user to select a printer.(default)
    • 1 - Prompt user to select a printer.
  • Printer
    • Sets the name of the printer to use
• FILES
  • Report
    • Full path to the report file you want to run. (e.g. C:\MyReport.rpt)
  • ExportFormat
    • 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
  • ExportFile
    • Full path to the export file name. (e.g. C:\MyReport.pdf)
  • Overwrite
    • 0 - Don't overwrite the export file if it already exists. The file will be given a new name (e.g. Export(1).pdf).
    • 1 - Always overwrite the export file if it exists.
  • Delete
    • 0 - Do not delete the file after sending the email. (default)
    • 1 - Delete the exported file after sending the email.
• EXPORTPAGES
  • All
    • 0 - Don't export all pages in the report.
    • 1 - Export all pages in the report. (default)
  • First
    • First page of the report to be exported.
  • Last
    • Last page of the report to be exported.
• HTML
  • MultiPage
    • 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.
  • PageNav
    • 0 - Don't insert hyperlinks to navigate from page to page. (default)
    • 1 - Insert hyperlinks to navigate from page to page.
  • EmbedHTML
    • 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
  • AllowMultipleFiles
    • 0 - Don't allow multiple XML files.
    • 1 - Allow multiple XML files to be created when required. (default)
• EXCEL
  • UseConstantColumnWidth
    • 0 - Don't use constant column widths. (works together with EA)
    • 1 - Use constant column widths. (default) (works together with EW)
  • ConstantColumnWidth (Used when EC=1)
    • Column with in points (default is 48)
  • AreaType (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
  • ConvertDateToString
    • 0 - Don't convert date values to strings. (default)
    • 1 - Convert date values to strings.
  • PageBreaks
    • 0 - Don't insert page breaks into file.
    • 1 - Insert page breaks into file. (default)
  • TabHasColumnHeadings
    • 0 - No column headings on tabs.
    • 1 - Column headings on tabs. (default)
  • UseTabularFormat
    • 0 - Don't use tabular format. (default)
    • 1 - Use tabular format.
  • UseWorksheetFunctions
    • 0 - Don't use worksheet Functions. (default)
    • 1 - Use worksheet Functions.
• MAIL
  • Type
    • MAPI - Send the email using MAPI. (default)
    • SMTP - Send email using the specified SMTP server.
  • Send
    • 0 - Don't send the exported file in an email. (default)
    • 1 - Email the exported file.
  • To
    • Email addresses of any recipients for the "To:" box. (e.g. user@mail.com; user2@mail.com)
  • Cc
    • Email addresses of any recipients for the "Cc:" box. (e.g. user@mail.com; user2@mail.com)
  • Bcc
    • Email addresses of any recipients for the "Bcc:" box. (e.g. user@mail.com; user2@mail.com)
  • Subject
    • Subject text of the email.
  • Message
    • Message body of the email. (Note - To send an email message with multiple lines, use <br> in the message where you want the following text to start on the next line.)

Example

This an example of a configuration file that is used to export a report into MS Word and email the file.

[MODE]
MODE=E

[FILES]
REPORT=C:\Example Reports\BlankReport.rpt
EXPORTFORMAT=MS Word
EXPORTFILE=C:\BlankReport
OVERWRITE=1

[PRINTING]
PRINT=1
COPIES=1

[LOGIN]
USERNAME=MyName
USERPASS=mypassword

[MAIL]
TYPE=SMTP
SEND=1
TO=user@mail.com; user2@mail.com
CC=user@mail.com; user2@mail.com
BCC=user@mail.com; user2@mail.com
SUBJECT=Test Subject
MESSAGE=Hello All,<br><br>This is a test email.<br><br>Regards,<br>Bob

[PARAM]
1=Param1
2=Param2

<< Previous - Index >>