Hi All,

I am having main graph and one drilldown graph. I want to pass two parameters from main to drilldown, but i dont want to display one of the field in main graph. I have tried with noprint, but it dint work. Please give me any suggetions.
Thanks in advance.

This message has been edited. Last edited by: Kerry,

Koteswar,

First of all, please update your profile signature with your product suite, release and platform so that we can better help you. There is a sticky post that gives directions.

Secondly, can you reproduce your question with the CAR file (in ibisamp) and then post the code?

Thanks.

Hi All,

I am having main graph and one drilldown graph. I want to pass two parameters from main to drilldown, but i dont want to display one of the field in main graph. I have tried with noprint, but it dint work. Please give me any suggetions.

Here is the example:
SET ASNAMES = ON
TABLE FILE EMPDATA
SUM CNT.PIN AS 'COUNTS'
SALARY
BY DEPT
BY DIV
ON TABLE HOLD AS HOLDSUM
END
-RUN
GRAPH FILE HOLDSUM
SUM
COUNTS
SALARY
BY DEPT NOPRINT
BY DIV
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET STYLE *
TYPE=DATA,
COLUMN=N2,
TARGET=_self,
FOCEXEC=itlc_application_drill1.fex(DIV= DIV DEPT= DEPT),
$
ENDSTYLE
END



Thanks.

koteswar
---------------------------------
Prod: WF 7.6.4 with 7.6.4 WFRS;
Dev: WF 7.6.1 with 7.6.1
Primarily self-service; adapters: Teradata, DB2, Oracle, SQL Server

Please see this most recent thread:

https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/3761048992

I did something very similar to this recently. All you have to do is put your drill down variables under your SUM command and use NOPRINT. Dont put them as BY statements.

So for example:

SET ASNAMES = ON
TABLE FILE EMPDATA
SUM CNT.PIN AS 'COUNTS'
SALARY
BY DEPT
BY DIV
ON TABLE HOLD AS HOLDSUM
END
-RUN
GRAPH FILE HOLDSUM
SUM
COUNTS
SALARY
DEPT NOPRINT
BY DIV
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET STYLE *
TYPE=DATA,
COLUMN=N2,
TARGET=_self,
FOCEXEC=itlc_application_drill1.fex(DIV= DIV DEPT= DEPT),
$
ENDSTYLE
END