Brad, Your first tier strategy would be to offer a <cfchart> solution. You outline the benefit of the chart over Excel as a logical step forward.
The second tier would be to then in turn sell Flex as away to make the chart more interactive with increased user drill down features. You are the right track. Excel really is just a spreadsheet for calclulating data sets and pivot tables in a way you can share with people. You could go as far as to graphically represent the data with cfchart and then offer a data set download if they want to see the data in Excel. Teddy On 12/6/06, Brad Wood <[EMAIL PROTECTED]> wrote: > > I apologize for the off-topic question, but you guys are my readily > handy knowledge pool right now. > > > > Does anyone know if it is possible to call a parameterized MS SQL stored > proc from excel for the purpose of generating a graph. It seems like it > should be so easy, but I keep getting this message in Microsoft query: > "Parameters are not allowed in queries that can't be displayed > graphically". > > I can't just do a select statement, because it won't let me do a group > by either. Grrrr. > > > > > > Maybe I should just screw excel (which I was using because it was EASY) > and make a chart in CF. (Hmm, now we're back on topic again.) > > I want a simple pie chart which will show me the break down of traffic > per company across my site. Easy enough, but I have never really messed > with CF charting. > > > > What I REALLY want is Flex charting, but that request is floating around > waiting on approval from my CIO. > > > > Thoughts?. :-P > > > > ~Brad > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263050 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
