Hello, Im new to WebFocus and Im trying to add a header li...

[Guest]

You can use spot markers, <+0> to separate them. Also note the HEADALIGN=BODY and COLSPAN=2 in the style sheet section of the report code.

TABLE FILE ggsales

HEADING

" <+0> <+0> Units <+0> Dollars"

SUM UNITS

BUDUNITS

DOLLARS

BUDDOLLARS

BY REGION

BY ST

ON TABLE SET PAGE NOLEAD

ON TABLE SET STYLE *

TYPE=HEADING, HEADALIGN=BODY, $

TYPE=HEADING, ITEM=3, COLSPAN=2, $

TYPE=HEADING, ITEM=4, COLSPAN=2, $

END

 

 

image.png1597633 47.6 KB

[Ricardo Lara]

Thanks David, it did the trick !

Regards

[Ricardo Lara]

Hello, Im new to WebFocus and Im trying to add a header line above the column titles, which will group the columns (12) into 4 different categories (3 columns each). The output will be an Excel spreadsheet.

Category 1 | Category 2 |

Col1 | Col2 | Col3 | Col4 | Col5 | Col6|

They way Ive seen it done is creating virtual fields into the DEFINE FILE section (one for each category) and then use them in the SUBHEAD section ("<VField-name1<VField-name2"), but I wanted to ask if this is the optimal way to do it because I think it might be processing this virtual fields for every record retrieved, making the report to run slower than it should.

On the other hand, is it possible to use local variables inside the custom header for naming the Categories

Thanks in advance.

Ricardo