Hello,
I am facing some problems in using graph api.The code is given below :

REMOTE DEST=TEST
-REMOTE BEGIN
SET GRAPHEDIT =SERVER
SQL SQLDBC
SELECT SUM(D.AMOUNT) AS AMOUNT,((CURRENT_DATE-D.BIL_DT) -C.TERMS)
AS DPT FROM
MYTABLE1,MYTABLE2,MYTABLE3

WHERE CONDITION1 AND CONDITION2 AND CONDITION3 AND
DPT >= '&START_DAY' AND DPT < ('&START_DAY'+10)
GROUP BY DPT;
TABLE HOLD AS HOLD1
END
GRAPH FILE HOLD1
PRINT
AMOUNT AS 'Dollars'
ACROSS DPT AS 'Days'

ON GRAPH SET LOOKGRAPH 3DBAR
ON GRAPH SET GRAPHSTYLE *
setURL(0,0,"JAVASCRIPT:fnload(&START_DAY);");
setURL(0,1,"JAVASCRIPT:fnload(&START_DAY+1);");
setURL(0,2,"JAVASCRIPT:fnload(&START_DAY+2);");
setURL(0,3,"JAVASCRIPT:fnload(&START_DAY+3);");
setURL(0,4,"JAVASCRIPT:fnload(&START_DAY+4);");
setURL(0,5,"JAVASCRIPT:fnload(&START_DAY+5);");
setURL(0,6,"JAVASCRIPT:fnload(&START_DAY+6);");
setURL(0,7,"JAVASCRIPT:fnload(&START_DAY+7);");
setURL(0,8,"JAVASCRIPT:fnload(&START_DAY+8);");
setURL(0,9,"JAVASCRIPT:fnload(&START_DAY+9);");
setURL(0,10,"JAVASCRIPT:fnload(&START_DAY+10);");
ENDSTYLE
END
-REMOTE END
-HTMLFORM BEGIN
HTML

BODY

script
function fnload(str)
{
alert(str);
}
script

BODY

HTML
-HTMLFORM END

**********************************
Now my problem: Suppose &START_DAY=25. The graph works fine if there is data retrieved for START_DAY=25,26,27.28 and so on. .But incase of there being no data for START_DAY=25 and data is retrived for START_DAY=27 onwards then everything goes for a toss.. The first bar when clicked alerts "25" though x axis value shows a value 27 !!

I want the value 27 to be passed to the java script.. How do I do it??


Thanks,
Kalyan

The best bet would be to take the new Start date from the table call.

Something like:

TABLE FILE HOLD
SUM ...
BY DPT
*(which is the start_day I'm guessing)*
ON TABLE HOLD FORMAT ALPHA
END
-RUN
-READ HOLD &NEW_FIRST_DAY.I2.
-RUN

*(Assuming the value is a 2 digit number)*

Then using &NEW_FIRST_DAY as the start value for the graph API calls.


Leo

Isn't it sufficient to use WebFOCUS stylesheets instead of TDG API in this case ?


-* ...
ON GRAPH SET STYLE *
TYPE=DATA, JAVASCRIPT=fnload( DPT ),$
ENDSTYLE
-*...


Regards
Grzegorz