I have issue with report using ACROSS where the across title is not displayed if there is only one SUM field.

Per example, the following shows both title for the SUM fields:

TABLE FILE CAR
SUM
CAR.BODY.SEATS AS 'Tot Nb Seats'
CAR.BODY.RETAIL_COST AS 'Retail Cost'
BY LOWEST CAR.ORIGIN.COUNTRY
ACROSS LOWEST CAR.BODY.BODYTYPE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
ENDSTYLE
END

But this one doesn't display the title "Tot Nb Seats" when I want it:

TABLE FILE CAR
SUM
CAR.BODY.SEATS AS 'Tot Nb Seats'
BY LOWEST CAR.ORIGIN.COUNTRY
ACROSS LOWEST CAR.BODY.BODYTYPE
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
ENDSTYLE
END

Cannot find any SET that can make it displaying.

Any ideas ?

Thanks,

This message has been edited. Last edited by: MartinY,

  
TABLE FILE IBISAMP/CAR
SUM 
CAR.BODY.SEATS NOPRINT
CAR.BODY.SEATS AS 'Tot Nb Seats'

BY LOWEST CAR.ORIGIN.COUNTRY
ACROSS LOWEST CAR.BODY.BODYTYPE
ON TABLE SET PAGE-NUM NOLEAD 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
$
ENDSTYLE
END
-EXIT

Thanks Tom. I have not thought about it.

Regards,

Guess what...

...more people have this issue.

...we're not on WF8 yet, but this is what I found in the 'new features'.


Controlling Display of an ACROSS Title for a Single Field
By default, when there is only one field displayed for an ACROSS sort group, no column title
displays above that field. Using the SET ACRSVRBTITL command, you can control the display
of ACROSS column titles when there is one displayed field for an ACROSS group. The field
count that determines whether the ACROSS title displays is affected by certain components
in the report request, such as calculated fields or fields in headings.
The output is unaffected by SET commands that adjust underlines with titles, adjust the space
between columns, or eliminate unpopulated ACROSS columns on the page. The size of the
title and the number of lines it occupies also do not affect the output.
Syntax: How to Control Display of an ACROSS Title for a Single Field

SET ACRSVRBTITL = {OFF|ON|HIDEONE}

3. Reporting With WebFOCUSON TABLE SET ACRSVRBTITL {OFF|ON|HIDEONE}
where:

OFF
Suppresses the title when there is only one display field.

ON
Displays the title when there is only one display field.

HIDEONE
Suppresses the title when there is only one display field, but the request contains one or
more of the following components:
Fields in a heading or footing.
Fields whose display is suppressed with the NOPRINT phrase.
Reformatted fields (which are normally counted twice).
A COMPUTE command referencing multiple fields.


source:
http://documentation.informati...8004/80snf/80snf.pdf
Pages 153-154

Nice, but...

I tried in WF 8.003 and
ON didn't work
HIDEONE did

I guess it's 8.004