I don't have knowledge about reporting tools. I need to add reporting capability in the project currently I am working on. I am using hibernate and beans are having dynamic design, meaning that attributes of entities are defined dynamically. For example, for Student entity having firstName and lastName attributes, will not be save straight forward in database in Student table with first_name and last_name as columns, but there are meta-data tables for entities and there are separate transaction tables which have foreign key mapping for column to which it refers.
However, in reporting, I need to display entities in conventional way. In which I will have columns for First Name and Last Name. So I am confused that whether reporting tools will be helpful to me or I need to achieve this programmatically? I am yet to learn reporting tools. So I want to start it only after confirming that it will be useful to me to achieve this, because of time constraints.
Please guide me to achieve reporting for such design.