Now the request is changed and they want the italian cars shown like this. I feel as if I am mixing apples and oranges - how do I get the total correct without the italian cars counted twice
5 AUDI 0 0 0 0 5,970 BMW 0 0 0 0 52,407 JAGUAR 0 0 0 0 13,491 PEUGEOT 0 0 0 5,610 8,878 38,320 5,100 6,820 114,086This message has been edited. Last edited by: jammer,
Webfocus 7.6.4 Windows 2003 Server, SQL Server 2005 Excel, HTML , JavaScript ,and PDF. Reportcaster, BID, Tomcat
March 07, 2012, 09:42 AM
Aneela
Try using a subfoot.
TABLE FILE CAR
SUM RETAIL_COST
BY SEAT
BY COUNTRY
BY CAR
ACROSS BODYTYPE
ON COUNTRY SUBFOOT
"BLAH BLAH BLAH"
ON TABLE COLUMN-TOTAL AS 'TOTAL'
END
WebFocus 7.1.3 Developer studio 7.6.4 Windows Excel, HTML and PDF
March 07, 2012, 10:18 AM
jammer
Aneela,
Thanks - but
Can I make the subfoot show only when country is italy?
Webfocus 7.6.4 Windows 2003 Server, SQL Server 2005 Excel, HTML , JavaScript ,and PDF. Reportcaster, BID, Tomcat
March 07, 2012, 12:38 PM
Crymsyn
Yea just have the subfoot look like this
ON COUNTRY SUBFOOT
"BLAH BLAH BLAH"
WHEN COUNTRY EQ 'ITALY';
WF: 8201, OS: Windows, Output: HTML, PDF, Excel
March 07, 2012, 01:26 PM
jammer
Thanks all - solved!
the "WHEN" does it
(The WHEN can even done the graphical report builder - I could not find it - I was expecting it within the subfoot options but is it there when you right click the subfooting)
Webfocus 7.6.4 Windows 2003 Server, SQL Server 2005 Excel, HTML , JavaScript ,and PDF. Reportcaster, BID, Tomcat