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  iWay Software Product Forum on Focal Point    Can Formating be done in MAS files rather than using a DEFINE

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Can Formating be done in MAS files rather than using a DEFINE
 Login/Join
 
johney
Gold member
posted
Hi All,

Is there any way to fix the dollar($) format for numeric column in MAS itself because I dont want to create a DEFINE field since I am using report assistant for my reporting.

If it can be done , pleae suggest me to the same thing for date formats also. I would like to see my date fields as mm/dd/yyyy with out any time in it.

Thanks and regards,
Johney Joseph


Version 7.6.11
Webfocus installed in AIX 5.3,
desktop PC: Windows-XP based
Output: Excel, HTML, PDF
 
Posts: 83 | Registered: October 19, 2007Report This Post
gogoly
Member
posted Hide Post
Yes. In fact I did it just last night to QA one of our new product features called Flex Enable.
As an example, look at the ggsales.mas in ibisamp - this sample is shipped with webFocus.
I canged the format of the DOLLARS field in the mas fir from I8 to I8CM & the formatting now carried forward.

Here's the ne code in the master field...

FIELDNAME=DOLLARS, ALIAS=E11, USAGE=I8CM,
TITLE='Dollar Sales', DESCRIPTION='Total dollar amount of reported sales', $
 
Posts: 1 | Registered: November 08, 2007Report This Post
Baillecl
Platinum Member
posted Hide Post
Define in a Master was supported in the old Days.
An important point is to know that, since Focus, at the Master level, cannot know which path is used, you must not refer to any fields out of the Segment scope.
So Define(s) comes after the last field of the Segement as
DEFINE NEW_FIELD/DMYY = OLD_FIELD ;$ Don't forget ";$" or this Tricky Focus will do as if he didn't understand what you meant.
All the Power of the Define Definition there. But the Defines file is not Qualified (or was not in the old Days), which did not appear correct to me (Regards to the Obligation to stick to the Segment Scope)
Beware of what the Accessing Motor to Data understands. The great Power that Focus puts in 'VIRTUAL' FIELDS is not always understood by lhe low-level Accessing Motors and you can turn into poor efficiency because of Using Defined Fields.
Sorry for being too precise and too verbose, but I'm trying to prove me that I still can play in the informatics game, amidst so many lying gurus... (Out of this Forum, I mean ...)
Cordialement and Focusly


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
 
Posts: 134 | Registered: November 06, 2007Report This Post
Baillecl
Platinum Member
posted Hide Post
quote:
Defines file

Please Read Defines Fields, of course
Sorry for the mistake
Useless Comments :
Think we should turn back to Cicero's Latin as "Universal langage".
It would prevent me from such mistakes, and put you in a frightful mess to communicate.
A little more equity (Egalité en Français) would, thus, be welcomed


Focus Mainframe 7.6.11
Dev Studio 7.6.11 and !!!
PC Focus, Focus for OS/2, FFW Six, MSO
 
Posts: 134 | Registered: November 06, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    Can Formating be done in MAS files rather than using a DEFINE

Copyright © 1996-2020 Information Builders