Can anyone point out what I am doing wrong here? Well don't point out everything , but I cannot seem to figure out why my formatting is not taking place.

When I tested this, it worked fine, but I only had 1 record that had PRC_EFF_DAT GT than CURRDATE. New records have been added and my conditional formatting went away.

Thanks for the help

 DEFINE FILE FAM_CAT_PRC
CURRDATE/YYMD=&YYMD;
END
SET BYDISPLAY=ON
TABLE FILE FAM_CAT_PRC
SUM
	  STD_PRC
	  PRC_EFF_DAT NOPRINT
	  CURRDATE NOPRINT
ACROSS SITE_NUM AS ''
BY FAMILY_CAT_ID NOPRINT
BY MAJOR_CATEGORY_DES
BY FAMILY_CATEGRY_DES
BY LINK_ID
BY PROD_DES
WHERE MAJOR_CATEGORY_DES = &MAJOR_CAT_DES.(OR(FIND MAJOR_CATEGORY_DES IN MAJOR_CATEGORY)).MAJOR_CAT_DES.;
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=STD_PRC, BACKCOLOR=YELLOW, WHEN=PRC_EFF_DAT GT CURRDATE ACROSS SITE_NUM, $ 

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

first question- why is your across statement in your when statement

Without looking too deep, have you tried

TYPE=DATA, COLUMN=STD_PRC(*), BACKCOLOR=YELLOW, WHEN=PRC_EFF_DAT GT CURRDATE, $

T

quote:

Originally posted by nubi:
first question- why is your across statement in your when statement

Sorry, miss print, it should be

 TYPE=DATA, COLUMN=STD_PRC, BACKCOLOR=YELLOW, WHEN=PRC_EFF_DAT GT CURRDATE, $ 

Tony - I tried your suggestion, still no formatting.

Tom,

Where in the manual?

I'd love to see a working example.

This doesn't work:

TABLE FILE CAR
SUM
SALES
LENGTH 
COMPUTE FLAG/A1 = IF LENGTH GT 200 THEN '1' ELSE '0'; NOPRINT
ACROSS SEATS
BY COUNTRY
ON TABLE SET STYLE *
TYPE=DATA,  COLUMN=SALES, BACKCOLOR=YELLOW, WHEN=FLAG EQ '1', $
ENDSTYLE
END

It only works for the first column, as I expect it to.

Tom

I thought I had read that if you have 2 or more conditions that you need to use an IF/THEN/ELSE to give a TRUE/FALSE for conditional formatting. If it's a single condition then what I had should of worked, which it did, when I tested it in the first place with just a single record meeting this criteria.

Since now I have multple records the formatting is not happening.

I tried your sugestion and that still did not accomplish this. I will keep poking around.

Thanks for the suggestions so far.

quote:

I purposely left out the correct syntax so the manual would be checked

That's a waste of time.

Thanks for posting a working example.

I thought that COLUMN=SALES would not work, why waste time with posting the wrong syntax?

MattC, try ACROSSCOLUMN instead of COLUMN in the stylesheet.

Thanks Francis, that worked.

I apologize for being new at this. I do try and research as much as possible before posting up here.

Thanks again.

MattC,

I gathered that you had tried researching this problem - I'm sorry other people are wasting our time.

Regards,

Francis.