WebFOCUS Blogs

Dear friends, While creating the Excel report, the name of the excel file comes randomly with normal scenario if we give "PCHOLD FORMAT EXL07". I recently came to a scenario where the business user wanted the excel report name to come as per the report name. Please note that user wanted to rename Excel file name not the tab names in the file. In general we right our code as below: TABLE FILE CAR SUM      CAR.BODY.SEATS      CAR.BODY.DEALER_COST      CAR.BODY.RETAIL_COST      CAR.BODY.SALES BY  CAR.COMP.CAR BY  CAR.CARREC.MODEL ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT EXL07 ON TABLE SET HTMLEMBEDIMG ON ON TABLE SET HTMLCSS ON ON TABLE SET STYLE *      INCLUDE = endeflt, $ ENDSTYLE END Output: However if we need to name the Excel file, we can use below code: TABLE FILE CAR SUM      CAR.BODY.SEATS      CAR.BODY.DEALER_COST      CAR.BODY.RETAIL_COST      CAR.BODY.SALES BY  CAR.COMP.CAR