Basic question about pivottables and sqlserver

[James_Warrior]

Hello all,
I have a very basic question but I have been searching the web for DAYS for
an answer and havent found one yet...
I just want to have an aspx page that shows a pivottable that reads
information from a sqlserver table (or a storedproc), just like a datagrid.
I've looked at tons of pages, I even bought Mr Alvin's e-book but it'll take
me ages to read its 500+ pages and I need the solution asap =S
So far I've read enough to manage to have a page that shows the pivottable
but all the code is in the .aspx html code.. as vb script.. So, i can connect
to the sql server table BUT the connection parameters (source, user, passwd,
etc) are shown in the IE "view source" option.. so i'd like to know if it's
possible to have the code in the .vb file??
Another problem i'm facing, the app I generated works only in my machine,
when i try to access from another client the pivottable activex wont load..
client has owc11 installed and activex enabled in IE =(

I'd be GRATEFUL if anybody could help me.
Thanx!!
James

 

[James_Warrior]

I changed the GUID from 0002E542-0000-0000-C000-000000000046 to
0002E55A-0000-0000-C000-000000000046 and now the app can be properly seen
from remote clients..

Weird thing, Mr Alvin's book says it should be GUID
0002E546-0000-0000-C000-000000000046 for pivot tables, but when I dragged and
dropped mine, it was automatically set to
0002E542-0000-0000-C000-000000000046 (DataSourceControl).

Anyways.. problem #2 is now fixed, but I'm still looking for examples on
showing data from a mssql table.. "code behind" coded.

James

 

[CodeGeek]

James,

It all depends on the version of OWC you're using...I went through a similar
hassle myself trying to figure out how to convert our existing reporting page
from OWC 9 to OWC 11...took a little digging to find all of the appropriate
classids.