Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Custom Report will draw from any currently created Custom Reports that are available. Simply click the ‘Custom Report’ picker in the ‘Custom Report' tab. A Custom Report can only be Exported as one of several desired 'File Types'; 'PDF', 'Word Document', 'Excel File', 'Rich Text File (rtf)', or 'CSV'exported as a PDF. The Filename 'Prefix' field and is optional but the 'Extension' may also be optionally selectedwill be set to 'pdf’.

Source Data - SQL

...

To Export as a SQL Query, the User must specify a Delimiter and optionally specify the Enclosure. The Filename 'Prefix' field and 'Extension' may also be optionally selected. These will set the name of the file after it is Exported. SQL must be entered manually as a SQL Query in the 'SQL Query' tab. SQL Select into File Command (MySQL Only) allows you to set the SQL query to a file on the server. This is good if you need to view a lot of data that is limited by Adhoc and Import limitations.

...

An E911 file can be exported as one of three different 'File Types': Fixed Width , or Delimited, or Crystal Report.

When Exporting an 'E911' file, there are three tabs of information to be considered: Columns, Header/Footer Lines, and Schedule/Event.

...