I am trying to generate dynamic report for my project Everytime i will be selecting different fields to be displayed in the report based on some criteria . My idea is to set the data with is retrived from resultset into my dto(data transfer object) and display this in jsp.( I am sucessfull in generating the dynamic query). But i am facing problem in set the values to dto since my query fields vary every time. I am not able to understand to which dto property i have to set values returned from resultset since i do not know in advance which fields will be selected by user. All the values are coming from only one table. I am not using any report framework for this project. Can anybody suggest how this can be solved.
It seems that the question doesn't have much to do with generating reports, but with reading a number of options the user may have selected, and how to generate a database query from that, correct?
In that case, you need to check for all the options (because the user might have selected any or all of them), and generate the query in a way that allows each one of them to be used or not used. Can you think of a way to do that?