I have an online database application that allows a user to build SQL databases and views using a web interface. I would like to extend this capability by providing the ability to generate paper-based reports from the user-defiined databases.
There are two basic types of reports that need to be supported:
1. List-type
2. Form type
**List Type**
List type reports output the database information in a tabular format. The user has the ability to specify the report title, data source (the database view), paper size, and break conditions (such as when a field changes). All the fields in the database view are output to the report.
The database view support column calculations such as sub and grand totals. These need to be calcualted and displayed on the report.
**Form Type**
Form Type reports merge data from the database into a user-defined form. An example of this is a packing list or an invoice where database information is merged into the report along with static information such as Company name and address. This type of report requires the following:
1. Ability to define the report. This includes specifying the datbase view, static fields and custom fields. Drag and drop of existing database view fields is required.
2. Generate the report based on the report definiton.
You can see the online database and views at: <[login to view URL]>
## Deliverables
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, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. 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
ASP.net
SQL Server 2000
Windows 2003
ASP