Hi,

I have a datefield having the format A12V and the values under those are as follows:

Datefield
10-FEB-17
24-FEB-17
10-MAR-17
24-MAR-17
YTD AVG 2017

Now Iam plotting this on a bargraph as an ACROSS field and I want the dates to get plotted in the above displayed order but it is getting displayed as :
10-FEB-17
10-MAR-17
24-FEB-17
24-MAR-17
YTD AVG 2017

I tried sorting but at the end in the graph,Iam not getting the expected results.

Can anyone please let me know how can we do this?

Thanks a lot in advance for all your help.

Regards,
IP

This message has been edited. Last edited by: FP Mod Chuck,

This is a basic thing that any programmer must know.

Your field is a A12V which is an alpha field and alpha field are ordered alphabetically no matter what is its contain.

To be able to sort your "date" field properly you need to use either a date field, a "look like numeric" field or numeric field.

You need to add a NOPRINT field before your A12V field that will order properly your "not a real date" date field.

So as I mentioned, three choices:
1- Real date field, from there you have plenty format such as YYMD field
2- "Look like numeric" field. I mean by this is even if the field is an alpha field but is storing something such as 20170329, 20170330, 20170331, it will be ordered properly
3- Same as above but in numeric format

In conclusion you need a field that will store the Year, the Month and then the Day in that otder.

Now yours to perform the proper code to have your expected result.

GL

Hi Martin,

Sorry for the delay in response.
Yes,I tried your approach and it works only in the Table file approach and not in the Graph file.

Iam doing a NOPRINT on the new datefield which is being sorted in the ascending order and again using my original datefield in the graph but it is not working

Any thoughts?

Regards,
IP

Ideally, you ought to find out why a Date field is created with an Alpha format. You lose many of the features of a date format when you do this. If you can fix that, you won't have to deal with this issue. However, if this is just a throw away chart that doesn't have to be perfect, you can take a part the components of this Alpha field and re-assemble them so you can treat it as a date field. Following might be one approach but I'm sure there are a lot better ones out there. Keep in mind this doesn't take 4 digit year into account but shows you how to disassemble different parts.


In this example DOB is an A12 field that contains the same values you have in your data. I've added the check for the single digit days of the month in case you have something like 1-MAR-17.

DEFINE FILE ibisamp/ranktest                                                       
DAY_FLD/A2=GETTOK(DOB, 12, 1, '-', 2, 'A2');
DAY_LEN/I2=ARGLEN(2, DAY_FLD, 'I2');                          
AMON/A3 = IF DAY_LEN EQ 1 THEN EDIT(DOB,'$$999') ELSE EDIT(DOB,'$$$999');                                      
IMON/A2 = DECODE AMON(                                                 
  JAN 01 FEB 02 MAR 03 APR 04 MAY 05 JUN 06 JUL 07 AUG 08 SEP 09 OCT 10
  NOV 11 DEC 12);   
                                             
ADATE/A4MD = IF DAY_LEN EQ 1 THEN IMON | '0'| EDIT(DAY_FLD,'9') ELSE IMON | DAY_FLD; 
                                                 
END                
GRAPH FILE ibisamp/ranktest
SUM CNT.BUSINESS_RANK
BY ADATE
END

Hi BabaNYC,

I have tried sorting in the Table file request and it works fine but in the graph file,it is not working even though I give NOPRINT.
Thanks a lot for your help Really appreciate it!

Regards,
IP

Info4pal,

You may have something that is not applied properly because I can't see any reason why it wouldn't work for a graph. I did it in the pass.

Can you post your code ?

Hi,

Please see my code below:

 
-INCLUDE IBFS:/WFC/Repository/Reporting/Reference/conn_string.fex
-RUN
-**************************************************************************************************************************
SQL SQLORA PREPARE REPORT1 FOR
SELECT * FROM SCHEMA1.TABLE1;
END

