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, December 08, 2009, 12:58 PM
Francis MarianiSomething 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
.ericNot sure why I couldn't think of that. I think I can make this work now, thanks for the help.