M2Soft Corp
 
 
 
Reporting Solution
   
Database Reporting Tool  
Reporting Tool Functions Reporting Tool Features Reporting Tool Applications Reporting Tool References
 
   
 System Configuration
 


 
 Reporting S/W product line consists of 3 major products as followed.

  • Report Designer Editor: Installed on both developer’s and user’s PC to design a Report Form.

  • Report Designer Viewer: Installed on end-users’ PC to print out and search reports.

  • Report Designer Server: Installed on Web Server for Reporting Management.

With Reporting S/W, basic Reporting System construction is possible only with Clients Modules, an Editor and a Viewer; Server Module whose DB main functionality is Database connection management provides much more convenient development environment and user environment with large-scale service.

 


   System Configuration Diagram  

Reporting Tool


 
   Report Designer Editor ( Reporting S/W Editor)  

easily create various, complex reports using convenient object editing features.


   Convenient GUI Environment rivaling that of World Processors
  • Easy report generation by editing various objects based on WISIWYG functionality.
  • World best table editing functionalities for expedient report creation.

   Powerful Query Functions

  • Dynamic Query
  • Multi(Sub) Query
  • Field Query
  • Stored Procedure Support
  • Preprocessing/postprocessing functions through PL/SQL (Oracle)

   Powerful Table Functions – Supporting various Report Forms

  • Supports the cross table – represents data with simultaneously repeating rows and columns
  • Supports the printing of tables with Multi-Columns page
  • Label Form (offering about 1,200 label templates)
  • Sub Sum / Total Sum / Group Sum
  • Record Grouping
  • Assigning repetition number of table / Drawing blanks
  • Merge Cell / Write Once Only

   Numerous Data Processing Functions

  • Image Data – Images stored in DB, Image Files
  • Large volume data such as Memo, LongRow and etc.
  • HTML Source Code

   Various Objects Insertion Function

  • Providing 35different types of chart (2D/3D, Multi Chart, Animation, Rotation, Zoom In/Out and user edit function)
  • Supporting 2D Barcodes and Postal Barcodes
  • Insertion function for Media Clip (OLE object)

   Data Processing & Conversion Functions

  • Conditional Data Conversion / Output Property Change
  • Formatting / Calculation Formula / Built-in, Internal Functions

   Convenient Functionality for Data Use and Validation

  • Drill Up&Down Functions
  • Supporting DB Insert/Update/Delete functionality

   Others

  • Hyperlink
  • Data Navigation (Contents Tree)
  • Conditional Pagebreak
  • Powerful Script Support
  • Customization Service, API/Components
  • Database / Record Browsing
  • A Great Number of Readily Available Report Templates
  • Report Creation Wizard / Query Wizard
  • Document Encryption and Improved Security Clearance Level Setup
  • Available Project/Document Management, Preview Function
  • Convenient User Edit Function
 
   Report Designer Viewer (Reporting S/W Viewer)  

RDViewer can visualize Form files created with the Editor as well as processed data with embedded images and Macro through integration with the underlying Database.
Viewer is available in the form of EXE executable module, OCX and Active-X Component.


   Printing and Inquiry Function
  • Processing by page -> To Minimize User Waiting Time

  • Background Processing & Idle Time Processing

  • Numerous Printing Functions

  • Zoom-In / Zoom-Out / Fix to Paper Printing

  • Duplex Printing / Black & White Printing

  • Simultaneous Printing with Preview Image on Screen

  • Congregated Printing (Printing multiple pages on a single paper.)

  • Center/Middle-Aligned and Positioned Printing

   Various Output and Saving Options

  • Easy exporting to various formats (doc, html, pdf, xls, txt, rtf, bmp, jpg, tif and etc)

  • Supporting both Export by Document and Export by Page, and automated E-mail Forwarding with Exported Attachment through Report Scheduling and Mail Notification functionalities

   Convenient Inquiry and Editing/Interpolation

  • Available Freezed-Pane functionality as seen in MS-Excel
  • Automatic/Manual Renewal functions on the result reports
  • Restricted Modification/Editing/Inserting Memo into the result reports according to user authority/clearance

   Inclusion of Various Types of View Module

  • .Exe type of executable module

  • OCX Component for integration with other application programs

  • Active-X for Web Reporting support

 
   Report Designer Server (Reporting S/W Server)  


 
  Concurrent Connection to Multiple Databases

  • Possible report creation with data stream from concurrent connection to either homogeneous or heterogeneous, multiple DB systems

   Efficient Server and Network Resource Management

  • Efficient DB connection management with DB Connection Pooling function

  • Improved report creation efficiency and reduced workload through Data Caching and Compressed Data Transmission protocol for large-volume data

  • Partial Data Fetch function for large-volume data processing (Oracle)

  • Multiple Server Management and Real-time Monitoring function

  • Automatic Server Update and well-established Server Recovery function

   Report Scheduling and Mail Notification functions

  • Available integration with a FAX server when TIF images of documents are saved

  • Provided Option Pack for Mobile integration

   ETC

  • Database Connection Middleware

  • Requisite Platform - Standard JSP Platform (JDK 1.3 or higher)

  • Report Scheduling function

  • Mail Notification function

  • DB Connection Pooling and Thread Pooling techniques applied

  • Partial Data Fetch function for large-volume data processing

  • Database Schema Filtering

 
  Environments Supported  

   Server OS

  • Windows 2000 / NT, Unix and Linux

   Web Application Server

  • All kinds of Web Application Server supported

   Database (Data Source)

  • RDBMS - ODBC, Native I/F, ADO, RDS, JDBC

  • OLE DB - ADO, RDS

  • File or String - CSV type

  • XML / HTML etc DTD Format

  • Web Service support (SOAP, WSDL…)

  • Referred Data Stream of Application Program
    : C/S Application, Web Script Language(asp, jsp…) and etc

  Client OS

  • Windows 95/ 98/ ME/ 2000/ XP (Windows 98 or higher recommended)

  Web Browser

  • Explorer (Explorer 4.0 or higher recommended)