Hmmm... I don't think it's necessarily a step backwards. Unfortunately, your code is usable only on an interface that can use straight text output (be it a web page or a comma-delimited file or...) It might have been more sensible to write them initially as SQL stored procedures and have the CFCs use those. However, if you really wanted to do the work, you could write your own reports that will print out as well as CR. Use CSS to set exact font sizes and placement, and then the nested CFOUTPUTs to create reports that you save as a text file and open in WORD as an HTML file for pagination and printing. It might save your SQL guy a lot of work. :-)
- Matt Small -----Original Message----- From: Marlon Moyer [mailto:[EMAIL PROTECTED] Sent: Friday, November 19, 2004 5:42 PM To: CF-Community Subject: Advice Needed I've just about finished up an app that took several months to complete. I've programmed most of the business logic into CFC's. Granted, these aren't real complex calculations and such, but there are a lot of them. My manager wanted to write a report against them and I told him that either I could make some HTML reports or I could expose the data via web services. He only wants it in sql views so that he can write Crystal reports against them. Is there a better way of doing this? I'm not really complaining since it won't be me recreating all of the code since we have a sql guy, other than most of my work being worthless :-). It just seems to me that this line of thinking is a step backwards. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:5:137234 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
