H
Hans Riis
I have an onload script to use serverside formatting in OWC
pivottables in webpages. The script works fine with one table but if I
have two or more on the same page it takes a refresh for all the
formats to apply. It's always the same measures that are formatted/not
formatted every time I load the page.
To eliminate any cache issues I've tried opening the page on another
computer. I've also tried inserting a sleep before running the script
but the only thing that seems to work is hitting the refresh button.
Here's the code for one table:
Function spawnDT()
pt.ActiveView.UseProviderFormatting = true
pt.Drillthrough.UserInterface.SetViewMode(pt.Drillthrough.Constants.plDrillthroughViewModeSpawn)
pt.ActiveView.DisplayCellColor = true
End Function
Regards, Hans Riis
pivottables in webpages. The script works fine with one table but if I
have two or more on the same page it takes a refresh for all the
formats to apply. It's always the same measures that are formatted/not
formatted every time I load the page.
To eliminate any cache issues I've tried opening the page on another
computer. I've also tried inserting a sleep before running the script
but the only thing that seems to work is hitting the refresh button.
Here's the code for one table:
Function spawnDT()
pt.ActiveView.UseProviderFormatting = true
pt.Drillthrough.UserInterface.SetViewMode(pt.Drillthrough.Constants.plDrillthroughViewModeSpawn)
pt.ActiveView.DisplayCellColor = true
End Function
Regards, Hans Riis