I want to display a report which has multispan rows and columns. I am using Spring MVC, Jquery. In worst case, no of rows is 360 and columns is 3000. hence, total no of cell, in worst case, for a report is around 10 lakhs.
Also, every cell has different colors and attributes and on click of each cell some operations need to be performed and display result in tooltip of that cell. Can someone tell me which technology in java should i use to display the report so that performance overhead will be minimum and multispan functionality can be achieved? OR can someone tell me how to achieve the above functionality?
I don't think this question applies to Spring directly at this point. Its a mix of different things and needs to be broken down into smaller pieces.
Hi Bill, thanks a lot for the reply. I need to display the report in the UI, where they will be able to intract from back end (server side/Database). Additionally, i need to provide a functionality to download(export) the report data, along with header, in excel file. can you please tell more specifically the technologies/ways so that both of these can be achieved?
Yes, you are right. This question is not directly related to Spring, its just that i am using Spring MVC for this web application.
There is more than one way to solve this problem. I can give you one idea to investigate. Note this problem is to big to discuss in a single forum post. So once you start if you encounter problems you are going to have to break your questions into something smaller and post it in the correct forum.
For the datatables for displaying things to the user have a look at :