In a monthly we have a weekly need to show as column Title
[B]Monday, May 1, 2017[/B] [B]Car[/B] [B]Tuesday, May 2, 2017[/B] [B]Car[/B] [B]Wednesday, May 3, 2017[/B] [B]Car[/B] [B]Thursday, May 4, 2017[/B] [B]Car[/B] [B]Friday, May 5, 2017[/B] [B]Car[/B]
Can any one help to guideThis message has been edited. Last edited by: FP Mod Chuck,
WebFOCUS 8202
August 28, 2017, 10:18 AM
BabakNYC
I'm not sure if I understand your requirement. Also, are you really using WebFOCUS version 7.6?
WebFOCUS 8206, Unix, Windows
August 29, 2017, 02:46 AM
Developer
i have two column(week day & car Column ) its should add the right of that still that weekday of Friday
and i'm using WebFOCUS version 8.0
WebFOCUS 8202
August 29, 2017, 06:06 AM
Dev
any sample....
Will this will help you....
DEFINE FILE CAR
DATE_1/YYMD = '20170501';
DATE_BOW/YYMD = DATEMOV(DATE_1, 'BOW');
DATE_EOW/YYMD = DATEMOV(DATE_1, 'EOW');
END
TABLE FILE CAR
BY COUNTRY/A10
BY DATE_BOW
BY DATE_EOW
ON TABLE HOLD AS DATEX FORMAT ALPHA
END
-RUN
-SET &K = 1;
-DEFAULTH &Col_title = '';
-REPEAT :Date 5 TIMES
-READ DATEX &country.A10. &date_bow.A8.
-SET &country&K.EVAL = TRUNCATE(&country);
-TYPE &country&K.EVAL
-SET &date_bow&K.EVAL = IF &K EQ 1 THEN &date_bow ELSE &date_bow + (&K.EVAL - 1);
-TYPE &date_bow&K.EVAL
-SET &Col_title = IF &K EQ 1 THEN &date_bow&K.EVAL | ' ' | &country&K.EVAL ELSE (&Col_title) | ' ' | &date_bow&K.EVAL | ' ' | &country&K.EVAL;
-TYPE &Col_title
-SET &K = &K + 1;
-:Date
This message has been edited. Last edited by: Dev,
8202, 8105M, 7.7.03
August 29, 2017, 11:50 AM
Crymsyn
Could you give an example of a stored value or two of your "week day" column or which ever field determines if it should show under Monday, Tuesday, etc?
Depending on that may be able to use an ACROSS on it.