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

Discussion Topic  RE: [SOLVED]Sort calculated count field in descending order and limit # of rows displayed (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]Move data up when there is null data using ACROSS (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Replace PRINT verb with SUM, or add SET ACROSSPRT = COMPRESS before the TABLE request....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: When a MODIFY fails a subsequent MODIFY doesn't update (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Maybe add a COMPUTE after the FIXFORM in each MODIFY? ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]How to search based on multiple sets of values in IN Parameter (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]How to search based on multiple sets of values in IN Parameter (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
If &CUST_ID contains 5 values and &CLNT_ID contains 8 values, how will you know which client IDs go ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Delete rows from a SQL Server table using WebFocus (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Unless you need a log of records deleted, I would use the SQL TRUNCATE command instead of DELETE bec......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Reportcaster ID variable (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
I suggest creating a focexec with just this one command: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] How to handle NULL values returned by db_lookup function (in iWay Software Product Forum on Focal Point) by Dan Satchell
If your Oracle targets don't allow nulls (and therefore MISSING isn't ON in the synonym), then the D......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [SOLVED] How to handle NULL values returned by db_lookup function (in iWay Software Product Forum on Focal Point) by Dan Satchell
From the Using Functions reference manual: If the lookup field has the MISSING=ON attribute in its ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [SOLVED] Convert rows to columns (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
This should be close to what you want, but sorts all of the "A" Types first. ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]SQL "NOT EXISTS" Equivalent in WebFOCUS (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try this (the SET ALL=PASS may have no effect): ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]SQL "NOT EXISTS" Equivalent in WebFOCUS (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
You could also accomplish this with direct pass-thru SQL: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [closed] Help with a dashboard-type report (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Regarding data retrieval, if appropriate I prefer to run a nightly job in ReportCaster to handle tha......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]Left Outer Join (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try this setting before your query: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Full Outer Join with no matching columns (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
Try this: Use DEFINE to add a one-character blank column to each dataset. Then Join on the two blan......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED]How to divide rows by date sequence in webfocus (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
This assumes that the SEQUENCE values are always sorted in descending order (as in your sample data)......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED]Sort on the Basis of Row Totals (Across) (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
An example using the CAR file: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Second Max Value (in iWay Software Product Forum on Focal Point) by Dan Satchell
Add BY CAR if you want the second highest number for each car: ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [CLOSED] Second Max Value (in iWay Software Product Forum on Focal Point) by Dan Satchell
This example using the CAR file may help: ......
Focal Point > Focal Point Forums > iWay Software Product Forum on Focal Point

Discussion Topic  RE: [CLOSED] Create 1 Report with multiple Tabs in Excel (in WebFOCUS/FOCUS Forum on Focal Point ) by Dan Satchell
This sample code may give you a possible solution: ......
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 ... 61 

Focal Point    Focal Point Forums    Search    Search Results

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.