• Status Completed
  • Budget $2 - $8 AUD / hour
  • Total Bids 38

Project Description

SQL Reports

This project concerns a small SQL data base, with a variety of Fields Names.

The database has never really been exploited and the project is to look into the data and see what can be made of it.

This project will have several stages:-

1./ take a copy of the DB and look at it, discover all the field names and list these with two data examples each, in a spread sheet.

2./ the client will assess the data and determine what data is worth reporting

3./ build a report maker that runs a query on the DB and presents updated field and data values in spreadsheet form

The DB contains text and html and url data. The client longer term goal is to achieve a report that organises the urls into some sort of heirarchy, much like a set of categories and sub-categories, or much like a site map.

For stage 3./' you will need to write some code (php ?) to automate the report generation on the main production SQL. Output in .XLS and html page format.

The successful bidder will be sent a copy of the DB to work on. The might be 2-4 weeks between activity for stage 1 and activity for stage 3.

Get free quotes for a project like this
Completed by:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online