Create 10 Reports with Jasper Report Server

Small Database running MS SQL Server and Jasper Reports Server Community Edition 5.

Database consists of 33 tables. You can create reports directly on our server or using any tool or IDE (Jasper Studio, iReports, etc.) We will provide access to Jasper API on request. Please note that server is running a modern version of Windows Server and iReports does not work well locally. Data source has been created and access to data provided.

All work can be completed on our server. If work is completed at your site or computer, you will be required to upload and setup/get working on our server.

You will need to study the database and how tables are related to be able to the create reports. I can provide scans or screenshots of how most of these can look - but ultimately you will have freedom to design the report however you want. I will provide logos.

Customer Report - Choose customer from drop down and display info info including balance and status

Customer Production - chose customer from drop down and see all workorders and workorder detail

Shop Production - based on time range display all production ID, type, description, etc and totals

Workorders - Details of chosen workorder

Reject List - Display all rejected production units based on datetime range - reject type, production unit id, description.

Casing List - Display all casings with their workorder, description etc

Retread List - Display all retreads rolls in system

Envelope List - Display all envelopes in system

(2) Sample reports of production and rejects with Graphs.

Please make sure all your questions are asked and anwered before bidding on this project.

Thank you.

Database Administration Report Writing SQL

Project ID: #5547889

About the project