Where and how do I set the parameters in the download file name?

I have a report with many hyperlinks. Each one is on a column and sends parameters to another fex to pull the report that is formatted as a spreadsheet.

on example:
TYPE=DATA,
COLUMN=N13,
FOCEXEC=IBFS:/WFC/Repository/Comcast_PSG_Custom_Reports/Hidden_Content/AR_Closing/AR_Cnt_Day120_Balance.fex( \
DIVISION=N2 \
MARKET=N3 \
SYS=N5 \
PRIN=N6 \
AGNT=N7 \
ARCATEGORY=N8 \
STATUS=N4 \
MONTH=N1 \
),
TARGET='_blank',

Each time we do the hyperlink the file downloaded has the same name even when the parameters change. The effect is the client can only open one AR_Cnt_day120_Balance spreadsheet at a time and gets an error when trying to pull a different filter for another market. The file must be saved and closed before a new version can be opened. I would like to put the parameters in the file name so that each spreadsheet would have a distinct name.

Here is the code for the spreadsheet output:

TABLE FILE DB_UPPER_ARC_DTL
SUM
DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.CUR_AMT/D20.2CSM AS 'CURR AMT'
DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.DAY30_AMT/D20.2CSM AS 'DAY30'
DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.DAY60_AMT/D20.2CSM AS 'DAY60'
DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.DAY90_AMT/D20.2CSM AS 'DAY90'
DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.DAY120_AMT/D20.2CSM AS 'DAY120, PLUS'
BY DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.RUN_DATE_BKT_YEAR_M AS 'MONTH'
BY DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.AR_CTGRY AS 'ARCATEGORY'
BY DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.CUST AS 'CUSTOMER,NUMBER'
BY LOWEST DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.SUB AS 'SUBSCRIBER,NUMBER'
BY DB_UPPER_ARC_DTL.DB_UPPER_ARC_DTL.SUB_STAT AS STATUS
WHERE DAY120_CNT GT 0;
WHERE DIVISION EQ &DIVISION.QUOTEDSTRING;
WHERE MARKET EQ &MARKET.QUOTEDSTRING;
WHERE SYS EQ &SYS;
WHERE PRIN EQ &PRIN;
WHERE AGNT EQ &AGNT;
WHERE SUB_STAT EQ &STATUS.QUOTEDSTRING;
WHERE AR_CTGRY EQ &ARCATEGORY.QUOTEDSTRING;
WHERE RUN_DATE_BKT_YEAR_M EQ &MONTH.QUOTEDSTRING;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = /FILE/IBI_HTML_DIR/javaassist/intl/EN/combine_templates/ENBlue_Light2.sty,
$
ENDSTYLE
END

This message has been edited. Last edited by: FP Mod Chuck,

Use AS filename like:

quote:

ON TABLE PCHOLD FORMAT XLSX AS WHTEVERNAME_YOU_WANT

You can concatenate &VARIABLES to make up the name you want.

 TABLE FILE CAR
SUM SALES
BY COUNTRY BY CAR
WHERE COUNTRY EQ '&COUNTRY';
ON TABLE PCHOLD  FORMAT XLSX AS '&COUNTRY'
END 

This message has been edited. Last edited by: BabakNYC,

(SOLVED)

Thank you that was perfect!

ON TABLE PCHOLD FORMAT XLSX AS '120day||&SYS||&PRIN||&AGNT||&ARCATEGORY'

makes 120day__8396_4000_10_latefee-comm.xlsx