TABLE FILE REPORT1
PRINT
CNT_IF_3_90
CNT_IF_2_90
CNT_IF_1_90
CNT_IF_0_90
CNT_IF_YTD_90
WHERE REPORT_TAB EQ ''
ON TABLE HOLD AS MYFILE
END
-RUN

-READFILE MYFILE
-RUN
-TYPE &CNT_IF_3_90
-TYPE &CNT_IF_2_90
-TYPE &CNT_IF_1_90
-TYPE &CNT_IF_0_90
-TYPE &CNT_IF_YTD_90

DEFINE FUNCTION DATEINFO (INFO/A12)
AMON/A3=EDIT(INFO,'$$$999');
MON/A2=DECODE AMON(JAN 01 FEB 02 MAR 03 APR 04 MAY 05 JUN 06 JUL 07 AUG 08 SEP 09 OCT 10 NOV 11 DEC 12);
ADATE/A8YYMD='20' || EDIT(INFO,'$$$$$$$99')|| MON || EDIT(INFO,'99');
DATEINFO/YYMD=ADATE;
END

DEFINE FILE REPORT1
INFO3/A12='&CNT_IF_3_90';
INFO2/A12='&CNT_IF_2_90';
INFO1/A12='&CNT_IF_1_90';
INFO/A12='&CNT_IF_0_90';
INFOY/A12='&CNT_IF_YTD_90';
DATE3/YYMD=DATEINFO(INFO3);
DATE2/YYMD=DATEINFO(INFO2);
DATE1/YYMD=DATEINFO(INFO1);
DATE/YYMD=DATEINFO(INFO);
END

TABLE FILE REPORT1
PRINT INFO3
INFO2
INFO1
INFO
INFOY
DATE3
DATE2
DATE1
DATE
BY DIVISION NOPRINT
ON TABLE HOLD AS MYFILE2
END
-RUN

-READFILE MYFILE2
-RUN
-TYPE &DATE3
-TYPE &DATE2
-TYPE &DATE1
-TYPE &DATE
-TYPE &INFOY

-SET &LOOP  = 0;
-SET &NBFLD = 13;

FILEDEF PIVOTED1 DISK NET_CAP_RPT/PIVOTED1.ftm

-REPEAT PIVOTCOL1 FOR &LOOP FROM 1 TO &NBFLD STEP 1

DEFINE FILE REPORT1
IND      /I3   = &LOOP.EVAL;
MEASTYPE /I3   = IF IND GE 9 AND IND LE 12 THEN 1
            ELSE 1;
PIVOTFLD /A40V = IF IND EQ 9  THEN CNT_IF_3_90
            ELSE IF IND EQ 10 THEN CNT_IF_2_90
            ELSE IF IND EQ 11 THEN CNT_IF_1_90
            ELSE IF IND EQ 12 THEN CNT_IF_0_90
            ELSE IF IND EQ 13 THEN CNT_IF_YTD_90;
DATEFLD  /A12V = IF IND EQ 9  THEN '&CNT_IF_3_90.EVAL'
            ELSE IF IND EQ 10 THEN '&CNT_IF_2_90.EVAL'
            ELSE IF IND EQ 11 THEN '&CNT_IF_1_90.EVAL'
            ELSE IF IND EQ 12 THEN '&CNT_IF_0_90.EVAL'
            ELSE IF IND EQ 13 THEN '&CNT_IF_YTD_90.EVAL';
DATEFLD_NEW /A12V = IF IND EQ 9 THEN '&DATE3.EVAL'
             ELSE IF IND EQ 10 THEN '&DATE2.EVAL'
           	 ELSE IF IND EQ 11 THEN '&DATE1.EVAL'
           	 ELSE IF IND EQ 12 THEN '&DATE.EVAL'
             ELSE IF IND EQ 13 THEN '&INFOY.EVAL';
