Focal Point
[SOLVED] Over Command

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/337102213

December 08, 2009, 12:27 PM
.eric
[SOLVED] Over Command
I'm not sure if the over command is what I should be using but here is what I'm trying to do.

If you take the car file:
TABLE FILE CAR
PRINT CAR AS '' OVER MODEL AS ''
END

You get:
JAGUAR
V12XKE AUTO
JAGUAR
XJ12L AUTO

What I'm trying to get is:
JAGUAR
V12XKE AUTO
XJ12L AUTO

Where JAGUAR (car) isn't repeated over ever model. Is this possible?

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


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat
December 08, 2009, 12:58 PM
Francis Mariani
Something like this, perhaps:

TABLE FILE CAR
SUM
MODEL AS ''
BY CAR NOPRINT
BY MODEL NOPRINT
ON CAR SUBHEAD
"<CAR"
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 08, 2009, 02:37 PM
.eric
Not sure why I couldn't think of that. I think I can make this work now, thanks for the help.


dev: WF 7.6.5 w/IIS + Tomcat

prod: WF 7.6.5 w/IIS + Tomcat