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     align decimal columns

Read-Only Read-Only Topic
Go
Search
Notify
Tools
align decimal columns
 Login/Join
 
Kamesh
Master
posted
Problem with aligning decimal columns.

For example:
Amt/P17.2CM=Amount;


when you try display this field, it's not getting aligned properly.

Record1
Name : XXXXXX
Salary : $5000

Record2
Name : XXXXXX
Salary : $100000

Record3
Name : XXXXXX
Salary : $1

The report should be look like

Name : XXXXXX
Salary : $5000

Name : XXXXX
Salary : $100000

Name : XXXXX
Salary : $1

tried align by LEFT justify but this field is occupying 20 columns and it's going extreme end.
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Kamesh
Master
posted Hide Post
the example I gave in my previous post, the spaces it didn't show

not aligned report sample for the previous example
Name : XXXX
Salary :----$1000

gave '-' instead of spaces
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
Try this:

TABLE FILE CAR
SUM
COMPUTE RECORD/P4 = RECORD + 1; NOPRINT
COMPUTE SALESX/P17.2CM = SALES; NOPRINT
BY CAR NOPRINT
BY MODEL NOPRINT
ON MODEL SUBHEAD
"RECORD: <RECORD"
"COUNTRY: <COUNTRY"
"SALES: <SALESX"
WHERE READLIMIT EQ 100
WHERE RECORDLIMIT EQ 100
HEADING
" "
ON TABLE SET PAGE NOLEAD
ON TABLE SET STYLESHEET *
TYPE=REPORT, GRID=ON,
FONT='VERDANA', SIZE=8, $
TYPE=SUBHEAD, HEADALIGN=BODY, $
TYPE=SUBHEAD, LINE=3, ITEM=2, COLOR=RED, JUSTIFY=RIGHT, $
ENDSTYLE
END
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
reFOCUSing
Guru
posted Hide Post
Try this:

DEFINE FILE SHORT
BALANCE/D14.2=BALANCE;
END
TABLE FILE SHORT
BY COUNTRY NOPRINT SUBHEAD
"Country:"Type:"Holder:ON TABLE SET PAGE-NUM OFF
ON TABLE SET ONLINE-FMT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLESHEET *
TYPE=REPORT, FONT='TIMES', $
TYPE=REPORT, GRID=OFF, $
TYPE=SUBHEAD, ITEM=1, WIDTH=1.00, JUSTIFY=RIGHT, $
TYPE=SUBHEAD, ITEM=2, WIDTH=1.25, JUSTIFY=RIGHT, $
TYPE=SUBHEAD, ITEM=3, WIDTH=1.25, JUSTIFY=RIGHT,$
TYPE=SUBHEAD, ITEM=4, WIDTH=1.5, JUSTIFY=DECIMAL(.6),$
ENDSTYLE
END[/code]The 'JUSTIFY=DECIMAL(.6),' in the style sheet is what does the trick.

If you want more information on this check out the following doc on the tech support site:
'Aligning Content in a Multi-Line Heading or Footing'

This message has been edited. Last edited by: <Mabel>,
 
Posts: 406 | Location: Canada | Registered: May 31, 2004Report This Post
Kamesh
Master
posted Hide Post
tried JUSTIFY=DECIMAL(.6) but not working.

My code will look like,

TABLE FILE TEST
PRINT DESCRIPTION
BY ACCTID PAGE-BREAK
ON ACCTID SUBHEAD
"ACCOUNT NUMBER <9 <ACCTID "
"AMOUNT <9 <ST.AMOUNT "
END

The Amount field is messing up the alignment. tried,
TYPE=SUBHEAD,LINE=2,JUSTIFY=DECIMAL(.6),WIDTH=1.5,BY=ACCTID,$

but not working.
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report This Post
Francis Mariani
Expert
posted Hide Post
What's not working? What is it you want to do, exactly?

Do you want the AMOUNT field to left-align with the ACCTID field?

Do you want all the AMOUNT fields to be right-justified?

DO you want all the fields (AMOUNT and ACCTID) to be right-justified?

We could better serve you if you post a program that we can run on our machines.

Why not use the CAR file to post an example that we can build on?
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Kamesh
Master
posted Hide Post
Acctid and Amount has to be left justified.
 
Posts: 780 | Location: Florida | Registered: January 09, 2005Report 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     align decimal columns

Copyright © 1996-2020 Information Builders