In spite of some early growing pains, MS SQL Server Reporting Services can serve up some pretty nice looking reports. Very customizable (you can write complicated logic in .NET and access these modules in your report). It requires SQL Server for it's operation (which you have), but the data for the reports can be in any common database. If you have Visual Studio .NET, you can already create SRS reports.
Its greatest advantage, in my opinion, is that its NOT crystal reports.... ----- Original Message ----- From: "Tangorre, Michael" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, October 21, 2004 10:46 AM Subject: Reporting > Our internal application users have been requesting some pretty > complicated reports... anywhere from 20-75 data fields organized 25 ways > from sunday, etc. What they really desire is to pick any field from any > page in the application and generate a custom report, etc. and have the > ability to save the criteria to use again, etc. I have some ideas on how > to approach this, but in terms of presenting the reports; HTML output is > getting tough since they want so much information and the real estate is > just not there.... not too mention some of the reports are going to the > president and what not (executive tye reports) and they desire a nice > looking report. I have about 7 reports now that are fine in HTML but > what are some things I can look into or that others have used in terms > of more complicated reports. The backend is a SQL Server 2K DB. Crystal > reports? COM and the MS products? The front end and such is done in CFMX > 6.1 with lots of JS and CSS. > > Looking for some ideas or 3rd party products to look into. > > Thanks, > > Mike > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=34 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182202 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
