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
Go
Search
Tools
 Login/Join 

Discussion Topic  RE: [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
First you need to know how the data is stored on the DB. Is it null, 0, '' or ' ' to avoud using TOT......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by FP Mod Chuck
Maybe this is one of those queries you either need run deferred or schedule on whatever basis is req......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by Maran
Chuck, It's processing around 150K records. If we use TOTAL in WHERE clause, it processing entire ba......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by FP Mod Chuck
Maran How many records is it processing?...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by Maran
Chuck, If I use TOTAL in WHERE, I'm getting the report correctly. But it takes long time to run. Th......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by FP Mod Chuck
Maran Your WHERE statement has a blank space between the tick marks. Try this WHERE TOTAL Column_......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by Maran
Hi Frans, thanks for your reply. I already tried your code but it's not working as expected....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
WHERE COLUMN EQ MISSING...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Empty value in WHERE caluse (in WebFOCUS/FOCUS Forum on Focal Point ) by Maran
Hi, I have a report which has a drill-down report. Some times we'll get an empty value in drill col......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Empty Tab - No Data (in WebFOCUS/FOCUS Forum on Focal Point ) by dbeagan
You could do something like this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Empty Tab - No Data (in WebFOCUS/FOCUS Forum on Focal Point ) by Tracie Jones
Thanks Martin! Yes Tony, it has quotes around it....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Empty Tab - No Data (in WebFOCUS/FOCUS Forum on Focal Point ) by Tony A
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Empty Tab - No Data (in WebFOCUS/FOCUS Forum on Focal Point ) by MartinY
SET EMPTYREPORT = ON works for the entire missing report, not for part of it. Here is an option whe......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Empty Tab - No Data (in WebFOCUS/FOCUS Forum on Focal Point ) by Tracie Jones
My BY and where statement: BY BDCA_CODE WHERE BDCA_CODE IN (&BDCA1, &BDCA2, &BDCA3); I am doing an ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Empty Tab - No Data (in WebFOCUS/FOCUS Forum on Focal Point ) by Tracie Jones
This did not work either....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Empty Tab - No Data (in WebFOCUS/FOCUS Forum on Focal Point ) by FP Mod Chuck
Tracie Try EMPTYREPORT = ON...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Empty Tab - No Data (in WebFOCUS/FOCUS Forum on Focal Point ) by Tracie Jones
I am trying to get an empty tab to show when no data exists for the value in my BY statement. I trie......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Get Parameter values into URL in WebFOCUS Designer Javascript (in WebFOCUS/FOCUS Forum on Focal Point ) by Radhika005
Looks like John Lewis had already worked on this. I also opened a case to see if IBI has a simpler s......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Refresh Designer Page onclick (in WebFOCUS/FOCUS Forum on Focal Point ) by Radhika005
Hello All! I am using global parameters across few pages in my designer portal. Example: I have a ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Change colors in HTML5 chart extension (in WebFOCUS/FOCUS Forum on Focal Point ) by Tony A
For these extensions, always refer to the github site for information ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] Change colors in HTML5 chart extension (in WebFOCUS/FOCUS Forum on Focal Point ) by getit
Is there a way to change the Red and green colors on this chart. It is a chart extention. ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]how to set specific value range in treemap's color scale? (in WebFOCUS/FOCUS Forum on Focal Point ) by nox
Thanks for the sample code, not exactly what I want but close, I think I can play around to get what......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]how to set specific value range in treemap's color scale? (in WebFOCUS/FOCUS Forum on Focal Point ) by dbeagan
Looking through ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED]how to set specific value range in treemap's color scale? (in WebFOCUS/FOCUS Forum on Focal Point ) by nox
I have following treemap for car: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Copying Change Management Packages Between Environments (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Hi, Basically you need to setup a Export scenario. Then you can use a WebFOCUS restservice to start......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] BYDISPLAY not working correctly (in WebFOCUS/FOCUS Forum on Focal Point ) by DWaybright
Apparently the BYDISPLAY doesn't work with BY TOTAL in the version we are on. It was corrected in 8.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] BYDISPLAY not working correctly (in WebFOCUS/FOCUS Forum on Focal Point ) by DWaybright
I should probably also note that I don't think the compute field has anything to do with it. I notic......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] BYDISPLAY not working correctly (in WebFOCUS/FOCUS Forum on Focal Point ) by DWaybright
Here you go. I appreciate your taking a look! ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] BYDISPLAY not working correctly (in WebFOCUS/FOCUS Forum on Focal Point ) by MartinY
Please, at least share your code...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [SOLVED] BYDISPLAY not working correctly (in WebFOCUS/FOCUS Forum on Focal Point ) by DWaybright
Has anyone run into a case where SET BYDISPLAY ON is not working correctly? The report is actually c......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Single Column Multiple Lines Multiple Fonts (in WebFOCUS/FOCUS Forum on Focal Point ) by WebFOCUS_Dev
Thanks danny.......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Single Column Multiple Lines Multiple Fonts (in WebFOCUS/FOCUS Forum on Focal Point ) by Danny-SRL
Could this do it for you? ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Single Column Multiple Lines Multiple Fonts (in WebFOCUS/FOCUS Forum on Focal Point ) by WebFOCUS_Dev
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Single Column Multiple Lines Multiple Fonts (in WebFOCUS/FOCUS Forum on Focal Point ) by Waz
Oh, I wish FOLD-LINE still worked...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Burst a compound EXCEL with Caster (in WebFOCUS/FOCUS Forum on Focal Point ) by Patlechat
Hello folks, I'm in 8204 and I'd like to burst ( based on an access List ) to Report Library an XLS......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Possible to set ReportCaster's agent to custom agent? (in WebFOCUS/FOCUS Forum on Focal Point ) by nox
sound cool, I'll give it a shot, Thanks!...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Possible to set ReportCaster's agent to custom agent? (in WebFOCUS/FOCUS Forum on Focal Point ) by FP Mod Chuck
Nox I found the answer, In the Client adminstration console under Reporting Servers right mouse cli......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Possible to set ReportCaster's agent to custom agent? (in WebFOCUS/FOCUS Forum on Focal Point ) by FP Mod Chuck
Nox That sounds correct. I went back and tested mine and found that in the ReportCaster config bot......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Possible to set ReportCaster's agent to custom agent? (in WebFOCUS/FOCUS Forum on Focal Point ) by nox
Hi, Here are the steps that I have test so far: 1. At Administrator Console in WebFOCUS Server >C......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Image in DEFINE/COMPUTE field (in WebFOCUS/FOCUS Forum on Focal Point ) by dbeagan
Hallway has posted some examples here: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Image in DEFINE/COMPUTE field (in WebFOCUS/FOCUS Forum on Focal Point ) by Waz
You can't reference the IBFS path from a web perspective. It needs to be a URL. I would suggest runn......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Image in DEFINE/COMPUTE field (in WebFOCUS/FOCUS Forum on Focal Point ) by WebFOCUS_Dev
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] ReportCaster IBFS cache cleaner error logged. (in WebFOCUS/FOCUS Forum on Focal Point ) by jnc
Hello Chuck, We are on 8203M I get the ready message, but I also get the failed message. [2020-09......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] WebFOCUS REST Adapter: Reporting against paginated results (in WebFOCUS/FOCUS Forum on Focal Point ) by Efrem
Automatic Pagination is currently not available with the REST Adapter. It is something that's on the......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] HTML Report - Hover on field (in WebFOCUS/FOCUS Forum on Focal Point ) by WebFOCUS_Dev
Hello Below is my sample with a CAR file. I know there is POPUPDESC but is there a way to display o......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  [CLOSED] Gap between bar and data text in graph (in WebFOCUS/FOCUS Forum on Focal Point ) by WebFOCUS_Dev
Hello all Below is my graph code with CAR file. I would like to know if there is any possibility to......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Embedded Report and Chrome issue (in WebFOCUS/FOCUS Forum on Focal Point ) by David Glick
It is not an unnecessary message. Chrome shows this due to selenium and it cannot be suppressed. T......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] show growth comparison on a bar chart (in WebFOCUS/FOCUS Forum on Focal Point ) by BI Dev
Hi Chuck, Yes, I could not do that out of the box so far, checking to see if somebody else has done......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] PDF Title styling issue on next page (in WebFOCUS/FOCUS Forum on Focal Point ) by MartinY
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] How to change NLS configuration file (in WebFOCUS/FOCUS Forum on Focal Point ) by JJ
[SOLVED] We used TSGU KTBL GEN PD* command to resolve this issue. Thank you all....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata  ‹ Previous  |  Next ›  

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders