Hi, Im looking for some advise on how to go about presenting some report data. In my scenario, I have the following Sales object: SalesId Customer SalesType Amount
I want to be able to produce a report, a row for each customer, with the different salesTypes as columns, and Amount values in the middle. Effectively its pivoting the data. So I thought that I needed to look at creating a new custom domain object, ReportDTO, which might look something like: Customer DepositType CommissionType BonusType But Im stumped as how to write the criteria api, to transform the data. Effectively I need a query for each SalesType, is this correct? And I need to group it by CustomerId. But Im thinking I need to manually collect each data, for each customer, populate my own Report object, and add it to a list. Which is going to be alot slower. Can I get Nhibernate to do this in some way? Any advise gratefully appreciated. Andy --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
