Hi,

I have an issue with the "No Selection" parameter in a dynamic selection list. I have a report that displays in html, and then has a link named "Excel Report" in which you can click on and see the same report in excel format. When this link is selected all of the previous selected parameters pass through just fine, but if the "No Selection" parameter is selected it selects a random selection to display in the excel report. Has anyone experienced this type of problem before, if so how do I fix it?


Aaron
Texas
WebFOCUS 7: 7.1.4
WINXP
Excel, PDF, HTML: EXCEL, PDF, HTML

ahh - the old FOC_NONE strikes again.

The problem is that, under the covers, when "No selection" is used, a variable value of FOC_NONE is inserted for the parameter value. WebFOCUS is trained to ignore any line of code which contains the string FOC_NONE. The problem is that if there are other parm/values on the same line, they get ignored as well. You may get around this by checking your code and making sure that any line that could contain the FOC_NONE value is on a line by itself and the rest of the code would be unaffected by its absence.

Another method would be to replace 'FOC_NONE' value for "No selection" with '$*' but that only works with alpha strings of two characters or more.

Well in the initial report that is in html format the value for the parameter is FOC_NONE, but when I drill down from that report it will no Pass the FOC_NONE value through to the next report, instead it picks a random parameter and passes it through.

-SET &PROMPT_MON = DECODE &PROMPT_MON_INT( 01 JANUARY 02 FEBRUARY 03 MARCH 04 APRIL 05 MAY 06 JUNE 07 JULY 08 AUGUST 09 SEPTEMBER 10 OCTOBER 11 NOVEMBER 12 DECEMBER );
-SET &EXPN_GRP_HEADER = IF &EXPN_GRP_TXT EQ FOC_NONE THEN 'All Groups' ELSE &EXPN_GRP_TXT;
-SET &EXPN_GRP_TXT = IF &EXPN_GRP_TXT EQ FOC_NONE THEN 'FOC_NONE' ELSE &EXPN_GRP_TXT;
TABLE FILE FI_BDGT_MAIN_INFO_V2
SUM
YTD_ITEM_TOTL AS 'BUDGETED-YTD TOTAL'
EXPN_AMT AS 'SPENT-TOTAL'
COMPUTE VAR/D20.2 = SUM.YTD_ITEM_TOTL + SUM.EXPN_AMT; AS 'VARIANCE'
BY EXPN_DESC_TXT AS 'BUDGET ITEM DESC'
BY ITEM_PLAN_QTY_NBR AS 'QTY'
BY UNIT_AMT_WITH_TAX AS 'UNIT AMT'
BY ITEM_TOTL NOPRINT AS 'BUDGETED-TOTAL'
PRINT
EXPN_ACCT_NBR_TXT AS 'ACCT NBR'
EXPN_ACCT_DESC_TXT AS 'PURCHASE ITEM DESC'
NEW_EXPN_POST_DT AS 'POSTING DATE'
EXPN_POST_TXT AS 'POSTING NOTES'
EXPN_AMT AS 'SPENT-DETAIL'

BY EXPN_DESC_TXT AS 'BUDGET ITEM DESC'
BY ITEM_PLAN_QTY_NBR AS 'QTY'
BY UNIT_AMT_WITH_TAX AS 'UNIT AMT'
BY ITEM_TOTL NOPRINT AS 'BUDGETED-TOTAL'
BY EXPN_POST_DT NOPRINT
BY EXPN_GRP_TXT NOPRINT
ON ITEM_TOTL SUBTOTAL
SUM. YTD_ITEM_TOTL
SUM. EXPN_AMT
SUM. VAR AS 'TOTAL BUDGETED FOR ENTIRE YEAR'
ON TABLE SUBHEAD
"&BDGT_YR OPERATIONAL BUDGET ANALYSIS "
"AS OF &PROMPT_MON "
" "
"Excel Report"
HEADING
"EXPENSE CATEGORY: "BUDGET AREA: "EXPENSE CLASS: "BUDGET GROUP: &EXPN_GRP_HEADER"
" "
"Note: All amounts include tax."
" "
WHERE ( BDGT_TYPE_TXT EQ 'E' );
WHERE BDGT_YR EQ &BDGT_YR;
WHERE ( EXPN_CTGY_TXT EQ '&EXPN_CTGY_TXT' ) AND ( NEW_BDGT_AREA_KEY EQ '&NEW_BDGT_AREA_KEY' ) AND ( EXPN_CLS_TXT EQ '&EXPN_CLS_TXT' );
WHERE TOTAL SUM.EXPN_AMT EQ 0 OR ( EXPN_POST_MON LE '&PROMPT_MON_INT' );
WHERE EXPN_GRP_TXT EQ &EXPN_GRP_TXT.(OR(FIND EXPN_GRP_TXT IN FI_EXPN_GRP_DOMN)).Budget Group.;

Here is a basic example of what I am trying to do. The above report is the report that displays the html layout but when the drill down is executed to display the excel report the value for expn_grp_txt is no longer FOC_NONE

Here is the code that executes the drill down. Its is not included in my previous post

TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
FOCEXEC=exp_bdgt_detail-excel (EXPN_CTGY_TXT='&EXPN_CTGY_TXT' NEW_BDGT_AREA_KEY='&NEW_BDGT_AREA_KEY' EXPN_CLS_TXT='&EXPN_CLS_TXT' PROMPT_MON_INT='&PROMPT_MON_INT' BDGT_YR='&BDGT_YR' EXPN_GRP_TXT='&EXPN_GRP_TXT'),
$

