Good morning!

I have a report structured similarly to the following:

 
TABLE FILE CAR
	SUM
		COMPUTE PROFIT/D6 = RETAIL_COST - DEALER_COST;
		COMPUTE AREA/D6 = LENGTH * WIDTH;
	
	BY COUNTRY
	ACROSS SEATS NOPRINT SUMMARIZE
	ACROSS BODYTYPE

	ON TABLE PCHOLD FORMAT AHTML
END
 

When this is run in 8.1, you'll notice there's no "Total" heading over the last two columns. Does anyone have any ideas to get that populated with... anything?? A couple things to consider:
- SEATS is roughly being used as a sort in this example, and is necessary
- I opted to use SUMMARIZE as the real report is including a percentage calc that can't be summed in the total
- Reverting to a regular HTML report would require a pretty hefty rebuild, which is the worst-case scenario for now
- Company is upgrading to 8.2 in the very near future, and if this is a non-issue in the newer version I can leave it be until then

Thanks in advance!
Jay

This message has been edited. Last edited by: Jay Ervin,

I just ran this in 8206 and still have no TOTAL label over the last 2 columns either in AHTML or HTML. Are you saying this used to work differently in the past?

quote:

Originally posted by BabakNYC:
I just ran this in 8206 and still have no TOTAL label over the last 2 columns either in AHTML or HTML. Are you saying this used to work differently in the past?

Nope, I've never gotten this one to work, but I've only been able to test in 8.1. Thank you for confirming it's no good in 8.2 either!

The issue is not with the output format or any WF version.
It's regarding the fact that your ACROSS SEATS is a NOPRINT. Remove that and you will have the word "TOTAL" displayed above for the last two columns

The below may be an alternative where you create your own across total

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
    LENGTH
    WIDTH
BY COUNTRY
BY SEATS
BY BODYTYPE
ON TABLE HOLD AS TMP1
END
-RUN

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
    LENGTH
    WIDTH
BY COUNTRY
BY TOTAL COMPUTE SEATS /I3 = 99;
BY TOTAL COMPUTE BODYTYPE /A12 = 'Total';
ON TABLE HOLD AS TMP2
END
-RUN

TABLE FILE TMP1
SUM RETAIL_COST
    DEALER_COST
    LENGTH
    WIDTH
BY COUNTRY
BY SEATS
BY BODYTYPE
ON TABLE HOLD AS RPTDATA
MORE
FILE TMP2
END
-RUN

TABLE FILE RPTDATA
SUM COMPUTE PROFIT/D6 = RETAIL_COST - DEALER_COST;
    COMPUTE AREA/D6 = LENGTH * WIDTH;
BY COUNTRY
ACROSS SEATS NOPRINT
ACROSS BODYTYPE
ON TABLE PCHOLD FORMAT AHTML
END
-RUN

quote:

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
    LENGTH
    WIDTH
BY COUNTRY
BY SEATS
BY BODYTYPE
ON TABLE HOLD AS TMP1
END
-RUN

TABLE FILE CAR
SUM RETAIL_COST
    DEALER_COST
    LENGTH
    WIDTH
BY COUNTRY
BY TOTAL COMPUTE SEATS /I3 = 99;
BY TOTAL COMPUTE BODYTYPE /A12 = 'Total';
ON TABLE HOLD AS TMP2
END
-RUN

TABLE FILE TMP1
SUM RETAIL_COST
    DEALER_COST
    LENGTH
    WIDTH
BY COUNTRY
BY SEATS
BY BODYTYPE
ON TABLE HOLD AS RPTDATA
MORE
FILE TMP2
END
-RUN

TABLE FILE RPTDATA
SUM COMPUTE PROFIT/D6 = RETAIL_COST - DEALER_COST;
    COMPUTE AREA/D6 = LENGTH * WIDTH;
BY COUNTRY
ACROSS SEATS NOPRINT
ACROSS BODYTYPE
ON TABLE PCHOLD FORMAT AHTML
END
-RUN

That'll work! Thanks!