CODEWITHSUNDEEP
javahibernatereporting-services
akshaivk
akshaivk

Reputation: 427

How to generate a dynamic report in java

I am doing a project for a clinical laboratory. I am using java, hibernate and SQL Server for my project. In some cases I need to generate reports on results of the particular Lab tests, for each tests the format of report differs.It is impossible to create predesigned forms for all the tests. So in this case the freedom of designing the form for test report should be given to the user of the application and this report format is mapped to each tests, so that when the application runs the report should be generated dynamically according to the mapped report format of the test. Can anyone help me to suggest a method for doing this(Here the report format is designed by user by using drag and drop facility, because the user is not technically skilled to do it by coding.The designed form can be mapped to a particular test by the user and the report is generated according to the uploaded format by filling the data of particular test taken from database). Thanks in advance.

Upvotes: 0

Views: 1612

Answers (1)

Andy Dufresne
Andy Dufresne

Reputation: 6180

Microsoft SQL Server provides a reporting service component (SSRS). Reports could be designed by the user in a desktop tool called Business Intelligence Studio*. This tool allows the user to drag and drop UI components to generate a template file. The template file contains two important details - data source details to fetch data & the format of the report to be displayed.

The template file is then uploaded on the report server. A report is generated from this template dynamically when needed. Dynamically here refers to the fact that the data to be displayed in the report is fetched at runtime when the request for report generation is made.

The template file can also accept Report Parameters which could help to generate multiple variants of the report for one template file. There are various other SSRS features which you could browse through.

SSRS dynamically report generation capability seems to suit the requirements you mention above.

SSRS also has exposes web services through you can integrate your application with SSRS. There are web service methods for uploading a template and rendering a report.

*There are web based alternatives too. One of them is cizer.

Upvotes: 1

Related Questions