Change a value in a pivot table cell

[Igor]

I want to use the write back on my Pivot Table. What I need is change a
total value and the pivot table automatically changes the details and change
a detail line and automatically change the total. How can I do that?

Another question: how can I get what the double click in a cell and its
value?

Thanks,

Igor.

 

[Luzzifuge]

Anyone

 

[Luzzifuge]

Does anyone can Help me? I just want to know how to change a value fo
the select cell in a Pivot Table?

Please ..........

 

[Alvin Bruney - ASP.NET MVP]

pivot tables function as read-only. You should be changing the data in cube
or underlying datasource first and then it will show correctly in the pivot
table object. If what you are after is write back, you will need to read the
property and then write the necessary query or MDX to push the data to the
underlying cube or datastore.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Does anyone can Help me? I just want to know how to change a value for
the select cell in a Pivot Table?

Please ...........

http://www.officehelp.in/archive/index.php |
http://www.officehelp.in/index/index.php

 

[Luzzifuge]

But I saw some samples in ASP.Net where the user can changes the value
typing directelly in the Pivot Table Cell. Unfortuntelly I dont hav
the source code and It's for ASP.Net and what I nedd is Windows Forms

 

[Igor]

Can you please write an example code, just a simple one? Not in VS.Net but
right here, to make the things clear.

Thanks

pivot tables function as read-only. You should be changing the data in cube
or underlying datasource first and then it will show correctly in the pivot
table object. If what you are after is write back, you will need to read the
property and then write the necessary query or MDX to push the data to the
underlying cube or datastore.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006
-------------------------------------------------------

Does anyone can Help me? I just want to know how to change a value for
the select cell in a Pivot Table?

Please ...........

http://www.officehelp.in/archive/index.php |
http://www.officehelp.in/index/index.php

 

[Luzzifuge]

Ok, but do you have a sample where I retrieve of selected value of
PivotTable (in a Windows Application) and build the MDX query? I can'
do that.

Thank you