DB reporting web app

Closed Posted Apr 17, 2007 Paid on delivery
Closed Paid on delivery

Hi,

I require a DB reporting web app built. It will be installed by the end-user on a windows 2000\2003 server and be accessed by clients on 2000\XP. The client should be able to logon then create, save and view reports

I am not looking for too many features but the end product should look great and be easy to use. Ideally it should be content managed, highly configurable and based on an Ajax framework.

The product should be easy to use by the end user and not look overly complicated.

I am looking to go ahead with project as soon as the correct coder comes along. Please respond with:

previous experience

preferred framework

timeframe

costs

what you could add to the project (bonuses will be considered for extra)

**Standard replies will be ignored.

**

## Deliverables

**Functionality**

1. Built using an Ajax framework (others considered):

<[url removed, login to view]>

<[url removed, login to view]>

<[url removed, login to view]>

<[url removed, login to view]>

2. Look tidy, professional and useable

3. Fully configurable options (content managed)

4. An admin account to allow the likes of

1) DB connections

2) users and\or groups

3) adhoc global settings

5. Have user accounts\groups with different levels of access

6. Passwords in database should be encrypted.

5. work with SQL Server

6. Creating Reports

Three Methods to create reports:

6.1 1) SQL Wizard - A series of steps (without refreshing the full screen) which build up a working SQL query

6.2 2) direct SQL entry - allows the user paste the SQL into a box (only with preferred accounts)

6.3 3) pre-built queries - let the user select a stored proc (pre defined by an admin) and input the required inputs

6.4 Each report should be able to be saved and available to their group

7. Displaying reports

7.1 Report should be picked from the above saved reports

7.2 The number of rows per page should be configurable by the user and at a global default value

7.3 The rows should be configurable live on screen without refreshing the full page:

1) sorting by any column

2) hiding\showing columns

3) filtering data in a column

7.4 There should be an option to save the current filtered dataset to xls with basic formatting, csv or xml

8. Layout should be optimised to use the screen as best as possible

**Deliverable Agreements

**1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition within an installer. The complete install should be in one install package, be easy to use and work on any Microsoft server.

3) The final product should have some sort of security that would stop the source from being updated\changed when installed on the clients server

4) All deliverables will be considered "work made for hire" under U.S. and UK Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Server: MS 2000\2003

Client: 2000\XP

IE 6+

Reporting must work on at least MS SQL Server.

Web app would preferably be compatable with IIS and use MySQL for configuration\accounts\saving reports

.NET Amazon Web Services ASP Engineering Java JavaScript JSP MySQL PHP Software Architecture Software Testing SQL Web Hosting Website Management Website Testing

Project ID: #2928163

About the project

6 proposals Remote project Active May 8, 2007

6 freelancers are bidding on average $446 for this job

EvolutionIT

See private message.

$425 USD in 30 days
(11 Reviews)
5.3
easternstarlinz

See private message.

$510 USD in 30 days
(9 Reviews)
3.7
salcorp

See private message.

$382.5 USD in 30 days
(12 Reviews)
3.5
sarc

See private message.

$509.15 USD in 30 days
(3 Reviews)
2.2
clerzed2008

See private message.

$425 USD in 30 days
(0 Reviews)
0.0
WISPT

See private message.

$425 USD in 30 days
(5 Reviews)
0.0