that's right. As I mentioned, the line that contains 'FOC_NONE' is ignored, so that parm along with ANYTHING ELSE on that line is ignored.

try this in your drilldown code:

FOCEXEC=exp_bdgt_detail-excel ( \
EXPN_CTGY_TXT='&EXPN_CTGY_TXT' \
NEW_BDGT_AREA_KEY='&NEW_BDGT_AREA_KEY' \
EXPN_CLS_TXT='&EXPN_CLS_TXT' \
PROMPT_MON_INT='&PROMPT_MON_INT' \
BDGT_YR='&BDGT_YR' \
EXPN_GRP_TXT='&EXPN_GRP_TXT' \ 
),
$

The other thing I would definitely recommend is shortening your amper variable names to 12 characters or less.

And your fex name is a little strange - very long and includes a dash. They're usually shorter with no special characters except an underscore. That may or may not be an issue.

Thanks for the response Darin. I tried the drill down code that you suggested and I still had no luck, it passed the value for &EXPN_GRP_TXT as "User"(Which is one of the possible selections)rather than "FOC_NONE".

Here is the code for the actual excel report

-SET &PROMPT_MON = DECODE &PROMPT_MON_INT( 01 JANUARY 02 FEBRUARY 03 MARCH 04 APRIL 05 MAY 06 JUNE 07 JULY 08 AUGUST 09 SEPTEMBER 10 OCTOBER 11 NOVEMBER 12 DECEMBER );
-SET &EXPN_GRP_HEADER = IF &EXPN_GRP_TXT EQ FOC_NONE THEN 'All Groups' ELSE &EXPN_GRP_TXT;

TABLE FILE FI_BDGT_MAIN_INFO_V2
SUM
YTD_ITEM_TOTL AS 'BUDGETED-YTD TOTAL'
EXPN_AMT AS 'SPENT-TOTAL'
COMPUTE VAR/D20.2 = SUM.YTD_ITEM_TOTL + SUM.EXPN_AMT; AS 'VARIANCE'
BY EXPN_DESC_TXT AS 'BUDGET ITEM DESC'
BY ITEM_PLAN_QTY_NBR AS 'QTY'
BY UNIT_AMT_WITH_TAX AS 'UNIT AMT'
BY ITEM_TOTL NOPRINT AS 'BUDGETED-TOTAL'
PRINT
EXPN_ACCT_NBR_TXT AS 'ACCT NBR'
EXPN_ACCT_DESC_TXT AS 'PURCHASE ITEM DESC'
NEW_EXPN_POST_DT AS 'POSTING DATE'
EXPN_POST_TXT AS 'POSTING NOTES'
EXPN_AMT AS 'SPENT-DETAIL'
BY EXPN_DESC_TXT AS 'BUDGET ITEM DESC'
BY ITEM_PLAN_QTY_NBR AS 'QTY'
BY UNIT_AMT_WITH_TAX AS 'UNIT AMT'
BY ITEM_TOTL NOPRINT AS 'BUDGETED-TOTAL'
BY EXPN_POST_DT NOPRINT
BY EXPN_GRP_TXT NOPRINT
ON ITEM_TOTL SUBTOTAL
SUM. YTD_ITEM_TOTL
SUM. EXPN_AMT
SUM. VAR AS 'TOTAL BUDGETED FOR ENTIRE YEAR'
ON TABLE SUBHEAD
"&BDGT_YR OPERATIONAL BUDGET ANALYSIS "
"AS OF &PROMPT_MON "
HEADING
"EXPENSE CATEGORY: "BUDGET AREA: "EXPENSE CLASS: "BUDGET GROUP: " "
"Note: All amounts include tax."
" "
WHERE ( BDGT_TYPE_TXT EQ 'E' );
WHERE BDGT_YR EQ &BDGT_YR;
WHERE ( EXPN_CTGY_TXT EQ '&EXPN_CTGY_TXT' ) AND ( NEW_BDGT_AREA_KEY EQ '&NEW_BDGT_AREA_KEY' ) AND ( EXPN_CLS_TXT EQ '&EXPN_CLS_TXT' );
WHERE TOTAL SUM.EXPN_AMT EQ 0 OR ( EXPN_POST_MON LE '&PROMPT_MON_INT' );
WHERE EXPN_GRP_TXT EQ '&EXPN_GRP_TXT';

If it passes the value of 'User', then that is the value of the parm. It can't pass a value that has not been set. If you want to pass something different, you need to hard code that value.

Are you running this from a launch page? It appears that you must be as you mention "dynamic selection" and use of FOC_NONE. In this case, you don't need the

.(OR(FIND EXPN_GRP_TXT IN FI_EXPN_GRP_DOMN)).Budget Group.

in the original fex. Use -SET &ECHO=ALL; at the beginning of your first fex and then run it and "View Source" to see what parm values have actually been set in the drilldown portion. It probably says 'User' in there as well. I don't think the problem is in the actual passing of the parameter as it is in properly setting the value in the intial procedure.

I totally agree with Darin regarding the FOCEXEC name being shorter and WITHOUT special characters - especially the dash. I've seen the dash being interpreted as a minus and thus, being used as a mathematical operator. So, the fex name "exp_bdgt_detail-excel" turns into exp_bdgt_detail - excel and then that equates to an error.