Probs with PRINTPLUS & Excel output

Hello to all.

When I have a WHERE TOTAL and I want to show the sort field value in my SUBTOTAL lines, I use SET PRINTPLUS = ON but it looks like it doesn't work with Excel output!!

SET PRINTPLUS = ON
TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
ON COUNTRY SUBTOTAL AS 'Stotal for '
WHERE TOTAL ( DEALER_COST LT 8000 );
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT 'EXL2K'
ON TABLE SET HTMLCSS ON
END

The sort field value shows up with HTML or PDF but not EXL2K.

What can I do????

We are using 5.2.5

Thanks

Posts: 87 | Location: Montreal, QC, Canada | Registered: September 03, 2004

FliPPeR

Gold member

posted

Hide Post

Well after thinking about it, I found an work-around... It really looks like it's a bug but you can simply put the result of the table file in a hold file and then do your table file on it without the WHERE TOTAL.

TABLE FILE CAR
SUM
DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
WHERE TOTAL ( DEALER_COST LT 8000 );
ON TABLE HOLD AS HCAR
END
TABLE FILE HCAR
SUM
DEALER_COST
RETAIL_COST
BY COUNTRY
BY CAR
BY MODEL
ON COUNTRY SUBTOTAL AS 'Stotal for '
ON TABLE SET PAGE-NUM OFF
ON TABLE COLUMN-TOTAL AS 'Total'
ON TABLE PCHOLD FORMAT 'EXL2K'
ON TABLE SET HTMLCSS ON
END

A little longer but reading from a hold file is quick.

Posts: 87 | Location: Montreal, QC, Canada | Registered: September 03, 2004

Please Wait. Your request is being processed...

Read-Only Topic

Focal Point

Focal Point Forums

WebFOCUS/FOCUS Forum on Focal Point

Probs with PRINTPLUS & Excel output

Focal Point | Privacy Statement | Terms of Service