Good afternoon all, I have been tasked with the following: 1. The user can run a report based upon some selection criteria (fields, ect). 2. The user can see this report in two different formats (a. on the site itself rendered in HTML, and b. in excel spreadsheet format -- I have used the custom tag cf_excel for the latter)
This all works fine. Except for the following: Sometimes the spreadsheet opens inside the parent web page, and sometimes it opens in excel. But either way, it is still a spreadsheet. It seems to be desktop specific, it will either always load inside the browser, or inside an instance of Excel. I So instead the users want the ability to save the spreadsheet instead of actually seeing it run. I am having a hard time understanding how to make this work. This is what I think should happen: 1. User clicks the To Excel button 2. Page executes (Query is run, recordset is generated, custom tag is called, spreadsheet is built) 3. User is promted to save the resulting .xls file (using CFFile?). 4. User saves the file using standard windows file selection interface. I am sure this is possible, but cant seem to get to step 3 from step 2. Any help would be appreciated. John ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
