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. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums    Search    Search Results
Page 1 ... 6 7 8 9 10 11 12 
Go
Search
Tools
Search Results: (227 matches) New Search Login/Join 

Discussion Topic  RE: [SOLVED] How to have proper previous day when first day of month (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Here's another way: -SET &PRV_YYMD = DATECVT((DATEADD((DATECVT (&YYMD, 'I8YYMD', 'YYMD')),'D', -1))......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] How to have proper previous day when first day of month (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi, Take a look at the AYMD function ... run this: -* -SET &PDAY = DATEADD (&YYMD, 'DAY', -1); -......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Solved] Current User who is executing the Report (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Santhosh, Try this and see what you get for CNCT_UID: -* -SET &USERID = GETUSER('A8'); -SET ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] FOCUS vs ALPHA (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Alan, What is the MDI feature?...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: How to use variable as fieldname? or put current date on report [SOLVED] (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Josh, Does this help? -* -SET &WORKDATE = AYMD(&YYMD,0,'I8YYMD') ; -* DEFINE FILE CAR RUN_DATE1......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Dumping an empty report into Excel (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Michele, Put this line in your fex: ON TABLE SET EMPTYREPORT ON ~Jim...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] How to add 's or ' to the end of a variable (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi, How about this: -* -SET &FNAME = 'John'; -*-SET &FNAME = 'Lucas'; -* -SET &FN_LST = SUBSTR(&......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] How to get Current Month (This Year) vs Same Month previous year. (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi, Run this bit of code and see if this will help. -* -* SET CURRENT DATE -SET &CUR_YYMD = &YYMD......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Using Computes , Within and Where together (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Joey, What happens if you try something like this? How many records are there in your "HLD_CAR" ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Using Computes , Within and Where together (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Joey, How about this: TABLE FILE CAR SUM FST.MODEL WITHIN COUNTRY AS 'Most Expensive Model' ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Question on Line Spacing in a Heading (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Not sure why, but change this line: TYPE=HEADING,LINE=1,STYLE=BOLD+UNDERLINE,$ to this: TYPE=HEAD......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] ReportCaster gets Task error after running 5 minutes (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Does anyone know why Reportcaster gives the following error after 5 minutes: BTP1020 Ex......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: <SOLVED>Evaluating Fields for Special Characters (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Tracie, Here's an example using the CAR file. T1_TXT - Your original field T3_TXT - Your new fi......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] String replace and modify (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Here's another version of the example Waz started. This creates the where statements based on the in......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] DateTime field format manipulation needed *ddh* (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi, Here's an example using CAR. -* DEFINE FILE CAR CNT/I3 WITH COUNTRY = CNT + 1; A_DTS/A14 = DEC......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] How to run a report multiple times in a loop ? (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Shravan, Here's the CAR example again that creates a pdf report for each country in the CAR file. A......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] How to run a report multiple times in a loop ? (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hmmmmm ..... I get 5 reports when I run the code from above. One for each country. I just ran this ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] How to run a report multiple times in a loop ? (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Shravan, Here is an example of a loop process using the CAR file. -****************************......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Build a string from a field in multiple records (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Steve, Glad it worked. I save little examples like this so I can use them the next time I need ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Build a string from a field in multiple records (in WebFOCUS/FOCUS Forum on Focal Point ) by jfr99
Hi Steve, Here's an example using the CAR file. This creates a string (CAR_LIT) of all CARs per COU......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 6 7 8 9 10 11 12  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders