Focal Point Banner


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.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (CLOSED)Making Recompute the same width as data

Read-Only Read-Only Topic
Go
Search
Notify
Tools
(CLOSED)Making Recompute the same width as data
 Login/Join
 
Geoff Fish
Platinum Member
posted
I have an issue that i hvae not been able to find a solution to see abbreviated code below.
The output displays the RECOMPUTE field more narrowly than the data fields. The numbers line up but the background doesn't.

Is there a way that I can control this? Either with the style sheet formatting or a set command. I have searched the forum but have not found any threads regarding this. Perhaps I am not searching for the appropriate string. Thanks

SET SQUEEZE = ON
SET PRINTPLUS = ON
DEFINE FILE HOLD_ATT3
SET_AOK/I2=IF HOLD_ATT3.HOLD_ATT.CNT_AOK EQ 0 THEN 0 ELSE IF HOLD_ATT3.HOLD_ATT.CNT_AOK GT 0 THEN 1;
END
TABLE FILE HOLD_ATT3

PRINT
HOLD_ATT3.HOLD_ATT.STVATTR_DESC AS 'AOK'
HOLD_ATT3.HOLD_ATT.SHRTRCE_SUBJ_CODE AS 'SUBJ'
HOLD_ATT3.HOLD_ATT.SHRTRCE_CRSE_NUMB AS 'NUM'
HOLD_ATT3.HOLD_ATT.SHRTRCE_CRSE_TITLE AS 'TITLE'
HOLD_ATT3.HOLD_ATT.SHRTRCE_CREDIT_HOURS AS 'HOURS'
-* HERE IS THE MESSAGE
COMPUTE MSG/A100 = IF HOLD_ATT3.HOLD_ATT.ID EQ LAST HOLD_ATT3.HOLD_ATT.ID AND HOLD_ATT3.HOLD_ATT.SHRTRCE_CREDIT_HOURS GE 30 THEN 'YES this student has 30 or more transfer hours and does not need to take a Liberal Learning Seminar'
ELSE 'NO this student has less than 30 transfer hours and will need to take a Liberal Learning Seminar'; NOPRINT
BY LOWEST HOLD_ATT3.HOLD_ATT.ID NOPRINT
BY HOLD_ATT3.HOLD_ATT.SET_AOK NOPRINT

ON HOLD_ATT3.HOLD_ATT.ID PAGE-BREAK

ON HOLD_ATT3.HOLD_ATT.SET_AOK RECOMPUTE AS '*TOTAL'

ON HOLD_ATT3.HOLD_ATT.ID RECOMPUTE AS 'TOTAL-ALL'
HEADING
"Student name: "
"Classification:"Evaluator:<+0> <+0>Date:<+0> <+0>Fac. Advisor:<+0> "
"Courses Taken Satisfying Areas of Knowledge (AOK): Student has explored the following seven areas"
"of knowledge at least one time ( a 3 hour course or a combination of 2 and 1 hour courses) either in"
"courses they transferred or in courses they have taken at WSSU"
"If the AOK column is empty then the student SHATRNS record does not reflect any articulation with AOK"
FOOTING
""the first 30 hours of matriculation"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE COLUMN-TOTAL AS 'TOTAL'
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=HEADING,
BORDERALL=OFF,
$
TYPE=HEADING,
LINE=1,
JUSTIFY=LEFT,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
BORDER-TOP=LIGHT,
BORDER-BOTTOM=LIGHT,
BORDER-LEFT=LIGHT,
BORDER-RIGHT=LIGHT,
SIZE=10,
BACKCOLOR='SILVER',
WIDTH=1.250,
$
**********

TYPE=FOOTING,
LINE=1,
JUSTIFY=LEFT,
$
TYPE=FOOTING,
LINE=2,
JUSTIFY=LEFT,
$
TYPE=REPORT,
COLUMN=N5,
SQUEEZE=2.013889,
$
ENDSTYLE
END

This message has been edited. Last edited by: Geoff Fish,


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
eric.woerle
Master
posted Hide Post
It sounds like you are looking for something like headalign.

quote:
Syntax: How to Align a Heading or Footing Element in an HTML or PDF Report
TYPE = {REPORT|headfoot}, HEADALIGN = option, $
where:

REPORT
Applies the chosen alignment to all heading and footing elements in a report.
headfoot
Is the type of heading or footing. Valid values are TABHEADING, TABFOOTING, HEADING, FOOTING, SUBHEAD, and SUBFOOT.
option
Is the type of alignment. Valid values are:
NONE which places heading items in HTML reports in an embedded HTML table inside the main (body) table, and strings together, in a single cell of the embedded table, all the heading items (text and fields) on a line. In PDF reports, this uses the default alignment heading alignment. NONE is the default value.

INTERNAL which places heading items in an HTML table of its own, with each item in a separate cell. This allows the heading items to be aligned vertically with each other, independent of the data columns. The widths of the heading items do not affect the widths of the report columns and vice versa.

Note: HEADALIGN=INTERNAL is not supported in PDF reports.

BODY which aligns heading items with data columns. For HTML output, this places the items in the cells of the same HTML table as the body of the report. Since they have the same column widths, the items in the heading and the data in the body of the report line up naturally. For PDF output, this aligns the heading or footing elements with the data columns.

Note: HEADALIGN=BODY does not support paneling.

For related information, see Comparing Output Generated With HEADALIGN Options. You can combine HEADALIGN options with the COLSPAN attribute to allow heading items to span multiple HTML table columns. For details, see Aligning a Heading or Footing Element in an HTML, EXL07, EXL2K, or PDF Report.

For related information, see Comparing Output Generated With HEADALIGN Options. You can combine HEADALIGN options with the COLSPAN attribute to allow heading items to span multiple HTML table columns. For details, see Aligning a Heading or Footing Element in an HTML, EXL07, EXL2K, or PDF Report.



Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
Geoff Fish
Platinum Member
posted Hide Post
Eric thanks its definitely PDF so as you noted HEADALIGN=INTERNAL is out. What are you referring to when you say HEADALIGN =BODY does not support paneling?

I will keep researching but so far neither
TYPE=REPORT,
HEADALIGN=FOOTING,
$
or
TYPE=FOOTING,
HEADALIGN=REPORT,
$

has worked


809 DevStudio, MRE, Report Caster , Report Library
Output: Excel PDF, HTML
 
Posts: 171 | Registered: April 28, 2008Report This Post
eric.woerle
Master
posted Hide Post
Geoff,

It should be:

TYPE=REPORT,
HEADALIGN=BODY,
$


the Headalign options are one of the following: NONE, BODY, INTERNAL

Setting the REPORT to headalign, should bring everything into the same columns. You might need to use colspan to get things to cross columns properly, but this should help you keep things in alignment.

quote:
What are you referring to when you say HEADALIGN =BODY does not support paneling?


Paneling is when your report stretches wider then the width of the page. So say your PDF page is 8.5 x 11 and the report end up being 12 inches wide. The last inch (plus your margin) will be split onto a second page that would be numbered as 1.1 . Basically there is no overflow for width when using headalign = body. But since you are creating a letter/transcript, I don't think you want paneling anyways.


Eric Woerle
8.1.05M Gen 913- Reporting Server Unix
8.1.05 Client Unix
Oracle 11.2.0.2
 
Posts: 750 | Location: Warrenville, IL | Registered: January 08, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     (CLOSED)Making Recompute the same width as data

Copyright © 1996-2020 Information Builders