aspose file tools*
The moose likes Other Open Source Projects and the fly likes Dynamic Reporting in Web Application Project Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "Dynamic Reporting in Web Application Project" Watch "Dynamic Reporting in Web Application Project" New topic
Author

Dynamic Reporting in Web Application Project

Roshan Wankhade
Greenhorn

Joined: Dec 07, 2011
Posts: 21

Hi Friends,
I'm wondering where to post this question... please correct me if this is not the right place.
I'm doing web based application on human resource information system.
The requirement of client is dynamic report generation...
take a scenario that the one employee can have many qualification as well as many Awards details.
so in reporting client want to select the particular employee fields like name,date of joining, etc and after that if she wants the qualification details then she select the qualificatin module and add the fields like highest qualification, duration etc, along with she also wants the awards details for all employees.
All the above things addition and removal is dynamic (at run time).
our database is ready (using hibernate).
I have already tried
1. display tag
2. dynamic jasper
3. jasper
but no one can give me the result as expected. Each one have its own limitation on one side or (it's me ).
Please any one can provide me the best path to generate the dynamic report for addition and deletion of fields on the fly maintaining the one to many / many to many relationship.
please go through the attachment to understand the requirement.
And please help me, i'm totally stuck and having many expectation from this forum.


[Thumbnail for report_requirement.png]

Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42648
    
  65
If JasperReports (which is the gold standard of free reporting solutions for Java) isn't sufficient, it may be time to check out commercial solutions like CrystalReports.


Ping & DNS - my free Android networking tools app
Roshan Wankhade
Greenhorn

Joined: Dec 07, 2011
Posts: 21

Thanks Ulf Dittmer for your reply.
But can you explain me the way i can do it in the jasper Report ???
I love to use the jasper Reports as its open source.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42648
    
  65
It's not possible to explain something as complex as JasperReports in a forum post. But there's no shortage of material available on the web, not least on the project web site itself.
Vishal Shaw
Ranch Hand

Joined: Aug 09, 2012
Posts: 179
Hi,

I did not get your point. What is the problem you are facing with jasper report? You can create a dynamic report in Jasper using a bean.

I have worked on a project where the schema was dynamic too. So instead of Jasper we used iText jar. So, if that's your requirement you can look for some open source jars (there are plenty available in java) to meet your requirement.

Regards,
Vishal


Programming is about thinking, NOT coding
Roshan Wankhade
Greenhorn

Joined: Dec 07, 2011
Posts: 21

Thanks guys for the reply...

Actually my beans contains many Collections.
Lets take an example like.
I want to generate the report for the Employee... including the qualification, salary slips, departments, chechlist details, disciplinary details, duty roster details. all this collections has many to one relationship with the Employee. Employee is owning side.

I'm using Vector as Collection. also want to mentioned that this collection contains the filed which are also ENTITIES and having there own fields.
so i use HashMap and store it in Vector.

Now when i use this beans how i can get the proper report in different situations where the client will select the collection fields at run time.

Can you suggest me...

Thanks in advance...
Vishal Shaw
Ranch Hand

Joined: Aug 09, 2012
Posts: 179
Roshan Wankhade wrote:Thanks guys for the reply...

Actually my beans contains many Collections.
Lets take an example like.
I want to generate the report for the Employee... including the qualification, salary slips, departments, chechlist details, disciplinary details, duty roster details. all this collections has many to one relationship with the Employee. Employee is owning side.

I'm using Vector as Collection. also want to mentioned that this collection contains the filed which are also ENTITIES and having there own fields.
so i use HashMap and store it in Vector.

Now when i use this beans how i can get the proper report in different situations where the client will select the collection fields at run time.

Can you suggest me...

Thanks in advance...


Have you tried using sub-report in jasper
Roshan Wankhade
Greenhorn

Joined: Dec 07, 2011
Posts: 21

Thanks Vishal,

But i had gone through the sub report and not getting the exact structure i want.

Please go through my attachment to find what is the exact requirement for report structure.

Please provide some guideline to achieve this i'm totally stuck.

Thanks in Advance.


[Thumbnail for report_requirement.png]

Vishal Shaw
Ranch Hand

Joined: Aug 09, 2012
Posts: 179
Roshan Wankhade wrote:Thanks Vishal,

But i had gone through the sub report and not getting the exact structure i want.

Please go through my attachment to find what is the exact requirement for report structure.

Please provide some guideline to achieve this i'm totally stuck.

Thanks in Advance.


I feel that the structure is possible using sub report, you just need to identify which portion of it will go into the sub-report module. For e.g. your award and qualification can be a sub report of your employee report. You just need to identify the sub report modules.

Also you can always switch to using the opensource libraries like iText or POI, for sure. Here you can implement your own logic to make the report. This can surely help you out.

Or if you want you can look for some paid libraries (look around in google). In this case you will get support that can really work faster and easier.
 
 
subject: Dynamic Reporting in Web Application Project