November 01, 2012, 06:18 PM
Dgraff[Case Opened 8310251] How do I supress a blank Across column in Active report format
SET HIDENULLACRS=ON
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS SEATS AS ' ' COLUMNS '5' AND '2' AND '3'
ON TABLE PCHOLD FORMAT HTML
END
This is how I want the Active report below to look
SET HIDENULLACRS=ON
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS SEATS AS ' ' COLUMNS '5' AND '2' AND '3'
ON TABLE PCHOLD FORMAT AHTML
END
(there are no data items with 3 seats. and yes, the summing is meaningless
Any help always accepted. In the actual data I have six columns. And may have data in any or all of them.
Thank you
This message has been edited. Last edited by: Dgraff, November 02, 2012, 03:31 PM
Don GarlandWill this work?
TABLE FILE CAR
SUM DEALER_COST RETAIL_COST
BY CAR
ACROSS SEATS AS ' '
ON TABLE PCHOLD FORMAT AHTML
END
It could be that you want a certain sort in your across columns?
November 02, 2012, 04:13 PM
DgraffSorry Don the sort order is the reason for using the across columns
November 02, 2012, 04:30 PM
Francis MarianiI'd open a case as this looks like a bug. The HIDENULLACRS command works for HTML, PDF, EXL2K and APDF, but not for AHTML.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server