I Have a requirement as below report
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,
I'm not sure if I understand your requirement. Also, are you really using WebFOCUS version 7.6?
WebFOCUS 8206, Unix, Windows
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
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; -:DateThis message has been edited. Last edited by: Dev,
8202, 8105M, 7.7.03
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.
WF: 8201, OS: Windows, Output: HTML, PDF, Excel
|Powered by Social Strata|