I need to generate a branch wise summary report for my application.I have created a base view and on top of that i summing each and evry field so as to get summary for each branch.
i have to pass 3 parameters to my query 1. is the portcode for the user has access to and from date and to date.
My problem is :- Since i m doing a sum all columns become my derived columns .i wont be able to access them as columns
Can any one tell me in this scenarion how can i use derived property of hibernate.
Or can i write a formula for each of the summing columns...separtely..