Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums    Search    Search Results
Page 1 2 3 4 ... 12
Go
New
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-2018 Information Builders, leaders in enterprise business intelligence.