Create Summary Graph using Crystal Reports 2008
Graph will count the number of records in a given table and group by "type".
The graph will represent:
WOtype = Feild in the database which is the "Work Order Type"
1. The number of total records grouped by "WOtype", by month, by year.
2. The percentage by group "WOtype" of the total number of all records
3. Paramater field for Completion Date Range (is between)
The report will be further modified by us to include a proper title and filters.
## Deliverables
The final report must not be locked or limited in any way. We must be able to fully edit and reverse engineer the design of the report to customize it further for future data sets.
A copy of the table (from SQL) will be made avaialbe in the form of a .csv file for development. However, the final report will need to link to a SQL data view (SQL 2005).
A data dictionary is available for the given SQL table.
* * *This broadcast message was sent to all bidders on Tuesday Mar 10, 2009 11:01:27 AM:
A recurring question has been asked regarding the version of Crystal Reports that can be used to develop the report. Probably 8.5 or later would be fine... the end product I will need to update to Crystal 2008, so we'll have to confirm everyting works if you've designed the project on an earlier version...
* * *This broadcast message was sent to all bidders on Wednesday Mar 11, 2009 2:59:33 PM:
I had to update this bid request with additional report requirements that were excluded originally. Please note, the final report must be grouped by Month for each year within the report. Please contact me if you require further details.
* * *This broadcast message was sent to all bidders on Wednesday Mar 25, 2009 11:25:12 AM:
Just FYI, this opportunity is open again.
## Platform
Windows XP, 2000, etc.