GTD Excel Report Builder/Server

GTD Excel Report Server is web-based reporting solution that helps small and mid-sized businesses create, manage, and deliver rich-format excel reports via the web or embedded in enterprise applications.

It is a free, light weight, rapid, web-based reporting solution.

Screenshot Screenshot Screenshot Screenshot Screenshot

Get rich format spreadsheet from database

The output of GtdReport contains colors, multi-fonts, charts, formula and so on.

Here is an overview of how you can generate template-based excel report with GTD Server.

  • Create a "report template" defining the structure and data of your report, feed it into your GTD server.
  • From the web frontend of GTD Server or your applcation, you can select data source and pass paramenters, then call GTD to export excel.
  • Using the Scheduler it is possible to set up automatic report generation and have the reports be sent by email.

Platform Independent with multiple Environments

GTD server is completely written in Java. It runs on every platform (OS) that supports Java 5 or higher. A GUI is not required for the server.

  • Server Platform Independent: Support Windows, Unix, Solaris, OSX 10.4+, AIX
  • Client Platform Independent: The front end is web-based.
  • Independent from MS Excel runtime, no excel template required.
  • Language Independent: The report template is based on unicode, so it supports your language, for example Arabic, CJK(Chinese, Japanese, Korean).

Rapid Development

Use GTD Server, besides save money, you can also save time. GTD server provide predefined report layout, you can edit the format of cells by visual designer. If you use Excel-based template, you can edit the template by Microsoft-Excel program.

  • We provide several common predefined report layout, so you can develop report in minutes. No technical knowledge is needed in order for the user to customize his or her own reports.
  • You can also develop complex excel template based report, however, it may take more time. But the excel looks more pretty

Easy to integrate with your application

Besides call GTD from built-in front end, you can also call it from your application.

  • GTD is a server. -- You can download the sever edition and run it as stand-alone server.
  • It is also as J2ee application. -- You can download the WAR package and deploy it in your J2EE container.
  • Integrate with LDAP, so you can login GTD sever using your account in Active Directory and other LDAP server.

Quick Installation/Configuration and Easy to Use

Installs in 3 minutes

  • Free download, about 50 MB.
  • Installs in 3 minutes.
  • Web-based GUI frontend.
  • Many templates provided, easy to configure

License Mode

Lion Software

EasyHA is not free software. Commercial users are welcome to use these downloads for trial purposes.

Please note that

  • The free trial version will expire 60 days later.
  • Some features is disabled in the free trial version.

We have a lot of License option for all your need

  • 10 User Perpetual License - $300

    Purchase

    Number of core server installations: 1.

  • Annual License - $300

    Purchase

    Number of core server installations: 1.

  • Perpetual License (Maintenance excluded)- $1000

    Purchase

    Number of core server installations: 1.

  • Perpetual License (Maintenance Included)- $2000

    Purchase

    Number of core server installations: 1.

  • Maintenance Plan- $100

    Purchase

    .

Try it on your PC, Just 5 minutes)

Lion Software

If you are using Windows OS, it is very easy to install and start GTD server on your PC. Please follow the steps below.

  • Download installation pack of GTD Server, click Here to download. -- 3 minutes.
  • Unzip the downloaded file, execute the installation program --0.5 minute.
  • Launch the new installed program, start the server by click start icon. --0.5 minute.
  • pen IE browser, visit http://localhost:8002/ , login as admin, password: 1234 . --0.5 minute
  • Run the built-in sample reports, get rich-formated excel output.

Try It Online

  • We install GTD server on one of our server that is hosted in Fremont. You can login in the server and experience the server.

    URL: http://demo.gtdreport.com:8002/

    Note: Please don't remove/change any object that is not created by you, thank you for your cooperation.

    We have created 3 users:

    Login Password
    fixedadmin aaa
    fixeddev aaa
    fixedcommonuser aaa

    We have created 3 tables for your testing.

    create table salesrecord (
     productName varchar(100),
     productLine varchar(100),
     customerName varchar(100),
     quantity int,
     MSRP DECIMAL(10,2),
     buyPrice DECIMAL(10,2),
     orderDate date
    );

     

    CREATE TABLE department (
    name varchar(20) NOT NULL, id int NOT NULL PRIMARY KEY );

     

    CREATE TABLE employee (
    name varchar(20) default NULL,
    payment double default NULL,
    bonus double default NULL,
    birthDate date default NULL,
    id int NOT NULL PRIMARY KEY,
    depid int, FOREIGN KEY (depid) REFERENCES department (id) );

Excel Output Samples

Lion Software

Sample1.xls

Lion Software

Sample2.xls

Lion Software

Matrix Report Sample3.xls

Lion Software

Chart Sample4.xls

Lion Software

Chart

Report Engine & Designer

The GTD Server supports 2 types of report engine, as well as supports 2 types of report design method.

  • Design report via web page
  • Design report via Microsoft Excel template

Design report via web page

You can design the data model and display model by web GUI interface.

Data Model

Data Model includes data source, sql statement, parameter, grouping, subtotal etc. The data source and parameter is bound on report runtime. The GTD Server supports sql statement parsing.

Display Model

The display model includes layout, font, color, format, alignment etc.

Design report via Microsoft Excel template

You can create an excel template, on which define data model (supports multiple sql statement) and display model. You can design complex display model, even the chart and graph.

Data Model

Data Model includes data source, sql statement, parameter, grouping, subtotal etc. The data source and parameter is bound on report runtime. The data model will be defined on excel template.

Display Model

The display model includes layout, font, color, format, alignment etc. You can define the layout by Microsoft Excel. What you see what you get.