NEW_REGION1/A3 = DECODE REGION ('E' 1 'MW' 2 'MTW' 3 'W' 4 'TOTAL CTL' 5);
REGION_CONCAT/A12 = NEW_REGION1 || REGION ;
REGION_MASK/A11=EDIT(REGION_CONCAT,'$9999999999');
END

TABLE FILE REPORT1
PRINT
PIVOTFLD
DATA NOPRINT
REGION_CONCAT
REGION_MASK
DATEFLD_NEW
BY DIVISION
BY REGION_CONCAT
BY REGION
BY STATE
BY DATEFLD
BY MEASTYPE
WHERE REPORT_TAB NE ''
ON TABLE HOLD AS PIVOTED1 FORMAT ALPHA
END
-RUN

FILEDEF PIVOTED1 DISK NET_CAP_RPT/PIVOTED1.ftm (APPEND
-PIVOTCOL1

DEFINE FILE PIVOTED1
PCTD/A10=CTRAN(10, PIVOTFLD, 37, 32, PCTD);
NEW_PIVOTFLD/D10.2%C = EDIT(TRIMV('B', PCTD, 10, ' ', 1, 'A10V'));
END

TABLE FILE PIVOTED1
PRINT
DIVISION
REGION_CONCAT
REGION_MASK
STATE
DATEFLD
MEASTYPE
PIVOTFLD
PCTD
NEW_PIVOTFLD
DATEFLD_NEW
BY REGION_CONCAT NOPRINT
BY STATE NOPRINT
BY MEASTYPE NOPRINT
BY DATEFLD_NEW NOPRINT
WHERE DIVISION NE '??'
WHERE REGION NOT LIKE '??' OR 'TOTAL E%' OR 'TOTAL W%'
WHERE STATE NE '??' OR 'TOTAL ??'
WHERE STATE LIKE 'TOTAL %'
WHERE PIVOTFLD CONTAINS '%'
WHERE DATA CONTAINS 'Congested w/o PE'
ON TABLE HOLD AS HOLD_GRAPH_FNL
END
-RUN

TABLE FILE HOLD_GRAPH_FNL
PRINT NEW_PIVOTFLD
BY DATEFLD_NEW
BY DATEFLD
BY MEASTYPE
BY REGION_CONCAT
BY REGION_MASK
-*ON TABLE PCHOLD FORMAT EXL07
ON TABLE HOLD AS FINAL_GRAPH FORMAT FOCUS
END
-RUN

GRAPH FILE FINAL_GRAPH
-* Created by Info Assist for Graph
SUM FINAL_GRAPH.SEG01.NEW_PIVOTFLD
BY FINAL_GRAPH.SEG01.REGION_CONCAT
ACROSS FINAL_GRAPH.SEG01.DATEFLD
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
ENDSTYLE
END
-RUN

The output of the table file request code is:

 
DATEFLD_NEW	DATEFLD		MEASTYPE REGION_CONCAT	REGION_MASK	NEW_PIVOTFLD
20170224	24-FEB-17	1		1E		E		 .46%
						2MW		MW		1.12%
						3MTW		MTW		 .87%
						4W		W		1.20%
						5TOTAL CTL	TOTAL CTL	 .92%
20170310	10-MAR-17	1		1E		E		 .46%
						2MW		MW		1.15%
						3MTW		MTW		 .70%
						4W		W		1.04%
						5TOTAL CTL	TOTAL CTL	 .85%
20170324	24-MAR-17	1		1E		E		 .55%
						2MW		MW		1.26%
						3MTW		MTW		 .81%
						4W		W		1.21%
						5TOTAL CTL	TOTAL CTL	 .97%
20170407	07-APR-17	1		1E		E		 .50%
						2MW		MW		1.14%
						3MTW		MTW		 .76%
						4W		W		1.15%
						5TOTAL CTL	TOTAL CTL	 .90%
YTD AVG 2017	YTD AVG 2017	1		1E		E		 .50%
						2MW		MW		1.25%
						3MTW		MTW		 .87%
						4W		W		1.23%
						5TOTAL CTL	TOTAL CTL	 .98%

 

In the graph file request,Iam not able to sort the Datefld based on the Datefld_new column even though I try not to print the Datefld_new column.

Please let me know what am I doing wrong.
Thanks a ton in advance for all your help!
I really appreciate it.

Regards,
IP

Hi,
You are not able to order by DATEFLD_NEW in the graph because at the step where you perform

ON TABLE HOLD AS HOLD_GRAPH_FNL

the field DATEFLD_NEW is a NOPRINT field so it doesn't exist in the HOLD file HOLD_GRAPH_FNL.

And I don't even understand how the next step can create the file FINAL_GRAPH with the field DATEFLD_NEW...

Hi Martin,

In my ON TABLE HOLD AS HOLD_GRAPH_FNL,only my sort field DATEFLD_NEW is not getting printed and Iam actually displaying the DATEFLD_NEW field.

Also in the graph,Iam trying to just sort based on DATEFLD_NEW and not print it and print the DATEFLD...Hope Iam clear now

 GRAPH FILE SAMPLE_GRAPH_ACCESS
-* Created by Info Assist for Graph
SUM SAMPLE_GRAPH_ACCESS.SEG01.NEW_PIVOTFLD
BY SAMPLE_GRAPH_ACCESS.SEG01.REGION_CONCAT
ACROSS SAMPLE_GRAPH_ACCESS.SEG01.DATEFLD_NEW NOPRINT
ACROSS SAMPLE_GRAPH_ACCESS.SEG01.DATEFLD
ON GRAPH PCHOLD FORMAT JSCHART
END
 

Was all clear that you want to sort on a hidden field. But the field must exist to sort on.

What I'm saying is that DATEFLD_NEW should not be usable in the GRAPH since it doesn't exist in the internal HOLD file FINAL_GRAPH.
This because when you perform the step where

ON TABLE HOLD AS HOLD_GRAPH_FNL

is done, you have

BY DATEFLD_NEW NOPRINT

resulting of DATEFLD_NEW not included in the internal HOLD file. So it cannot be used further on.

Remove the NOPRINT at that step and all should work.

Hi Martin,

Only in the table file request, Iam able to sort based on the DATEFLD_NEW and not print it and based on this sorting,my datefld gets displayed in the order ( 24-FEB-17,10-MAR-17,24-MAR-17,07-APR-17,YTD AVG 2017)which is needed whereas in the Graph file request,if I do sorting based on DATEFLD_NEW and not print it also and display the DATEFLD, I get the graph in this order which is not correct (07-APR-17,10-MAR-17,24-FEB-17,24-MAR-17,YTD AVG 2017) and I need the graph to be printed in the order
(24-FEB-17,10-MAR-17,24-MAR-17,07-APR-17,YTD AVG 2017).

 GRAPH FILE DUMMY_ACCESS
-* Created by Info Assist for Graph
SUM DUMMY_ACCESS.SEG01.NEW_PIVOTFLD
BY DUMMY_ACCESS.SEG01.REGION_CONCAT
ACROSS DUMMY_ACCESS.SEG01.DATEFLD
ON GRAPH PCHOLD FORMAT JSCHART
END 

The output of this is : (07-APR-17,10-MAR-17,24-FEB-17,24-MAR-17,YTD AVG 2017)

 GRAPH FILE DUMMY_ACCESS
-* Created by Info Assist for Graph
SUM DUMMY_ACCESS.SEG01.NEW_PIVOTFLD
BY DUMMY_ACCESS.SEG01.REGION_CONCAT
ACROSS DUMMY_ACCESS.SEG01.DATEFLD_NEW NOPRINT
ACROSS DUMMY_ACCESS.SEG01.DATEFLD
ON GRAPH PCHOLD FORMAT JSCHART
END 

The output is not getting displayed in a proper way.

Please let me know what am I doing wrong.

Regards,
IP

Two things I may think off:

1- What are your setting for (it may make a difference) :

ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 3

2- Try BY instead of ACROSS. Using ACROSS creates kind of new 3th dimension (x-y-z) where using a BY keep it as 2 dimensions (x-y). You may not need to use ACROSS.Using BY instead of ACROSS creates another graph's look.

Also, it seems that the NOPRINT doesn't have anymore effect on a graph. About this, a case may need to be open.

Hi,

In my case, if I use BY instead of across, it is not displaying the graph as per my need.
Only ACROSS helps but Iam unable to do sorting based on the DATEFLD so that it sorts according to the correct order and I have also opened a case with the IBI but haven't heard from them yet.

Here is my graph code:

-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+DQo8IS0tMS4wLS0+DQo8Um9vdCB2ZXJzaW9uPSIxLjAiPg0KICAgIDxPYmplY3Qgb2JqZWN0SWQ9IkNoYXJ0XzEiPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iTGlua2VkU29ydHMiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkNyb3NzVGFiTW9kZSIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPnRydWU8L1Byb3BlcnR5Pg0KICAgIDwvT2JqZWN0Pg0KICAgIDxPYmplY3Qgb2JqZWN0SWQ9IkdMT0JBTCI+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJTYW1wbGVEYXRhIiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+ZmFsc2U8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjUwMDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxSdW5SZWNvcmRMaW1pdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+MDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxPcHRpbWl6YXRpb24iIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIj50cnVlPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImZpZWxkRGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmxhYmVsPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9InByZWZpeERpc3BsYXlNb2RlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJBY3RpdmVfU3R5bGVfVXNlcl90eXBlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5wb3dlcjwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJHbG9iYWxWYWx1ZXNQYWdpbmciIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjQ8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiPg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iYXV0b0RyaWxsU2NyaXB0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIi8+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5RWRpdE1vZGVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlGb3JtYXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUhvbWVUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlRdWlja0FjY2Vzc1Rvb2xiYXJTYXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9Im1ldGFkYXRhX3ZpZXdzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlSZXNvdXJjZXNGaWVsZFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUluc2VydFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNsaWNlcnNUYWJFZGl0SW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJydW5PblN0YXJ0dXBEZWZlcnJlZEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+MTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj41PC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPlBERjwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW50ZXJhY3RpdmVNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9InJ1bk9uU3RhcnR1cEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5RGF0YVRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNsaWNlcnNUYWJJbnRlcmFjdGl2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+dHJ1ZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5TGF5b3V0VGFiSW5m
*-INTERNAL_COMMENT LINE#1$b01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgIDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJjYXNjYWRlTmFtZXMiIHR5cGU9Ik1hcCIvPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iTWFzdGVyX0ZpbGVzIiB0eXBlPSJTZXQiPg0KICAgICAgICAgICAgPEVudHJ5IHR5cGU9ImphdmEubGFuZy5TdHJpbmciPkRVTU1ZX0FDQ0VTUzwvRW50cnk+DQogICAgICAgIDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJtZXRhZGF0YVZpZXdBcyIgdHlwZT0iTWFwIj4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9IkRVTU1ZX0FDQ0VTUyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+TWV0YURhdGFUcmVlLlZJRVdfRElNUzwvRW50cnk+DQogICAgICAgIDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiI+dHJ1ZTwvUHJvcGVydHk+DQogICAgPC9PYmplY3Q+DQo8L1Jvb3Q+DQo=
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE DUMMY_ACCESS
-* Created by Info Assist for Graph
SUM DUMMY_ACCESS.SEG01.NEW_PIVOTFLD
BY DUMMY_ACCESS.SEG01.REGION_CONCAT
ACROSS DUMMY_ACCESS.SEG01.DATEFLD
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 2
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH
  

Hi,

I will try with some other method may be with ACROSS.
Thanks a lot Martin

Regards,
IP