Can anyone tell me there experience with creating queries that work well with graphs? I'm putting together some financial data and I can get it structured exactly the same way with SELECT queries + UDF's and Stand Alone Crosstabs. After that, getting the graphs to plot correctly inside my reports are becoming impossible. It does display the way I want it though through a form pivot chart. Is there possibly something wrong with my Graph program?



What is the best way to do it so my life will be easier when it comes to charting and graphing the data for the End User? Does anyone have any experience with this. Any thought certainly welcome! thanks..