1. Graphical procedures
Graphical procedures are flowcharts that implement the logic of
the report. They perform database retrievals, calculations,
conditional checks, text formatting and many other tasks that may be
required for producing reports. Procedures represent the business
logic layer of SCRIBE. See the overview for more info.
2. Graphical page layout
Graphical page layout is done with the Print Templates - print
forms that define the location and visual attributes of printed data
fields. Print templates receive their data content from the
Procedures and format and display it according to the layout. Print
Templates represent the presentation layer of SCRIBE. See the
overview for more info.
3. Pie, bar and line charts
SCRIBE is capable of displaying both text and images, including
dynamically generated Pie, Bar and Line Charts, with the rich set of
controls for fine-tuning the appearance of the charts.
4. Exporting data into ASCII files
Data extracted from the database tables, or created by the Procedure,
can be exported into a comma- or blank-separated ASCII text file,
suitable for further processing by various third-party applications,
such as spreadsheets.
5. Adding custom Java code
SCRIBE provides a plug-in mechanism for adding custom Java code to
its body. The added code is shown as graphical Functions - "black boxes"
with optional input and output parameters and return values that can be
placed into the Procedure. The custom code plug-in extends the
functionality of SCRIBE beyond the standard feature set provided by
graphical Procedures and can be used to address issues like extracting
contents of custom-formed BLOBs.
6. Invoking through API
Third-party applications can request the SCRIBE server to execute
reports and forward the results to them. The API library provides the
transport layer that connects the application with the server, and
brings the reports into the program's address space as PDF-or HTML-formatted
data streams, or Java objects ready for display through the Swing-based
components provided by the library.
7. Running background jobs
Reports can be executed as stand-alone background processes that,
once launched, run independently until completion. The user is free to
perform other tasks with SCRIBE, such as configuring Print Templates and
Procedures, running other reports, etc. The progress of background jobs
can be monitored by the user.
8. Scheduling
Background jobs can be scheduled for automatic execution on a regular
basis, ranging from once every minute all the way to monthly
submissions.
9. Drill-down reports
"Drill-down" refers to the ability of the report to trigger execution
of other reports by mouse-clicking on selected fields. The triggered
reports, in their turn, can contain drill-down enabled fields that can
run lower-level reports, etc. There is no limit on the depth of the
drill-down. A single drill-down field can have more than one report
attached to it.
10. E-mailing reports
Generated reports can be e-mailed as PDF attachments or HTML-formatted messages, along with the
dynamically created plain text, to a preset list of addresses.
11. Web-publishing
SCRIBE provides a mechanism for displaying the reports in a standard
Internet browser, such as IE or Netscape. The reports can be requested
over the Web, and are delivered as HTML-based pages, or in the form of PDF streams displayable
through the Adobe Acrobat plug-in.
12. Updating database tables
In addition to extracting data from the database tables, SCRIBE
provides graphical tools for changing the table contents. These tools
are executable components available to a Process flowchart; they can
insert, update and delete rows in the table thus extending the
functionality of the report generator into the domain of graphical
database programming.
13. Multiple databases in one report
SCRIBE supports a number of relational databases. A Report Procedure
can do data retrievals from a number of tables/views that belong to
different databases. For example, it is possible to draw customer order
data from tables located in MS SQL Server, and product descriptions from
tables maintained by Oracle - all within the same report.
14. Security
Access to SCRIBE reports, and user privileges for accessing various
SCRIBE tools is controlled by the user
login
accounts,
passwords and
access
rights maintained by the SCRIBE Administrator.
15. Multiple concurrent users
SCRIBE server can accept concurrent connections from users on the
Local Area Network running SCRIBE Client, as well as Internet users over
the Web.
16. X-platform deployment
SCRIBE client and server are written in 100% Java, with no
platform-dependent parts.
SCRIBE can be deployed in a mixed environment,
e.g. with the server running on Linux, and clients installed on Windows.