Ayende @ Rahienhttp://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Sneal commented on Reporting business logicWhat about using the .NET 2.0 ReportViewer control? It allows to use classes as data sources which sounds like what you need. http://ayende.com/2221/reporting-business-logic#comment5http://ayende.com/2221/reporting-business-logic#comment5Sun, 18 Mar 2007 18:54:21 GMTAyende Rahien commented on Reporting business logicThe specs information is in the database. The problem that I have with it is that there is significant business logic in spanning a spec to a calendar. It is extremely non trivial, and I would really hate to try doing it in the database. http://ayende.com/2221/reporting-business-logic#comment4http://ayende.com/2221/reporting-business-logic#comment4Fri, 16 Mar 2007 19:07:51 GMTjagid commented on Reporting business logicIn the past have produced this type of report using analytical functions in Oracle. SQL Server 2005 also supports these but they are not as extensive (don't know whether they can support what you would need here). I know that you said that the data does not exist in the database but there's no reason why you can't put it there to report on. http://ayende.com/2221/reporting-business-logic#comment3http://ayende.com/2221/reporting-business-logic#comment3Fri, 16 Mar 2007 19:04:58 GMTAyende Rahien commented on Reporting business logic@Roberto, The AppointmentSpec can change, this means that I can create a perfectly valid appointment, and then change the AppointmentSpec so it is no longer valid. Spanning the AppointmentSpec is costly in terms of CPU, so I would like to avoid that if possible. Trying to pre-validate would mean that quite a few scenarios would need to do this validation. http://ayende.com/2221/reporting-business-logic#comment2http://ayende.com/2221/reporting-business-logic#comment2Fri, 16 Mar 2007 17:47:07 GMTRoberto Messora commented on Reporting business logicfirst idea after reading: you can track with a sort of flag (or state) if the appointment differ from the spec in the moment of creation or in the moment of change, so your search is limited only to the appointment with the flag raised. i mean you could be proactive and not reactive, but I don't know if this will involve an overload of "validation" Roberto http://ayende.com/2221/reporting-business-logic#comment1http://ayende.com/2221/reporting-business-logic#comment1Fri, 16 Mar 2007 17:12:32 GMT