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 ... 5 6 7 8 9 10 11 ... 22
Go
New
Search
Tools
Search Results: (435 matches) New Search Login/Join 

Discussion Topic  RE: [CLOSED] db_expr direct SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
DB_EXPR will work like this in the sql quer if this is the code: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] db_expr direct SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Well it's not a matter of how WebFOCUS works, Oracle just doesn't multiple values per cell. Perhaps......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] db_expr direct SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
That depends on the Database and Adapter. Some databases support multiple values for one cell. Norma......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] db_expr direct SQL (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
for example: DEFINE FILE TABLE TEST/I11 WITH ID = DB_EXPR(select max(value) from table); END...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] How common is using SQL based synonyms? (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
A good Masterfile can be difficult on some databases and I think you have this with any tool. Genera......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] How common is using SQL based synonyms? (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
In 99% of cases I've seen, masterfiels are created on tables....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] display of decimals in edit bar or function bar (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
With this code I see 6 decimals in Excel (2016) ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Creating a hold file/master file with static data(not from database) (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
There is no advantage to store this data in a holdfile just because it's static. Just define a list ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Solved]WebFocus Repository tables, how to determine if chart or report. (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
table wf_objectprops, filter on PROPERTY = OutputFormat, in PROPVALUE you'll see the format. JSCHART......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Extract month and year from date (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Extract month and year from date (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Better use DTPART in order to get SQL optimization: DEFINE FILE ... YEAR/I4=DTPART(DATETIMECOLUMN,Y......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Adding a -SET Statement in InfoAssist+ (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Or use a Reporting Object if you only want reports or diagrams, do your -SET there in the preprocess......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [Solved]flattening out data using an across hold file (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Or use format FOCUS: TABLE FILE CAR SUM SALES BY COUNTRY ACROSS CAR ON TABLE HOLD FORMAT FOCUS END ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Compound Reports PCHOLD Format Alpha (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Try this: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Printing 2 tables as a DOC format (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Because doc is a file, you first need to combine it in one file: ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: Join a CX Group: WebFOCUS Page Designer 8203, 8204, and Beyond (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
I'm interested in joining this group....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] How do I split Column heading (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Something like this? ......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Is there a HOLD format that does not create a file? (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
to my experience, creating a small HOLD file doesn't take a lot of resources. On Linux, the BINARY o......
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [SOLVED] Inserting USERNAME in the synonym (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
What is your usecase, do you want to show the user that is loggedon in the report?...
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point

Discussion Topic  RE: [CLOSED] Hyperstage Performance Active Reports (in WebFOCUS/FOCUS Forum on Focal Point ) by Frans
Jenni do you have Infoassist+ ? If yes, then better use Visualisations for this....
Focal Point > Focal Point Forums > WebFOCUS/FOCUS Forum on Focal Point


» Refine Search
» New Search

  Powered by Social Strata Page 1 ... 5 6 7 8 9 10 11 ... 22 

Focal Point    Focal Point Forums    Search    Search Results

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