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    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