As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you have any questions or need access: Contact firstname.lastname@example.org
I have a report that exports to excel with for example let's say 12 columns with titles. For the first 5 columns (with their titles), in excel I can merge and center a separate title above for them.
Having it look like this (somewhat): Merge-Centered Title Title1 Title2 Title3 Title4 Title 5 data data data data data data ...
Is this possible to do in WebFocus. I have the report and it's general titles, but can i take a group of titles/columns and give it a title. In excel, to do that we would highlight all columns we want and select the <-a-> looking thing in the toolbar.
Of course you can. You just need to use HEADALIGN=BODY and COLSPAN to get what you need.
NOTE: C+0 denotes a left caret because of restrictions.
Here's an example:
TABLE FILE tablename SUM COL1 AS '' COL2 AS '' BY SORT_COL AS ''
HEADING " C+0 CENTERED HEADING" "Col1 Title C+0 Col2 Title C+0 Col3 Title "
ON TABLE PCHOLD FORMAT EXL2K ON TABLE SET STYLE * TYPE=HEADING,HEADALIGN=BODY,$ TYPE=HEADING,OBJECT=TEXT, LINE=1,ITEM=1, COLSPAN=1, $ TYPE=HEADING,OBJECT=TEXT, LINE=1,ITEM=2, COLSPAN=2, JUSTIFY=CENTER,$ TYPE=HEADING,OBJECT=TEXT, LINE=2,ITEM=1, COLSPAN=1, JUSTIFY=CENTER,$ TYPE=HEADING,OBJECT=TEXT, LINE=2,ITEM=2, COLSPAN=1, JUSTIFY=CENTER,$ TYPE=HEADING,OBJECT=TEXT, LINE=2,ITEM=3, COLSPAN=1, JUSTIFY=CENTER,$ ENDSTYLE END
Depending on how your report is structured, you may be able to interchange the heading with subheadings. Also be on the watch for the spaces within the heading and subheadings. These are included as ITEMs.
This should do the trick for you (or some variation).
yeah, you use a HEADING with ALIGN=BODY and then your HEADING instead of being 1 wide cell, is a bunch of little cells, like your table body. So your style sheet references HEADING,LINE=3, ITEM=1,COLSPAN=2,COLOR=etc Just make sure you COLSPANs all add up to however many fields you actually have in your table. Takes a bit of experimenting. I've used LINE=3 here, thinking you might have 2 lines of ordinary heading, the 3rd being your last, and the one you want to spread out as column group titles. You ok with this? good weekend to you.
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003