[CLOSED] Captions over column titles

In an Excel (EXL2K) report, I need to insert a caption over a group of columns. I want the caption to abut the 3 column titles beneath it, and to have similar styling.

I added the caption to the page heading, and used STYLE to perch it above the column titles and override the font and background color attributes that otherwise apply to the Heading.

Problems:

1. I am unable to eliminate the blank row that TABLE inserts between the Heading rows and the column-title row.

2. I am unable to put borders on the caption cell. That's important, because there are two actually such captions (over adjacent sets of columns: 2-4, and 5-9), and without a border the two captions will visually merge.

Any ideas?

This message has been edited. Last edited by: <Kathryn Henning>,

- Jack Gross
WF through 8.1.05

Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005

Danny-SRL

Virtuoso

posted

Hide Post

Jack,
Can you give an example?

Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006

Ignored post by Danny-SRL posted

Show Post

j.gross

Virtuoso

posted

Hide Post

First image below gives an idea of what we need to produce (actual layout, but genericised titles and captions, and artificial data)

Second one shows the closest I was able to get to that. -- Note how

There is an unwanted blank row (6) separating the captions from the column-titles.
I was unable to get borders around the captions.
I had to insert a blank column (E) to prevent the two captions from merging.

This message has been edited. Last edited by: j.gross,

- Jack Gross
WF through 8.1.05

Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005

Ignored post by j.gross posted

Show Post

Vivian

Platinum Member

posted

Hide Post

Jack,

Something like this will get you closer to what you want to do. You can put the styling on the across values --- use universal concatenation to get your headings and then an across --

SET ASNAME=ON
SET PAGE=NOPAGE
DEFINE FILE CAR
H1/A20='TEST';
H2/A20='TEST2';
END
TABLE FILE CAR
PRINT H1 AS COL1
DCOST MODEL SEATS COUNTRY
ON TABLE HOLD AS XX
RUN
PRINT H2 AS COL1
DCOST MODEL COUNTRY SEATS
ON TABLE HOLD AS YY
END
TABLE FILE XX
PRINT *
ON TABLE HOLD AS ZZ
MORE
FILE YY
END
TABLE FILE ZZ
SUM DEALER_COST MODEL SEATS
BY COUNTRY
ACROSS COL1 AS ''
ON TABLE PCHOLD FORMAT EXL2K
END

I think of this as "soup starter" ---

hope it helps ---
Vivian

If you are at Summit, drop by and say hi.

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

Vivian Perlmutter
Aviter, Inc.

WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003

Ignored post by Vivian posted

Show Post

j.gross

Virtuoso

posted

Hide Post

I considered ACROSS; but the columns, and their titles, under the first caption differ from those under the second.

Is there no setting to suppress that blank line following the HEADING?

- Jack Gross
WF through 8.1.05

Posts: 1925 | Location: NYC | In FOCUS since 1983 | Registered: January 11, 2005

Ignored post by j.gross posted

Show Post

Vivian

Platinum Member

posted

Hide Post

In the WebFOCUS Keysheet there is this setting:

SET DROPBLNKLINE = OPTION

Options available are:

ALL
BODY
HEADING
OFF
ON

You can try those -

I still think your best option is the more and across and I am fairly certain that you can manipulate your columns to do what you want....Well, that is the theory!

Vivian

Vivian Perlmutter
Aviter, Inc.

WebFOCUS Keysheet Rel. 8.0.2
(Almost) 1001 Ways to Work with Dates thru Rel. 8.0.2
Focus since 1982
WebFOCUS since the beginning
Vivian@aviter.com

Posts: 191 | Location: Henderson, Nevada | Registered: April 29, 2003

Ignored post by Vivian posted

Show Post

j.gross

Virtuoso

posted

Hide Post

Vivian --

Thx -- Will try