S
Simon Masters
I have read many helpful articles regarding excel Web-Publishing
http://www.devx.com/webdev/Article/10172#codeitemarea
What is not said is that the Office Web Components do NOT behave as we might
expect when publishing Pivot Tables as HTML in interactive mode
I have found to my disappointment that a pivot table (or a chart published
from a pivot table) using an OLAP source does not “lock down†the page
fields, row fields, column fields and data fields in the published HTML even
when the “DragTo…†properties in the Excel are set False to prevent this.
Giving over-enthusiastic users a free pivot can mean a well-presented report
trashed in seconds.
What I am seeking (and I suspect a great many OLAP report designers require)
is a report between static HTML and “full interactive pivotâ€
I cannot think I have missed some property setting because the HTML
generated by Excel contains <NoDragToPage/> tags
Amazingly though Google has only four hits on NoDragToPage - all schema
related and not related to user experience
Excel is NOT good in its documentation for interactive pivot.
Thanks for any response you can provide…
Simon Masters
http://www.devx.com/webdev/Article/10172#codeitemarea
What is not said is that the Office Web Components do NOT behave as we might
expect when publishing Pivot Tables as HTML in interactive mode
I have found to my disappointment that a pivot table (or a chart published
from a pivot table) using an OLAP source does not “lock down†the page
fields, row fields, column fields and data fields in the published HTML even
when the “DragTo…†properties in the Excel are set False to prevent this.
Giving over-enthusiastic users a free pivot can mean a well-presented report
trashed in seconds.
What I am seeking (and I suspect a great many OLAP report designers require)
is a report between static HTML and “full interactive pivotâ€
I cannot think I have missed some property setting because the HTML
generated by Excel contains <NoDragToPage/> tags
Amazingly though Google has only four hits on NoDragToPage - all schema
related and not related to user experience
Excel is NOT good in its documentation for interactive pivot.
Thanks for any response you can provide…
Simon Masters