Focal Point
defined field in ReportingObj, how to add DESC=

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2281007902

January 26, 2007, 03:25 PM
susannah
defined field in ReportingObj, how to add DESC=
when you define a field in a master file description, how do you add the DESCRIPTION or the TITLE attributes? or can you?
i tried just slapping it on at the end of the function after the ; but no cigar




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
January 26, 2007, 03:51 PM
mgrackin
susannah,

Make sure you have a comma after the ;

DEFINE PRIORITY2/A5 = EDIT(PRIORITY, 'Sev $$$$$$$$$9');, TITLE = 'Priority',$


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
January 26, 2007, 05:39 PM
FrankDutch
Mickey

Is this also possible as

DEFINE FILE CAR
PRIORITY/A5 =....
END

Frank




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

January 26, 2007, 09:05 PM
susannah
yep i did that, but no cigar, Mick. i still get 'SEG03' in the description area in ReportAssist.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
January 29, 2007, 08:15 AM
mgrackin
Frank,

DESCRIPTION and TITLE are keywords for the Master File Description only. You cannot use these in a normal DEFINE section of code in a FEX. The AS phrase in a FEX will do the same thing as the TITLE attribute in an MFD.

Susannah,

Try doing a CHECK FILE on your MFD to see if it will catch any syntax errors you may not see.

Another thought would be to check the length limit for a DESCRIPTION attribute in an MFD for your platform. FOCUS on VM/CMS limits the DESC attribute to 40 characters.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
January 29, 2007, 10:17 AM
ira
If really desperate and you need to see it in report - use the good ol' 'as' phrase. Ira


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
January 29, 2007, 11:04 AM
FrankDutch
thanks Ira.....thats what I always do, but sometimes you want some other ways to do..




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

January 30, 2007, 09:00 AM
mgrackin
Susannah,

Is this issue resolved for you?


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
April 06, 2008, 02:27 PM
<DougLee>
Thanks All,

I just came across the need for this (TITLE in MFD DEFINE) and found it here in the WF Forum, as expected.

-Douglas Lee
April 07, 2008, 11:33 AM
Darin Lee
This is in our current MFD sets and working fine - no comma after the ;

DEFINE POL_REN/A3=EDIT(POL_NBR_REN ,'$$$$$$$999');
TITLE='Renewal,Number',$


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat