[SOLVED]hyperlink excel spreadsheet downloads, setting the file name with parameters.
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.
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 ENDThis message has been edited. Last edited by: FP Mod Chuck,
8105
August 28, 2017, 08:18 AM
BabakNYC
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,
WebFOCUS 8206, Unix, Windows
August 28, 2017, 09:08 AM
Wendy G
(SOLVED)
Thank you that was perfect!
ON TABLE PCHOLD FORMAT XLSX AS '120day||&SYS||&PRIN||&AGNT||&ARCATEGORY'