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 ... 12
Go
Search
Tools
Search Results: (226 matches) New Search Login/Join 

Discussion Topic  RE: [NFR] AHTML - How To Freeze Column Headings? (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
An easier way is to put the HFREEZE into the Style Sheet area.. TYPE=REPORT,HFREEZE=ON,$...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [NFR] AHTML - How To Freeze Column Headings? (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
Just add the following line to the FEX SET HFREEZE ON or maybe SET HFREEZE=ON...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Subtotal in an Across (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
TABLE FILE CENTURYSALES SUM RETURNS ACROSS QUARTER ACROSS MONTH SUB-TOTAL BY PLANTNAME END Y......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Conditional BY fields in a report (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
The easiest way to do this is in DevStudio. You first put any number of BY fields on the canvas, th......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] In Infoassist can you make column percents based on row total (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
Why can't you use the RPCT. prefix e.g. SUM SALES AND RPCT.SALES ACROSS PRODUCT ROW-TOTAL BY STATE...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: How long do Global Variables last? (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
You guys are almost correct. In Release 7.xx.xx the && variables are maintained in the Cookie. In Re......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Using HyperStage (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
Whether you use SQL passthru or the Focus language is immaterial to HyperStage, or actually any data......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Sorting on an across total.... (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
Cleaver solution. If you know the number of ACROSS columns here is another. SUM Net_MTCs AND COMPU......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Choosing Output Formats (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
I assume both Table1 and Table2 are not database files where you can just join them. But I assume t......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Calculation using Column Totals (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
But, I need the individual across values, e.g. C1, C2, etc not just the overall total....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  Calculation using Column Totals (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
I would like to use the column totals in an ACROSS report to compute a new value, and then to displa......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Adding a single column after all across columns (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
Its actually very easy. It depends on where you put the Compute. In this case put it after the ACR......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Solved]HIDE THE COLUMN IF C0LUMN TOTAL EQ 0 (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
On thinking about a way to do this.. it appears that the only way is via two passes of the data. The......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Solved]HIDE THE COLUMN IF C0LUMN TOTAL EQ 0 (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
One technique is use of the setting.. The option HIDENULLACRS which is meant to suppress ACROSS 0 c......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SHARING] Aggregate awareness in WF? (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
Aggregate awareness is built into WebFOCUS and is automatically used if present. The command is: SQL......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] row limit in infoassist for loading values from external file..? (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
I never heard of a Row Limit on a filter. You could have a Record limit on the entire report.e.g. W......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] row limit in infoassist for loading values from external file..? (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
The default limit is usually 500. But there is a button on the main InfoAssist panel that allows yo......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Converting alpha to numeric packed (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
You need to first convert the Alpha to Double with the ATODBL function, then directly change numeric......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Compliance based on a rolling week (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
Why can't you map the DATE field into a WEEK of Year field and sort by WEEK. e.g. WDATE/YYW = DATE;......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SHARING] WebFOCUS vs Qlikview (in WebFOCUS/FOCUS Forum on Focal Point ) by GCohen
Qlikview is more of a personal user product for a knowledable user, who understands the database. W......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 2 3 4 ... 12 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2020 Information Builders