Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

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


Ricardo Lara

Recommended Posts

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
  • Create New...