Can OWC pass through Server Side Cell shading set in Analysis Mana

  • Thread starter Nils Wallerstedt
  • Start date
N

Nils Wallerstedt

Is there a setting on the OWC to allow server side cell shading to pull through, similar to the Data Viewer inside Microsoft Analysis Services?

For example, in designing a calculated member, you add an iif condition of the backcolor property to allow for a Red, Yellow, and Green dashboard effect.

Thanks in Advance,

Nils Wallerstedt
 
A

Alvin Bruney [MVP]

short answer no. what are you trying to do? maybe there is a workaround
 
H

Hans Riis

Hi Niels.

I'm not sure if this is what you're looking for but this little script
enables serverside formatting and coloring when you're using OWC in
web pages.

<body onload=spawnDT()>

<SCRIPT language=VBScript>

Function spawnDT()
Pivottable.ActiveView.UseProviderFormatting = true
Pivottable.ActiveView.DisplayCellColor = true
End Function

</SCRIPT>

Regards, Hans Riis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Cells which have Bold & Red Strike Effect Through Conditional Formatting 2
Problems Loading Large String Array into Array variable 6
Today's News: Set up Lotus Notes V8 for Outlook users 1
New books 10

Top