Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]NOPRINT command IN Graph
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]NOPRINT command IN Graph
 Login/Join
 
Member
posted
Please give me solution for graph to use NOPRINT command in BY Field. NOPRINT Column should not display in Graph X-Axis.Also I have to pass that noprint column to drilldown report.here is my example
Eg: GRAPH FILE EMPDATA
SUM
SALARY
BY EMPDATA.EMPDATA.DIV NOPRINT
BY EMPDATA.EMPDATA.JOBCLASS
ON GRAPH SET LOOKGRAPH VBAR2AX
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET GRMERGE ON
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 490
ON GRAPH SET HAXIS 850
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.00000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='SansSerif',
SIZE=10,
BACKCOLOR=RGB(255 255 255),
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N3,
TARGET=_self,
FOCEXEC=app_drill1.fex(JOBCLASS= JOBCLASS DIV= DIV),
ENDSTYLE
END

This Column BY DIV NOPRINT

This message has been edited. Last edited by: PRAKASH N V,


WF: WebFOCUS 7.6.4/7.6.8/7.6.10/7702/7703
Windows: XP/NT,
Output formats: HTML,PDF,EXCEL,ACTIVE HTML
 
Posts: 13 | Registered: June 30, 2008Reply With QuoteReport This Post
<JG>
posted
NOPRINT is not supported on BY fields in GRAPH requests (It is coming soon).

The only thing you can currently do is generate your own labels and include them in the API styling.

There are plenty of posts on the issue. Search for them
 
Reply With QuoteReport This Post
Platinum Member
posted Hide Post
You can still do the graph just break the process into two steps..
eg.
SUM SALARY
BY EMPDATA.EMPDATA.DIV NOPRINT
BY EMPDATA.EMPDATA.JOBCLASS
ON TABLE HOLD AS FRED
END
GRAPH FILE FRED
PRINT SALARY
BY JOBCLASS
...rest of graph..


Release 7.6.9
Windows
HTML
 
Posts: 226 | Registered: June 08, 2003Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Good suggestions, but what Prakash did not clearly pointed out is why he wants to have the two by fields in the selection.

In one of the last lines of his coding he has a drill down to an other fex where he gives the two values JOBCLASS and DIV as variables to the next process.

If that is the reason for the hidden BY field the problem is still not solved.

Is it Prakash?




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Reply With QuoteReport This Post
Expert
posted Hide Post
I Added the closing '$' just before the ENDSTYLE and a heading line to show different execution results

HEADING
"&DATEMTDYY @ &TOD FOR &|JOBCLASS: &JOBCLASS &|DIV: &DIV"

And it works... and passes the DIV as well. Isn't that what you're looking for?

Is it Prakash - from NJ Spirit 2007?
 
Posts: 3040 | Location: Middle Tennessee [8204M Gen48 in Test&Prod] | Registered: February 23, 2005Reply With QuoteReport This Post
<JG>
posted
The issue as I understand it is that the label on the ordinal axis are coming out as

CE:019PTA, CE:019PUA, CE:019PVB etc.

When what he wants to see is

019PTA, 019PUA, 019PVB

The only way that you can do that at the moment is to generate your own labels for the API

TABLE FILE EMPDATA
SUM
COMPUTE COUNTER/I2=LAST COUNTER +1; NOPRINT
-* you must subtract 1 from the counter as java counts from 0
COMPUTE GPOS/I2= COUNTER -1; NOPRINT
COMPUTE LABELTEXT/A80='setGroupLabel('||EDIT(GPOS)||',"'||JOBCLASS||'");';
BY EMPDATA.EMPDATA.DIV NOPRINT
BY EMPDATA.EMPDATA.JOBCLASS NOPRINT
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE AS DATALABEL
END
-RUN
GRAPH FILE EMPDATA
SUM
SALARY
BY EMPDATA.EMPDATA.DIV NOPRINT AS ''
BY EMPDATA.EMPDATA.JOBCLASS AS 'Job class'
ON GRAPH SET LOOKGRAPH VBAR2AX
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET GRMERGE ON
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 490
ON GRAPH SET HAXIS 850
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
-INCLUDE DATALABEL
ENDSTYLE
ON TABLE SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.00000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='SansSerif',
SIZE=10,
BACKCOLOR=RGB(255 255 255),
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N3,
TARGET=_self,
FOCEXEC=app_drill1.fex(JOBCLASS= JOBCLASS DIV= DIV),$
ENDSTYLE
END
 
Reply With QuoteReport This Post
Member
posted Hide Post
Thanks JG, GeraldCohen, FrankDutch, Doug For your reply.As per my requirement, i got exact solution from JG Code.Thanks once again to all.


WF: WebFOCUS 7.6.4/7.6.8/7.6.10/7702/7703
Windows: XP/NT,
Output formats: HTML,PDF,EXCEL,ACTIVE HTML
 
Posts: 13 | Registered: June 30, 2008Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Prakash,

If your problem is indeed solved, please edit your topic to show it has been solved by putting in the keyword [SOLVED].

Thanks,


GamP

- Using AS 8.2.01 on Windows 7 - IE11.
in Focus since 1988
 
Posts: 1960 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteReport This Post
<Pugalendhi Rajagopalan>
posted
Hi

I am able to see the post

Thanks
Pugalendhi.R
 
Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]NOPRINT command IN Graph

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.