Hi,

I'm having trouble with the use of some MDX statements while using a PivotTable component (OWC 11).

The following request works fine in the "MDX Sample Application" :

with member [Measures].[US] as '[Measures].[Store Sales]', FORE_COLOR='255', BACK_COLOR='65536'
select {[Measures].[US]} on columns ,
{[Store].members} on rows
from Sales
CELL PROPERTIES VALUE, FORMATTED_VALUE, FORMAT_STRING, FORE_COLOR, BACK_COLOR

But the same statement will fail while affected to the "CommandText" property of the PivotTable object.

Is there any limitation nd/or bug ?

Thanks.


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

What kind of failure is occurring, and has the "DisplayCellColor" pivot
table property been set?

http://support.microsoft.com/default...b;en-us;318122
PivotTable Component
...
When you set the DisplayCellColor property to True, the PivotTable
component applies Forecolor and Backcolor settings that are stored on
the server to the cells that appear in the PivotTable view. The default
setting for this property is False.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Thanks for your help,

The DisplayCellColor is not set, in fact, i can't view this property in Visual Studio ... it's a standalone VB.Net program, and i tried this with OWC11, OWC10 (XP) and OWC9, i cannot access this feature !

The exact error is :

The query could not be processed:
* The PivotTable list cannot load the MDX. Expecting '=' but found ', BACK_COLOR='65536'' instead.

Removing BACK_COLOR='65536' switch the error to the 'select' followin.
Add this expected '=', and the Pivot Table will ask for more and more '=' ... never negociate with an OWC
It seems that the PivotTable cannot understand my MDX syntax, but i dunno how to write it differently :-/

And please, excuse my crappy english


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Hi,

You should set color as rgb color (red, green and blue component of your
color) instead of color index.

Try this code sample in MDX sample application. It shows the calculated
member with red back color.

with member [Measures].[Back_Color Store Sales] as '([Measures].[Store
Sales])', Back_Color='rgb(255,0,0)'
select
{[Measures].[Back_Color Store Sales]} on columns,
{[Product].[Product Department].members} on rows
from Sales
CELL PROPERTIES VALUE, FORMATTED_VALUE, FORMAT_STRING, FORE_COLOR,
BACK_COLOR

Unfortunatelly Excel may map rgb colors to the nearest color index. Read
this KB article:
http://support.microsoft.com/default...b;en-us;190187

Zoltan

tonio_fuzz (AT) lesec (DOT) org írta: