TABLE FILE CAR
SUM SALES RPCT.SALES
BY CAR ACROSS COUNTRY
Does anyone know how to identify the RPCT field in a style sheet?
without C notation and multiple statements?
molto grazie.

Hi Susannah,

Go and have a lay down, you must be working too hard! I thought you would have known this one -

TABLE FILE CAR
SUM SALES RPCT.SALES
BY CAR
ACROSS COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
  TYPE=DATA, ACROSSCOLUMN=RPCT.SALES, COLOR=RED, $
ENDSTYLE
END

T

ROFL
bless your ever lovin' heart.

T, help me with another one,wouldyou?
TYPE=ACROSSVALUE,ACROSS=fieldname,WHEN=fieldname EQ whatever
..
The WHEN= just doesn't work.
I tried setting it up as a DEFMACRO
no cigar.

This message has been edited. Last edited by: susannah,

Hi susannah,

Shouldn't it be

TYPE=DATA,ACROSSCOLUMN=CAR,BACKCOLOR='RED', WHEN=CAR EQ 'ALFA ROMEO',$

*just a humble attempt*

P.

Susannah,

In a wierd way I think Pete has highlighted when the WHEN might function, albeit, incorrectly (the WHEN not Pete ).

If you take my above example and add your requirement, say for CAR EQ 'PEUGEOT' you will see that the styling is not applied to COUNTRY. However, if you change the WHEN to compare for 'ALFA ROMEO', the styling is applied. I think this is because the style is applied to a heading value and because these are at the top, they have the style that is relevant to the first data row?

TABLE FILE CAR
SUM SALES RPCT.SALES
BY CAR
ACROSS COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
  TYPE=DATA, ACROSSCOLUMN=RPCT.SALES, COLOR=RED, $
  TYPE=ACROSSVALUE, ACROSS=COUNTRY, COLOR=BLUE, WHEN=CAR EQ 'PEUGEOT', $
ENDSTYLE
END

The styling is not applied

TABLE FILE CAR
SUM SALES RPCT.SALES
BY CAR
ACROSS COUNTRY
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
  TYPE=DATA, ACROSSCOLUMN=RPCT.SALES, COLOR=RED, $
  TYPE=ACROSSVALUE, ACROSS=COUNTRY, COLOR=BLUE, WHEN=CAR EQ 'ALFA ROMEO', $
ENDSTYLE
END

The styling is applied.

I can see a sort of logic to this but I'm stuck at seeing a real use for it? Unless you page break on the field in the WHEN clause (e.g. BY CAR PAGE-BREAK).

Of course, take away the WHEN and it works fine.

T

Way over my belgian head on a wednesday morning , T.

Pete, Must be all that lovely Belgian chocolate for breakfast!

i'm trying to put a drilldown on an across value when that value equals something.
i'm getting no cigar.
i think its a bug, but i'm only in 52 and my 71 dev server just bit the dust.

The across value seems to relate the column title and not the value. Is that what you want or do you want the tabular data?

Value, T.
If country is 'france' i want the cell to be hot, if country is anything else, then cold.
type=acrossvalue, across=country,when=country eq 'france', focexec= yada.
Conditional dd's like this work fine on regular table data cells, so i'm thinking they should work on acrossvals, as well.

Ahhh, the light comes on.

Doesn't appear to work in 7.1.3 either.

bless you for checking.
i'll NFR it.

Just found in the manual (Creating reports vsn 7) page 24-7 that you can not specify a horizontal sort field (ACROSS) within the WHEN.

There had to be a reason