Hi guys,

I have a simple question...

In formatting a HEADING in EXL2K, we can merge 2 data columns using COLSPAN.

I want to do the opposite. I want to split 1 data column to 2 columns in the Heading.

How do you accomplish this in 7.7.03?

Regards,
Anatess

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

You DEFINE or COMPUTE the two columns and include them in the HEADING.

I'm not sure what you mean, Francis. I want the 2 fields in 2 different columns in the HEADING to line up to one column of Data.

So, there are 2 possible ways - both of which I don't know how to accomplish:

1.) Headalign=body and then figure out a way to split one cell into 2 instead of merging 2 cells into 2.

2.) COLSPAN=2 on the Data Row - which is not an available functionality.

Ideas?

Anatess,

Originally, you stated "I want to split 1 data column to 2 columns in the Heading". That is usually satisfied by using DEFINE or COMPUTE to create the two individual columns.

It's the "I want the 2 fields in 2 different columns in the HEADING to line up to one column of Data" that's not possible in WebFOCUS, because, as you know, you cannot merge two data row cells. I would probably merge the two columns in the heading, separating them with a dash...

The problem is that the heading has to have those 2 fields in separate cells (used in functions) so the dash won't work.

And there are 4 columns in the Heading and only 2 on the data...

HI Anatess,

Would faking it work for you?

DEFINE FILE EMPDATA
  JOBCLASS_1/A3 = EDIT(JOBCLASS, '999$');
  JOBCLASS_2/A3 = EDIT(JOBCLASS, '$$$99$');
  JOBCLASS_3/A3 = EDIT(JOBCLASS, '$$$$$9$');
END

TABLE FILE EMPDATA
PRINT SALARY
      COMPUTE BLANK_COL/A1 = ''; AS ''
      HIREDATE
      COMPUTE BLANK_COL/A1 = ''; AS ''
BY TITLE NOPRINT PAGE-BREAK
HEADING
" <+0> <JOBCLASS<JOBCLASS_1<JOBCLASS_2<JOBCLASS_3"
BY LASTNAME
BY FIRSTNAME
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLE *
  TYPE=REPORT, HEADALIGN=BODY, $
ENDSTYLE
END

T

Tony, thanks. This is exactly how I have it now. Our business folks don't like it.

So, I created the report just like this and I'm going to create a template for it to run a macro that merges the data rows.