Is there any way to display the REGION values, but hide DOLLARS? Basically, all I want is REGION values and no other data. I'm using WF8.

SET ACRSVRBTITL=OFF
TABLE FILE GGSALES
SUM DOLLARS AS Sales
ACROSS REGION AS ''
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END
  

This message has been edited. Last edited by: FP Mod Chuck,

Is this something like you are looking for?

SET ACRSVRBTITL=OFF
DEFINE FILE GGSALES
Dlrs/A1 = '';
END
TABLE FILE GGSALES
SUM Dlrs AS Sales
ACROSS REGION AS ''
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END

Very simple solution that I'll complicate a little.

Eventually my goal is to print something out similar to below, but the problem the suggested solution creates is the empty line of Row 2.

 
SET ACRSVRBTITL=OFF
DEFINE FILE GGSALES
Dlrs/A1 = '';
END
TABLE FILE GGSALES
SUM Dlrs AS Sales
ACROSS REGION AS ''
ON TABLE PCHOLD FORMAT EXL07 OPEN NOBREAK 
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END

TABLE FILE CAR
PRINT 
COUNTRY	AS ''
CAR	AS ''
MODEL	AS ''
BODYTYPE AS ''
ON TABLE PCHOLD FORMAT EXL07 CLOSE NOBREAK 
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END
 

This should remove the Empty Row and give you what I think you are looking for.

 SET ACRSVRBTITL=OFF
SET EMPTYREPORT=ON
DEFINE FILE GGSALES
Dlrs/A1 = '';
END
TABLE FILE GGSALES
SUM Dlrs AS ''
ACROSS REGION AS ''
WHERE TOTAL Dlrs NE ''
ON TABLE PCHOLD FORMAT EXL07 OPEN NOBREAK 
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END

TABLE FILE CAR
PRINT 
COUNTRY	AS ''
CAR	AS ''
MODEL	AS ''
BODYTYPE AS ''
ON TABLE PCHOLD FORMAT EXL07 CLOSE NOBREAK 
ON TABLE SET PAGE NOPAGE
ON TABLE SET STYLE *
GRID=OFF,$
ENDSTYLE
END