Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-18 : 09:39:19
|
New_Phoenix writes "4GuysFromRolla SQL Server Gurus
I am having a problem populating the OWC Chart Component with data from intricate calculations derived from SQL Server, calculations that are not stored in a database, and that would be impossible to produce in an elaborate SQL Statement. I would like to populate the OWC Chart control with data calculations from SQL Server that are passed to the control on another ASP page as a series of arrays, but the OWC Chart control only appears to accept recordset objects. The Datasource, objSeries.SetData elements of the objChart all would appear to accept arrays from a recordset, but not purely arrays. Could this be solved with several disjointed TempDB tables to store the calculated values, and then somehow using the TempDB to populate the MSChart OWC control. Is that possible?
To see a URL with the source of my problem go to:
http://msdn.microsoft.com/library/officedev/off2000/octocDataSourceControlObjectModel.htm
I would appreciate it if the guru from 4guys could help solve this peculiar puzzle. You asked for a SQL stumper, well here it is...and I really need your assistance to solve it.
Thanks...
New_Phoenix@Hotmail.com" |
|
|
|
|
|
SQL Guru Stumper: Database Datasource Via Arrays or TempDB Instead of Recordsets To Feed OWC MSChart