We have an existing laboratory report in MS Access. We need this report to be recreated in Jasper Reports, so that it may be generated dynamically by Jasper Server.
The report has significant complexity on the query side and many tables are involved in production as our data is normalized. Some are:
Company
Address
City
Province
State
Country
Analyte Group
Analyte Name
Analysis
Criteria1
Criteria2
Job
Sample
It may be necessary to use a crosstab function to properly display results. Results should be very similar to the PDF we attached for the same job.
## Deliverables
Note that the PDF example attached does not include analysis values due to privacy concerns. We will happily provide the bidder with more examples to clarify our requirements as needed.