I’m looking for help on how to get a column name on an across report. I’ve not done very many of these and haven’t been able to figure it out or find any other posts that would solve what I am trying to do. I have a lot of different types of data coming in based on dates. I want to print a row of data for each metric. That row will contain the data for that metric along with many columns per date. For example, this is what I want:

The ACROSSTITLE parameter enables you to display both the ACROSS title and the ACROSS values on one line, you can issue the SET ACROSSTITLE = SIDE command. This command places ACROSS titles to the left of the ACROSS values. The titles are right justified in the space above the BY field titles. The heading line that is created by default to display the ACROSS title will not be generated.

As it will be right justified you need to add styling to make it left justified, something like:TYPE=ACROSSTITLE, JUSTIFY=LEFT, $

This will get you closer, but still not what you would like. OVER complicates report design. Since there is no BY statement, there's no place to put the ACROSS column title. In the example below, I create a dummy BY column so that the ACROSS column title is placed to the left of the ACROSS values, but the layout isn't pretty.

SET PAGE=NOLEAD
SET ACROSSTITLE=SIDE
DEFINE FILE GGSALES
DUMMY1/A1='';
END
TABLE FILE GGSALES
SUM
DOLLARS
OVER
UNITS
OVER
BUDDOLLARS
OVER
BUDUNITS
ACROSS PRODUCT
BY DUMMY1 AS ''
END

I had ran your example but didn't see that the across field and the first sum were the same pieces of data. I applied this same technique to my report and am getting exactly what I wanted. Thank you very much!