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

Discussion Topic  [SOLVED] DB2 SQL passthru error (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
The sql passthru below is giving me an error message if I replace &var1 with hard-coded 'FOC_NONE', ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] K in column Total (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
I did it the long way but now I have another problem How do I make the last row in the report to BOL......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] K in column Total (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Looks like the only way to go would be to use a filedef and hold the detail report in a file. Cacula......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] K in column Total (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Hi Darin, Thanks for the response. what i am looking for is the 'K' in the ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] K in column Total (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Hi JG, I would like to get the sales Total in this format '......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] K in column Total (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Hi, In the request below, i would like to get the sales total but would like to add a K so that the......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] checkbox in report to select a record(row) (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
update is a DB2 SQL statement. checkboxes are a requirement so that multiple rows can be selected f......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] checkbox in report to select a record(row) (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Hi Darin, Let's say this is my report TABLE FILE CAR PRINT COUNTRY CAR MODEL ON TABLE HOLD AS HOLD1......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] checkbox in report to select a record(row) (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
here's the code for checkbox that i have. ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] checkbox in report to select a record(row) (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Hi, In my report, I have a checkbox on each row so that when a checkbox is checked I need to retriev......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] OLAP report with IF statement problem. (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
SOLVED!!! for now I Guess. OLAP reports are tricky.Everyday I come in and work on the OLAP reports,......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] OLAP report with IF statement problem. (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
-TYPE &LINES gives out the number of lines. works fine. I need to report from a HOLD file. How to m......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] OLAP report with IF statement problem. (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
As I said before,if I replace the &LINES with a SET variable value, it works fine and can find my ho......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] OLAP report with IF statement problem. (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
I tested this code below, which doesn't work for me. -OLAP ON TABLE FILE CAR PRINT COUNTRY CAR MOD......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] OLAP report with IF statement problem. (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Yes,it's ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] OLAP report with IF statement problem. (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
The &LINES(&RECORDS) in the IF statement is causing the problem. Don't know why!...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] OLAP report with IF statement problem. (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Hi Ginny, I put a -RUN before the IF statement and every TABLE statement. When i try to sort, it is......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] OLAP report with IF statement problem. (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Hi, The code below is an OLAP report. Without the IF statement,the OLAP report works. Retain the IF ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] SQL passthru report painter (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Hi Darin, I took out the two -SET commands at the top . So, basically upon opening the HOLD file in ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] SQL passthru report painter (in WebFOCUS/FOCUS Forum on Focal Point ) by dev532
Here's an example using CAR master. Can someone verify if you can open report painter on the hold fi......
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