We need a program that will create a reporting dashboard. These dashboards will report on realtime data. As the data changes so will the reports(the fields will remain the same just the qty of surveys will increase). The data will be in Microsoft SQL 2000 database format. There will be a table of questions and responses and a table of the raw data. These table will be linked.
## Deliverables
There are three options.
**Option one**, the tool can be written as and .exe program to be run locally. The application will generate all the code needed to post to the website. The application can generate asp.net, flash or java code. This code must interact with the security(user login) already on each site we create.
**Option two** would allow us to post a small applet on each website that we create. Using an admin password(sort of like a dotnetnuke theory) that would give us the ability to build this dashboard interactively on the web.
**Option three** is to have a total fash interface with all the options built into flash(swishmax). We would still need some type of interface to control the building of the each dashboard and related drill down pages. Once again it would need to interact with the security on the web.
Either options should work as follows.
Start out by designing the page (example would be a 2 x 4 table). We should have full table options (border, background color by cell, padding, Merging/splitting, etc.)
Once the page is designed we select a datasource for the project.
At this point you have your basic style. Now you can drag into each cell one of the following.
1) A fusion chart(or other charting component that looks good)
2) A Data grid
3) Filter or Tree box with will interact with all the charts/tables.
Charts (we need to have all the options with a point a click interface)
Data Grid(what columns get what data (counts, sums, %, avgs)
Filters (how each filter reflects on the charts and grids)
We also need drill downs from the charts to other Dashboard pages that relate back to those pages.
In additional we need to wrap the dashboard into an ASP.net web page so we can have security for that page as well as have filters that relate to that security level. For example if there are 10 locations that we survey and a user from location one logs in they should only see data from location one. That means in our security database we will have user levels. Based on that table we will need to have different security levels.
Remember we are reporting Survey Data so we will need Averages, Medians and other statistical options that fit into the dashboard relm.
example dashboard sites:
<[login to view URL]>
<[login to view URL]>
<[login to view URL]>
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
This program must or the code generated from the program must work on a Windows 2003 server with SQL 2000 server and IIS.
All code must intergrate with asp.net so we can secure the pages that are generated or be wrapped in an asp.net page.