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 2 3 4 5 
Go
Search
Tools
Search Results: (93 matches) New Search Login/Join 

Discussion Topic  Inner Join with repeating values (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
I have a problem. I am joining two HOLD tables with a common customer ID. I'm using inner join bec......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Repeat Column Headings and SUM Total (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
I was able to get the column headings to repeat by changing my ON ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Repeat Column Headings and SUM Total (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
I have a two part request. 1) is there a way to have column headings repeat at a page? I have this ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Missing values in cross reference file (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
The fields in Table2 are missing only where there is not a match between the two tables on ID....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Missing values in cross reference file (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
I've searched for a possible solution, but cannot find. I am joining two tables on ID. It's an out......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Using -INCLUDE within IF ... THEN (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
Jack, I did get your advice to work!! I had a semicolon in my reference fex and then one at the end......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Using -INCLUDE within IF ... THEN (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
Thanks to all. To Jack Gross, I can't seem to get it to work by breaking the line so the dash is in ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Using -INCLUDE within IF ... THEN (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
Can anyone tell me if it's possible to use -INCLUDE within an IF ... THEN statement? For instance: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: SUM and Field using WHERE clause (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
Thank you to all. Using ...ELSE MISSING did the trick. Did not put the MISSIN=ON in the first part......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  SUM and Field using WHERE clause (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
I'm sure I've seen a way to do this, but I cannot remember. I would like to average a field only wh......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: -INCLUDE or MATCH or something (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
Thanks dhagen. I actually used the MATCH FILE in the example link you sent. Could not figure out t......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  -INCLUDE or MATCH or something (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
I am wondering if either MATCH or -INCLUDE will help me accomplish something a little tricky. I wou......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Hold files in WHERE STATEMENTS and FOC038 error (in WebFOCUS/FOCUS Forum on Focal Point ) by BobV
I have beeen using the following discussion thread to try and use the values in a HOLD file as crite......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2 3 4 5  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders