Ayende @ Rahien

Kevin commented on NHibernate for Reporting...

Tue, 05 Jun 2007 17:58:22 GMT

Hi Ayende, I am currently struggling with how to handle retrieving data in large sets (~10,000 records) while still working within the DDD approach I have started. I have been studying your approach using repositories and I am working on implementing a set of specific repositories for things in my system. One is a StudentRepository which is responsible for managing the students in our system. Most of the repository methods are like Save, Remove, Get, Find, etc. These all use NHibernate to do their work. How would you go about implementing a requirement of "Retrieve students matching some criteria and save results to a downloadable Excel file" where the results could be upwards of ten thousand records? Would this be the responsibility of the repository or some other service? I am just looking for some advice or suggestions. Thanks!

Ayende Rahien commented on NHibernate for Reporting...

Fri, 11 May 2007 15:26:18 GMT

That said, Hibernate in Action has a section on reporting queries, and I thinks the docs as well.

Ayende Rahien commented on NHibernate for Reporting...

Fri, 11 May 2007 15:25:34 GMT

Normally,I wouldn't use NHibernate for reports, SQL is usually better at this sort of thing. The scenario that I was facing is a legacy database schema that I have already mapped to NHibernate and reports that contained business logic. Therefor, I choose to do reporting via the business layer. Normally, I would suggest reports to use SQL directly.

Jericho commented on NHibernate for Reporting...

Fri, 11 May 2007 14:51:21 GMT

Hi Ayende! I`m using HN in my project and I think NHibernate isn`t appropriate for complex reporting or may be my knowledges are not enough for this stuff. Could you recommended me any information for using NH for reporting and any tips& tricks would be very useful!!! Thanks!!

Scott Willeke commented on NHibernate for Reporting...

Wed, 09 May 2007 16:42:05 GMT

Can you email me some more information about both how you used (or would prefer to use) NHibernate with reporting and also specifically what problems you have with RTL in RS. We've just released a public beta of Data Dynamics Reports which, among other things will read RDL files, and does support RTL (although I thought RS did too). I'm interested to know what features we might be able to add to help make using NHibernate, RTL more useful in reporting. I'd add XPath to that list, but I think it's hopeless :) Scott Willeke Data Dynamics http://www.datadynamics.com/

Ayende Rahien commented on NHibernate for Reporting...

Wed, 09 May 2007 15:35:42 GMT

Winston, see next post about it.

Winston Fassett commented on NHibernate for Reporting...

Wed, 09 May 2007 14:56:14 GMT

Ayende, could you summarize the trivial operations involved? I, too, would like to know how you transformed your object graph to a dataset and wired it up to MSRS.

Ayende Rahien commented on NHibernate for Reporting...

Wed, 09 May 2007 10:49:37 GMT

@ Njue, It is tirival to transform an object graph to a dataset.

Rik Hemsley commented on NHibernate for Reporting...

Wed, 09 May 2007 07:08:21 GMT

We need RTL because one of the languages we produce reports in is Arabic. Oh well, there are other reporting products on the market and I was going to try a few of them anyway...

Njue commented on NHibernate for Reporting...

Wed, 09 May 2007 06:18:15 GMT

I've been thinking about using NHibernate on my next project but have been reluctant because of reporting.Its a rich client app and i'm stuck with Crystal Reports which as far as i can tell only takes DataSets as report data source.Any ideas on how i would feed NHibernate query results to such a tool?

Ayende Rahien commented on NHibernate for Reporting...

Tue, 08 May 2007 21:15:19 GMT

We got some help from Microsoft, turned out to be a HttpModule that just processed the outgoing HTML and added dir="rtl", but that breaks horribly on aggregation. Why do you need RTL? No workaround yet, this is one situation where I can tell the customer, you wanted Microsoft, now you deal with it. Not that I would have another solution, by the way, it is just that I have fun saying that ;-)

Rik Hemsley commented on NHibernate for Reporting...

Tue, 08 May 2007 21:12:30 GMT

Ouch... We're considering moving from Crystal Reports, which is just disgusting, and I thought SQL Server Reporting Services sounded interesting - but if it doesn't support RTL... Did you come up with a workaround?