Maintaining pivot table state on postback / refresh

[Omar]

NB: I posted this before but I cannot trace it. I think someone deleted
it coz of a typo. Anyway,

Hello,
I am trying to use a Pivot table(11.0) to display data from a database.
My
table has 96 columns. Some users select some columns (let's say 5) and
add
them to the pivot table. However, once they refresh the page in IE, the

columns are removed and the pivot table is blank once again.

Is there a way that I can maintain the state of the pivot table? i.e if
the
user selects 5 columns, and then refreshes the page, it should still
display
5 columns. Or if they go to the next page and go back (using IE
feature), it should be the same.

I would also like to know if the state can be maintained on post backs
which do not affect the pivot table contents.

I am using ASP.NET 1.1, SQL server 2000. Developing on XP Professional
and
testing on IE 6.0

Regards,
Omar

 

[Alvin Bruney [MVP]]

No, you need to explicitly rebind to the data source.