I've done this before, but what my manager wants is for himself to be able to write the reports. I agree, that this probably should have been made with stored procs to begin with, but I've always thought that t-sql was really limited in it's functionality.
I've always looked at a database as just a place to store data, not necessarily to manipulate it. Maybe I need to rethink that position. > -----Original Message----- > From: Matthew Small [mailto:[EMAIL PROTECTED] > Sent: Friday, November 19, 2004 4:49 PM > To: CF-Community > Subject: RE: Advice Needed > > 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:137239 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=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
