If you're going to be doing a lot of report type stuff, I'd recommend looking at JasperServer. It's the bee's knees. Exports in PDF, Excel, RTF, blah, blah, blah.
You can run the reports from ColdFusion too, either using the JasperServer webservice or just running the reports "by hand" using a custom tag. :den -- Humanity may endure the loss of everything; all its possessions may be turned away without infringing its true dignity - all but the possibility of improvement. Johann Gottlieb Fichte On Thu, Feb 18, 2010 at 9:48 AM, sandeep saini wrote: > > Guys, > > We are creating a new website and i have to lay down the architecture for > that. Its basically a reporting tool which will fetch data from DB and > display. The data can be few records to Thousands of records depending on > search criteria. we have to create about 15 reports. The client wants a > strong archetecture. > > So which one of these would be a better choice. More basic requirements are- > 1. Once the data is fetched, i would like to reuse that instead of going to > DB again and again. > 2. AJAX capability. > 3. Exporting data to PDF, EXCEL. > 4. Creating Mailing Lists/Labels and Sending emails thru the application > 5. Use stored procedures > 6. Easy to scale in case client wants new repots to be created. > > Experienced users, Your urgent reply is highly appreciated with a reason. I > need to make a decision very soon. also which one is simpler to implement of > these two as we also dont have much time just to create the architecture? > > Thanks > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330947 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
