The following example works in v5.3.2 EXL2K - the Across Column SALES is coloured green. In v7.6.5 it is the default color black, and the data is not formatted as D9.2M. For PDF and HTML it works as expected. For EXL2K the wrong field is displayed - SALES is displayed without the reformat. Of course, I know of a few workarounds, but I'd rather not have to modify a pile of programs.

-SET &OUTFMT = 'EXL2K';
-*SET &OUTFMT = 'PDF';
-*SET &OUTFMT = 'HTML';

TABLE FILE CAR
SUM
SALES/D9.2M AS ''
ACROSS COUNTRY AS 'SALES'
BY SEATS
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=BLUE, $
TYPE=REPORT, ACROSSCOLUMN=SALES, COLOR=GREEN, $
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
ON TABLE PCHOLD FORMAT &OUTFMT
END

This message has been edited. Last edited by: Francis Mariani,

quote:

TYPE=REPORT, ACROSSCOLUMN=SALES, COLOR=GREEN, $

it looks like this is the culprit - remove this line and the column is formatted correctly.

ew yuck
thats a bug alright.
francesco, btw, why does conditional styling not work on ACROSSs?

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

What about:

quote:

TYPE=DATA, COLUMN=SALES, COLOR=GREEN, $

?

this was probably one of the workarounds you had in mind but this is what i would have done first as i wouldn't consider the sales column an across column

SALES is definitely an Across column - there is more than one SALES column displayed in the row.

TYPE=DATA, COLUMN=SALES, only affects the first SALES column. TYPE=DATA, COLUMN=SALES(*) doesn't work at all.

Susannah, "why does conditional styling not work on ACROSSs?" - Very good question.

Susannah,

Here's an example of a conditional ACROSS:

TABLE FILE CAR
PRINT DEALER_COST
ACROSS COUNTRY
BY CAR
ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=DEALER_COST, COLOR=RED, WHEN=DEALER_COST GT 9000, $
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

Seems to work.

ah...
i was being fuzzy...
what i would want the condition on is the across column value
WHEN=COUNTRY EQ 'ENGLAND',$

susannah, you're asking for too much

TABLE FILE CAR
PRINT 
DEALER_COST
COUNTRY NOPRINT
ACROSS COUNTRY
BY CAR
ON TABLE SET STYLE *
TYPE=DATA, ACROSSCOLUMN=DEALER_COST, COLOR=RED, WHEN=COUNTRY EQ 'ITALY', $
ENDSTYLE
-*ON TABLE PCHOLD FORMAT EXL2K
END

This changes the report output a tiny bit, because more than one column is specified in the PRINT (DEALER_COST and COUNTRY).

Hi Francis,

I passed this one internally and was suggested that the issue can be reproduced in 768. It is better to contact Information Builders' Customer Support Services and open a case for this problem so that it can be submitted to appropriate department to address it.

To open a case, you may either call at 1-800-736-6130, or access online at InfoResponse.

Hope this helps.

Cheers,

Kerry

quote:

SET &OUTFMT = 'EXL2K';
-*SET &OUTFMT = 'PDF';
-*SET &OUTFMT = 'HTML';

TABLE FILE CAR
SUM
SALES/D9.2M AS ''
ACROSS COUNTRY AS 'SALES'
BY SEATS
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=BLUE, $
TYPE=REPORT, ACROSSCOLUMN=SALES, COLOR=GREEN, $
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
ON TABLE PCHOLD FORMAT &OUTFMT
END

You are right..

what about:

 -SET &OUTFMT = 'EXL2K';
-*SET &OUTFMT = 'PDF';
-*SET &OUTFMT = 'HTML';

TABLE FILE CAR
SUM
SALES/D9.2M AS ''
ACROSS COUNTRY AS 'SALES'
BY SEATS
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
TYPE=REPORT, FONT='ARIAL', SIZE=8, COLOR=BLUE, $
TYPE= ACROSSTITLE, COLOR=GREEN, $
TYPE=REPORT, ACROSSCOLUMN=N1, COLOR=GREEN, $
TYPE=TITLE, STYLE=BOLD,COLOR=GREEN, $
ENDSTYLE
ON TABLE PCHOLD FORMAT &OUTFMT
END 

its still not quite there but the ACCROSSCOLUMN=N1 should give you a starting point?

I have steadfastly refused to use column notation syntax in my style-sheet (as evidenced by this posting yesterday, How to you identify columns example N1 goes with what column? it's not column one) and now it saves the day!

Thank you very much nubi, for being less narrow-minded than me - you are absolutely right, column notation fixed the problem.

klugy w/a, francesco
but hyper clever...as usual.
i'll give it a go. merci

quote:

Originally posted by Francis Mariani:
I have steadfastly refused to use column notation syntax in my style-sheet (as evidenced by this posting yesterday, How to you identify columns example N1 goes with what column? it's not column one) and now it saves the day!

Thank you very much nubi, for being less narrow-minded than me - you are absolutely right, column notation fixed the problem.

to be honest its not obvious and i spent simply ages trying to work this out, it also doesn't appeal to my preference for precise code so i had also discounted the idea....


ive just tried to explain why but deleted the paragraph as i was confusing the issue - ill try again tomorrow as i must get off.

From the case I opened regarding this problem:

quote:

This issue has been addressed and tested successfully in WebFOCUS release 769 which is not yet available. We won't be able to obtain a hotfix for release 765.