Focal Point
Change Postion of field

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

December 15, 2006, 11:06 AM
Prarie
Change Postion of field
This works for a Subfoot
TYPE=SUBFOOT, LINE=1, OBJECT=FIELD, ITEM=9, POSITION=DUEDATE,COLOR=PINK,WHEN=REDATE EQ 'N/A',$

I need to move the position of a field in the report and the above does not seem to work with a Report Field. How do you move a field with a when...within the report statment.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 15, 2006, 11:21 AM
Francis Mariani
How can you expect to change the position of a report column based on the value of a row element?

Each row could have a different value for that column.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
December 15, 2006, 11:50 AM
Prarie
Ok...


What I have is a HYYMDIA date. The user(who has it this way in a crystal report), wants it to read 'N/A' When there is no date. No setting NODATA='N/A' Does not work. I do not know how to make the HYYMDIA into an Alpha field so I can make into a define to screen for
no date. Anyone?


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 15, 2006, 12:15 PM
Tony A
Hi Prarie,

SET NODATA doesn't work for you? How is your data coming over, does it contain nulls?

The following snippet works OK, perhaps the datetime field isnot really an HYYMDIA?

SET NODATA = 'N/A'
TABLE FILE CAR
  PRINT SEATS
        COMPUTE ANYTIME/HYYMDIA MISSING ON = IF COUNTRY EQ 'ENGLAND' THEN DT(20000101 09:00AM) ELSE MISSING;
     BY COUNTRY
     BY CAR
END
-RUN


T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
December 15, 2006, 01:40 PM
Prarie
Thanks Tony..I'll try that,
but in the mean time my co-worker Jerry...came up with the following
Close_Date_Time/HYYMDIA = CLOSE_DATE___TIME;
CDT0/A20=HCNVRT(Close_Date_Time, '(HYYMDIA)', 20, 'A20');
CDT1/A10=EDIT(CDT0,'9999999999');
CDT2/A8=EDIT(CDT0,'$$$$$$$$$$$99999999');
NEWALPHA2/A20=IF CDT0 EQ ' ' THEN 'N/A' ELSE CDT0;


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
December 18, 2006, 10:16 AM
codermonkey
Did the new define get your style sheet command working properly?

Using POSITION=fieldname works for use when positioning elements in a TABFOOTING or HEADING... We have reports using when OBJECT=TEXT and when OBJECT=FIELD...
December 18, 2006, 10:59 AM
Prarie
No - The define took away the need to do it in the Style sheet. Yes moving the position with your method works in Tabs, Footings,SubHeads,SubFoots. I was trying to move something within the report.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003