M
Mike Berger
So, after a lot of investigation, some of this OWC stuff is starting to make
sense. Many thanks to Alvin Bruney and Thao Moua. If anyone can clear up the
many questions I still have, I would greatly appreciate it.
First, using VB 6 (after choosing Microsoft Office XP Web Components from
the Components dialog)...
I put the PivotTable control on my form, then click on the hyperlink "Click
here to connect to data".
This brings up the "Commands and Options" dialog.
From this dialog, I select the "Connection" option and the "Edit" button.
This produces a dialog entitled "Data Link Properties". Here I enter my
connection info to the SQL server, and this must be whats used to generate
the ConnectionString property for the control.
From this dialog, if I have a DataSource control on the form, I can select
the DataSource control option, and the Data Source control will be in the
drop down list and I can select that DataSource control.
From this dialog, after selecting either Connection or Data Source control,
I can then select something from the "Use data from" portion. and select
either a table or put in my own SQL select statement.
Once all of this is done, the PivotTable Field List is populated, and I can
use it to populate the PivotTable.
No *.udl file is generated.
Okay, so all is good.
Now, using FrontPage 2002.
I use the Insert > Web Components menu and select "Spreadsheets and Charts"
and "Office Pivot Table". That puts a PivotTable on my page (the <object>
tag is generated), then I click on the "Click here to connect to data".
This brings up the "Commands and Options" dialog.
From this dialog, I select the "Connection" option and the "Edit" button.
This brings up a common dialog to select a data source file with a command
button "New Source". From here I can follow a wizard and generate a new
*.odc file, or I can select an existing .odc (amongst other file types the
common dialog presents). All this seems to do is to fill in the "Connection"
and "Data" fields in the "Commands and Options" dialog. The actual .odc file
is does not seem to be needed in the FrontPage web.
Questions....
So, I know that .odc is "Office Database Connection", but can anyone give me
any more background on this file type besides its name ?
Why does FrontPage make me generate an actual file ?
I cannot find any place to insert a DataSource control in FrontPage. Why ?
I've seen how to programmatically generate a pivot table, but this is using
FP's design to put a control on the UI. I want to then reference that
control and set some properties. Can I do that ?
I'm sure I'll have more, but thats it for now. Any FrontPage/OWC Microsoft
people out there ?
Thanks
Mike
sense. Many thanks to Alvin Bruney and Thao Moua. If anyone can clear up the
many questions I still have, I would greatly appreciate it.
First, using VB 6 (after choosing Microsoft Office XP Web Components from
the Components dialog)...
I put the PivotTable control on my form, then click on the hyperlink "Click
here to connect to data".
This brings up the "Commands and Options" dialog.
From this dialog, I select the "Connection" option and the "Edit" button.
This produces a dialog entitled "Data Link Properties". Here I enter my
connection info to the SQL server, and this must be whats used to generate
the ConnectionString property for the control.
From this dialog, if I have a DataSource control on the form, I can select
the DataSource control option, and the Data Source control will be in the
drop down list and I can select that DataSource control.
From this dialog, after selecting either Connection or Data Source control,
I can then select something from the "Use data from" portion. and select
either a table or put in my own SQL select statement.
Once all of this is done, the PivotTable Field List is populated, and I can
use it to populate the PivotTable.
No *.udl file is generated.
Okay, so all is good.
Now, using FrontPage 2002.
I use the Insert > Web Components menu and select "Spreadsheets and Charts"
and "Office Pivot Table". That puts a PivotTable on my page (the <object>
tag is generated), then I click on the "Click here to connect to data".
This brings up the "Commands and Options" dialog.
From this dialog, I select the "Connection" option and the "Edit" button.
This brings up a common dialog to select a data source file with a command
button "New Source". From here I can follow a wizard and generate a new
*.odc file, or I can select an existing .odc (amongst other file types the
common dialog presents). All this seems to do is to fill in the "Connection"
and "Data" fields in the "Commands and Options" dialog. The actual .odc file
is does not seem to be needed in the FrontPage web.
Questions....
So, I know that .odc is "Office Database Connection", but can anyone give me
any more background on this file type besides its name ?
Why does FrontPage make me generate an actual file ?
I cannot find any place to insert a DataSource control in FrontPage. Why ?
I've seen how to programmatically generate a pivot table, but this is using
FP's design to put a control on the UI. I want to then reference that
control and set some properties. Can I do that ?
I'm sure I'll have more, but thats it for now. Any FrontPage/OWC Microsoft
people out there ?
Thanks
Mike