Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
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
Go
New
Search
Notify
Tools
Reply
  
Can Formating be done in MAS files rather than using a DEFINE
 Login/Join
 
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, 2007Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
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, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.