This content has been marked as final.
Show 4 replies
-
1. Re: Seam Excel Subtotal
danielc.roth Apr 5, 2009 5:27 PM (in response to yulrizka)Create a list with exact the content of what you want to show, i.e. create the additional rows that are not in the recordset...
-
2. Re: Seam Excel Subtotal
nickarls Apr 5, 2009 8:32 PM (in response to yulrizka)You could also use formulas, although that has a bit of manual overhead, too (keeping track of the range of the sum to cover)...
-
3. Re: Seam Excel Subtotal
yulrizka Apr 5, 2009 8:50 PM (in response to yulrizka)Thank you all for the quick response.
i think im going to go with create a list.but, bump into another problem.
what if i had a custom hibernate query likeselect e.Date, e,employeeName,SUM(case when e.sales > 10 then sales else 0 end) as cTen from Employee e
do i have to create a transient field on the Employee model ? or there are any other way
i successfully retrieve the data, but not always getting this error
[Ljava.lang.Object; cannot be cast to model.Employee
-
4. Re: Seam Excel Subtotal
yulrizka Apr 5, 2009 9:07 PM (in response to yulrizka)sorry for that, i found something that is work
List<Object> result = (List<Object>) EmployeeList.createQuery("select e.Date, e,employeeName,SUM(case when e.sales > 10 then sales else 0 end) as cTen from Employee e").getResultList(); for (Iterator it = result.iterator(); it.hasNext();) { Object row[] = (Object[]) it.next(); System.out.println(row[2]); }
Thank you all for helping me