office web components: pivot table control (ver/ 11/0)

[Goodya]

i'm using Microsoft Office PivotTable 11.0 web component (activeX element) in
my adp-project (access 2000) which is connected to a SQL Server 2000 database.
In design mode i set a ConnectionString for this PivotTable ActiveX element
and degsign a layout for viewing data from a table. But if i change the
ConnectionString or a CommandText property my layout is lost. Could you pls
help me with this, because I'd like the layout to be retained even if i
change those properties. This is needed sometimes if i want my front end
(adp-file) to be connected to the same DB on another machine for example/
Thank you in advance.
PS The best way for me would be if Connection string for PivotTable element
was
automatically taken from ADP-file's Connection property

 

[Alvin Bruney - MVP ASP.NET]

you would need to do this at run-time, read from a layout file etc. In
design mode, the changes are imposed immediately, overwriting your old
settings

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET

 

[Goodya]

Thank you,
but how can I read a layout file?

you would need to do this at run-time, read from a layout file etc. In
design mode, the changes are imposed immediately, overwriting your old
settings

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

i'm using Microsoft Office PivotTable 11.0 web component (activeX element)
in
my adp-project (access 2000) which is connected to a SQL Server 2000
database.
In design mode i set a ConnectionString for this PivotTable ActiveX
element
and degsign a layout for viewing data from a table. But if i change the
ConnectionString or a CommandText property my layout is lost. Could you
pls
help me with this, because I'd like the layout to be retained even if i
change those properties. This is needed sometimes if i want my front end
(adp-file) to be connected to the same DB on another machine for example/
Thank you in advance.
PS The best way for me would be if Connection string for PivotTable
element
was
automatically taken from ADP-file's Connection property

 

[Alvin Bruney - MVP ASP.NET]

It's a file you create with your settings - a custom file, could be a text
file or xml file, then read it on the object load

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

Thank you,
but how can I read a layout file?

you would need to do this at run-time, read from a layout file etc. In
design mode, the changes are imposed immediately, overwriting your old
settings

--
Regards,
Alvin Bruney

Shameless Author Plug
[The Microsoft Office Web Components Black Book with .NET]
www.lulu.com/owc, Amazon, Barnes & Noble etc
Forth-coming VSTO.NET
--------------------------------------------------------------------------------------------------------

i'm using Microsoft Office PivotTable 11.0 web component (activeX
element)
in
my adp-project (access 2000) which is connected to a SQL Server 2000
database.
In design mode i set a ConnectionString for this PivotTable ActiveX
element
and degsign a layout for viewing data from a table. But if i change the
ConnectionString or a CommandText property my layout is lost. Could you
pls
help me with this, because I'd like the layout to be retained even if i
change those properties. This is needed sometimes if i want my front
end
(adp-file) to be connected to the same DB on another machine for
example/
Thank you in advance.
PS The best way for me would be if Connection string for PivotTable
element
was
automatically taken from ADP-file's Connection property