color for style on mdx query

[catador]

Hi!!

 

i have this query

 

with member [Measures].[Var%Rango] as '(([Measures].[VarCuLP] * 100.0) / ([Producto].CurrentMember, [Measures].[CuActual]))', FORMAT_STRING = IIf(([Measures].[Var%Rango] < 15.0), IIf(([Measures].[Var%Rango] < 10.0), IIf(([Measures].[Var%Rango] < 0.0), "|#|style=green", "|#|style=yellow"), "|#|style=HOWPUTORANGE"), "|#|style=red")

select {[Measures].[Qty], [Measures].[CuActual], [Measures].[CuLP], [Measures].[VarCuLP], [Measures].[Var%CuLP], [Measures].[MaxHjs], [Measures].[Var%Rango]} ON COLUMNS,

{[Producto].[All Productos], [Producto].[All Productos].[FPC ], [Producto].[All Productos].[PBB ], [Producto].[All Productos].[Producto T], [Producto].[All Productos].[servicio ]} ON ROWS

 

and i wan't put a orange back color when the values it's between 10 and 15.

 

if i put orange... the number looks left ident, i can put the number in hex? how? :D

 

Thanks for this help... this colors be a great help for directors!!

 

Best Regards!!!

[swood]

In the WAR, look at jpivot/table/mdxtable.css.

 

See the styles like:

 

Code:

td.cell-red,
span.cell-red
{
  background-color: #FF6666; 
}

 

Create a style like this with it's particular background color.

 

Code:

[code] td.cell-orange, span.cell-orange { background-color: #hex for orange; }

 

There are some other styles that refer to "td.cell-???". Add your td.cell-??? and td.span-??? there too.

 

 

 

Sherman

JasperSoft

[catador]

Hi!!

 

Thanks for answer!! i add this to file

td.cell-orange,

td.cell-naranjo,

span.cell-orange,

span.cell-naranjo

{

background-color: #FD9C03;

}

 

but when i put orange on style in mdx query doesn't works fine and no have any error message.

 

thanks for your help!

[catador]

Hi!!

 

Thanks for answer!! i add this to file

td.cell-orange,

td.cell-naranjo,

span.cell-orange,

span.cell-naranjo

{

background-color: #FD9C03;

}

 

but when i put orange on style in mdx query doesn't works fine and no have any error message.

 

thanks for your help!

[swood]

As I said, you need to do more than that.

 

Add td.cell-orange and span.cell-orange in all the styles where td.cell-red and span.cell-red are referenced.

 

 

 

Sherman

JasperSoft

[catador]

Hi Sherman,

 

If i search css files in jasperserver webapp exist those:

./cal/calendar-win2k-1.css

./wcf/form/xform.css

./wcf/tree/xtree.css

./wcf/table/xtable.css

./wcf/pagestack/pagestack.css

./wcf/tabbed/xtabbed.css

./wcf/status/status.css

./wcf/wcf.css

./wcf/catedit/xcatedit.css

./stylesheets/stylesheet.css

./stylesheets/base.css

./stylesheets/styles.css

./jpivot/navi/mdxnavi.css

./jpivot/table/mdxtable.css

 

just in mdxtable i found the definition of sytles... and i add orange definition...

 

/* data cells */

td.cell-even,

td.cell-odd,

td.cell-red,

td.cell-yellow,

td.cell-green,

td.cell-rot,

td.cell-gelb,

td.cell-gruen,

td.cell-orange, -> i add this

td.cell-naranjo, -> i add this

td.property-value,

td.property-span {

font-family: Verdana, Geneva, Arial, Helvetica, sans-serif;

font-size: 0.8em;;

color : Black;

text-align: right;

}

 

and this..

td.cell-orange,

td.cell-naranjo,

span.cell-orange,

span.cell-naranjo

{

background-color: #FD9C03;

}

 

it's ok this? because just mdxtable file have this definitions.

 

Thanks for your help.

 

:D

[swood]

It should just be in mdxtable.css. So it did not work? What are you seeing?

 

 

Sherman

JasperSoft

[catador]

Hi,

 

When i use orange color, cell value appear left ident and white background, but i can work, no exists any signal of error, a bug?

 

best regards,

 

catador!

[swood]

Have you looked at the HTML being produced? What is the difference between the HTML for a red cell vs the orange cell?

 

 

Sherman

JasperSoft