Projects

Intranet System Alerts

Training Application

Sales Route Map

Employee Database HR

Multilingual Software

Sales Report Builder

Drag & Drop Report

Online SQL Manager

Webinar Management

Really Quick Books

Auction Site

Online Employment App

Enterprise CRM

Call Center Management

SEO Management

Email Blaster App

eCommerce Site

Tourism Web Portal

Domain Reg Portal

Paperless Office

ISP


Drag & Drop Report Builder 2008

Drag & Drop Report Builder 2008 [Nuance Communications]



Technologies:
SQL, ASP, JavaScript, CSS, HTML & DHTML

Challenge:
Create a sample data sampling report for mailing and email distribution lists.

Solution:
Marketing wanted a creative way to run some queries to see what sort of data they had for creating new campaigns. Creating reports and exporting them to Excel can take a few hours of programming time, and a standard report limits the user to only the report data.

I made a simple UI in JavaScript and DHTML
The user simply dragged the fields in any order they like to the report container
The report application created a dynamic query string and executed it against the SQL database
The ASP results page allowed the user to further sort the data.
The final step was to export it to Excel for analysis

Project Involvement:
100%
 

 
Website © Copyright 2012-16 David Johndrow - All Rights Reserved (Individual Copyrights are Maintained by Clients as well as Trade and Service Marks)