I have a fairly complex query that generates a fairly complex report in the browser.. just html tables with some data, some nested tables with its own data, etc. No problem with that part.
The part I'm havin trouble tryin to figure out is how to generate some downloadable reports out of it. It's like, what should the routine be for this? In my head I've come up with using <cfsavecontent> to save a sort of, snapshot of the page in a SESSION variable. The user clicks the "export to html" link, and I'll build an html page they can dload via <cfcontent>. So as far as that's concerned, would that work ok? I also need to export this data to excel. Now, I've been usin ben nadel's sweet POI utility to generate some other excel files, works like a champ. But I'm havin a hard time even figuring out the routine to do this, before it even gets to that point. 1. User lands on the page. 2. Makes some filter selections. 3. report is generated on their .cfm page. 4. User clicks "export to excel" link. 5. What now? Do I re-run the query all over again? Is there a way that query can be saved so I can use it again when he clicks the link? Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282908 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
