Brent Mason 2

Use the following to avoid truncation: -? & SAVEPRINT

My suggestion was based on your statement that you wanted a count "...without holding the data inside webFOCUS." If that's not the case, you can verify that the car file has 18 records with Patrick's &RECORDS or &HOW_MANY example. This is the same answer given by COUNT *.

TABLE FILE <synonym> COUNT * END

DEFINE FILE ggsales UNITS_FORMAT/A20 = FPRINT(UNITS, 'I08'); END TABLE FILE ggsales PRINT UNITS UNITS_FORMAT END

Actually, the portion of the log file path you mentioned is "INetCache" not "NetCache". Follow the path as far as you can, say to "Windows", and then search for "*.log" in Windows Explorer.

Check the log file referenced in the error. I had a similar issue, and the log file indicated that I had a "missing end-tag" in the span element syntax I was using to create custom tooltips for the columns in a report formatted as AHTML.

Ah, I knew I was close, but I just couldnt figure out the last step. I greatly appreciate your prompt feedback and expertise. Ive learned a lot just by studying the code you developed for our custom portal in 2018-2019. Thank you.

Using legacy metadata sample ggsales, I want to sort Dollar Sales by Region and then by State within each Region. The result should be the following: Ive tried several approaches, including WITHIN and with/without multi-verb requests. Heres what I currently have: TABLE FILE ggsales SUM DOLLARS/P21MBC NOPRINT BY TOTAL HIGHEST DOLLARS/P21MBC NOPRINT BY REGION SUM DOLLARS/P21MBC BY TOTAL HIGHEST DOLLARS/P21MBC BY REGION BY ST END Id appreciate the communitys input. Thank you.

Just let them choose Sales or Profit and Amounts or Increase because one can reasonably assume that the second drop down reflects the choice made in the first drop down. Reinforce this for the user with how you name the measures in the reports. -DEFAULT &Measure = 'Actual'; -DEFAULT &Output = 'Amount'; -IF &Measure.(Actual,Budget). EQ 'Actual' AND &Output.(Amount,Change). EQ 'Amount' THEN GOTO Actual_Amount -ELSE IF &Measure.(Actual,Budget). EQ 'Actual' AND &Output.(Amount,Change). EQ 'Change' THEN GOTO Actual_Change -ELSE IF &Measure.(Actual,Budget). EQ 'Budget' AND &Output.(Amount,Change). EQ 'Amount' THEN GOTO Budget_Amount -ELSE GOTO Budget_Change -Actual_Amount TABLE FILE GGSALES SUM DOLLARS/P21MBC AS '&Measure Sales &Output' BY HIGHEST 2 DATE END -RUN -EXIT -Actual_Change TABLE FILE GGSALES SUM COMPUTE VAR/P21MBC = PARTITION_REF(DOLLARS, TABLE, +0) - PARTITION_REF(DOLLARS, TABLE, +1); AS '&Output in &Measure Sales,from Prior Month' BY HIGHEST 2 DATE END -RUN -EXIT -Budget_Amount TABLE FILE GGSALES SUM BUDDOLLARS/P21MBC AS '&Measure Sales &Output' BY HIGHEST 2 DATE END -RUN -EXIT -Budget_Change TABLE FILE GGSALES SUM COMPUTE VAR/P21MBC = PARTITION_REF(BUDDOLLARS, TABLE, +0) - PARTITION_REF(BUDDOLLARS, TABLE, +1); AS '&Output in &Measure Sales,from Prior Month' BY HIGHEST 2 DATE END -RUN -EXIT