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 guide

This 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?

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

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,

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.