Walter Brengel

Join "The Walters" for their monthly tips and techniques sessions for both the FOCUS and WebFOCUS products. These free sessions (generally) are on the third Friday of the month and will review new features to the product as well as taking better advantage of already available features. Go to... https://www.ibi.com/events to see the upcoming schedule and to sign up to review past sessions. The Walters

Hi Prem, Assuming the image is showing what you want to see, this code will do it: DEFINE FILE CAR ACRPOS/I3 WITH CAR=IF COUNTRY EQ LAST COUNTRY THEN ACRPOS + 1 ELSE 1; END TABLE FILE CAR SUM CAR BY COUNTRY ACROSS ACRPOS NOPRINT END It will create a position field (ACRPOS) that is used to go ACROSS the page and gets reset back to 1 (the first column) when the COUNTRY value changes. Walter

This will work too: -SET &WEIGHTED_PREMIUM_YTD = FPRINT(&Weighted_Premium_YTD, D12M ); -SET &NEW_PREMIUM_YTD = FPRINT(&New_Premium_YTD, D12M) ; There is a new simplified version of FPRINT that does not need the third parameter. The issue I was having when I cut/paste the example was the apostrophes were open and closed apostrophes and not straight apostrophes, if that makes any sense. That may have just happened in my cut/paste though.

Thanks Martin, I ran from the server console in 8207.28 with no problem.

nicholas.boyer: Advocate Reward - 11111111111 Take a look at the token function: DEFINE FILE CAR MYFIELD/A50=Advocate Reward - 11111111111; MYFIELD_LEFT/A50=TOKEN(MYFIELD, - ,1); MYFIELD_RIGHT/A50=TOKEN(MYFIELD, - ',-1); END TABLE FILE CAR PRINT MYFIELD MYFIELD_LEFT MYFIELD_RIGHT BY COUNTRY WHERE RECORDLIMIT EQ 1 END If you dont see the token function there is also an older GETTOK function which will require more parameters: MYFIELD_LEFT/A50=GETTOK(MYFIELD,50,1,-,50,A50); MYFIELD_RIGHT/A50=GETTOK(MYFIELD,50,-1,-,50,A50); Walter

The main session will be recorded, not the After Party. Sometime next week it should be available via events.tibco.com.

Hi Evan, What you shared is the behind the scenes of what happens from the Server point of view after all the client processing has happened. Walter

In addition to the additional length for the AnV field (which will have a AnW in the master), another cause of a multiplication of 3 for character output bytes is attributed to a unicode (UTF-8) codepage. For UTF-8 a single character can be up to 3 UTF-8 bytes so WebFOCUS needs to have enough space in case all characters require 3 bytes. Walter

Certainly. It was introduced in 7706M. I found this in the Summary of New Features doc Preventing Visual Overflow How to: Prevent Visual Overflow Reference: Usage Notes for SET EXTENDNUM At times, the size defined for the USAGE format of a field may be too small to fit the actual data to be displayed. In previous releases, this scenario would cause asterisks (***) to display in the report output in place of the actual value. Situations that cause this scenario include: If the display value is larger than the defined display format. If a value is aggregated, the summed value does not fit into the space that was allotted for the column by the USAGE format of the field. Syntax: How to Prevent Visual Overflow SET EXTENDNUM = {ON|OFF|AUTO} where: ON Displays all numbers in full, regardless of the USAGE format defined. OFF Displays asterisks when the value does not fit in the space allotted by the USAGE format. This is the legacy behavior. AUTO Applies an ON or OFF setting based on output format and SQUEEZE settings, as shown in the following table. Format SQUEEZE Setting EXTENDNUM PDF, PS, DHTML, PPT, PPTX ON OFF|ON OFF| |HTML, EXL2K, XLSX|N/A|ON| |BINARY, ALPHA|N/A|OFF| |WP, other delimited formats|N/A|OFF| AUTO is the default value. Reference: Usage Notes for SET EXTENDNUM Invoking SET EXTENDNUM=ON may change the report layout in the following ways. Changes in report layout: With styled formats (PDF, PS, DHTML, HTML, EXL2K, XLSX, PPT, PPTX), the width of the report is expanded to accommodate the width of the data columns. This may change the placement of the overall report on the defined page and in some instances cause columns to overflow to a new page. For PDF, DHTML, PPT, and PPTX, the setting SQUEEZE ON will ensure that the alignment within each column is retained. For HTML, EXL2K, and XLSX, the alignment will automatically be retained regardless of SQUEEZE settings. With unstyled formats (WP), the columns are not adjusted to fit the new values, which may cause misalignment of data columns. Changed behavior in operating systems where the defined number format is not supported: Integers larger than 2GB cannot display on 32-bit machines. Therefore, such integers on these machines will display incorrect values. Floating-point numbers (types F and D) that require more than 31 digits to print correctly will continue to display asterisks. For example, a field with usage D33.30 and a value of 10.0 will print as asterisks because it needs 30 zeros to the right of the decimal point and two digits to the left. Walter Please join Walter Blood, Mark Derwin and myself at our FOCUS Friday session which are held monthly. You can register here: TIBCO Software Inc. FOCUS Fridays Virtual User Group Applications are at the heart of this months FOCUS Frida The next one is this Friday (October 15th, 2021) from 11:30am EDT to 1:00pm EDT.

There is also a new setting: EXTENDNUM. The default value is AUTO and this will show all the digits of a number when you dont specify enough digits in your format. You can turn it off with SET EXTENDNUM=OFF and then see the overflow characters (*). Walter

Good points from everyone. MORE is used to append data (more records/rows) and MATCH is used to MERGE data which gives you potentially more records/row plus the addition of additional columns from the various files you are using in MATCH. Walter