I have an procedure that outputs an excel file for a given student. The only bit of information in the excel is two rows, the header of the excel file (column names) and the data for the student that goes along with it. For example, I have a header called Name, and on the next row, is the name of the student. The procedure only runs for one student as a time. The problem is that the excel file returns a blank line. I know this because I am using it for a mail-merge using Microsoft Word. Microsoft Word has two recipients for the mail-merge, the student the procedure is run for, and then a blank line. Given that this procedure is made up of a few table files it, I stopped the procedure at different table files and had those output as an excel. I used those outputs in a mail-merge just to see if the blank line shows up and it does not. Microsoft Word does not have a blank line as a recipient for those excels. The only time a blank line appears is when the entire procedure is run. Has anyone else had this problem, or an idea as how to fix it? I've included my code in as well below. Any help would be greatly appreciated.
-* File: IBFS:/TestWF/WFC/Repository/Registrar/Report1.fex Created by WebFOCUS AppStudio -DEFAULTH BOX1 = ' '; -DEFAULTH BOX2 = ' '; -DEFAULTH BOX3 = ' '; -DEFAULTH BOX4 = ' '; -DEFAULTH ABOX = ' '; -DEFAULTH TBOX = ' '; -* Get student name and level code JOIN SFRSTCR.SFRSTCR.SFRSTCR_PIDM IN sfrstcr TO MULTIPLE SGBSTDN.SGBSTDN.SGBSTDN_PIDM IN sgbstdn TAG J0 AS J0 END DEFINE FILE SFRSTCR LEVEL/A20V = DECODE SGBSTDN_LEVL_CODE ('UG' 'Undergraduate' ELSE 'Graduate'); FP_IND/A10V = DECODE SGBSTDN_RESD_CODE (0 'Part Time' 1 'Part Time' 2 'Part Time' 3 'Part Time' ELSE 'Full Time'); NAME/A130V = SQL.F_FORMAT_NAME(SFRSTCR_PIDM, 'LFMI'); MAT/A3V = DECODE SGBSTDN_PROGRAM_1 ('UG NONMATRIC' 'No' 'GR NONMATRIC' 'No' 'CE NONCREDIT' 'No' 'GR UNDCB' 'No' 'GR UNDCM' 'No' 'GR UNDCBCERT' 'No' ELSE 'Yes'); CURR_DATE/A30V = '&DATEMtrDYY'; END TABLE FILE SFRSTCR BY LOWEST SFRSTCR.SFRSTCR.SFRSTCR_PIDM BY SFRSTCR.SFRSTCR.SFRSTCR_TERM_CODE BY J0.SGBSTDN.EASTERNID BY NAME BY SGBSTDN_LEVL_CODE BY LEVEL BY FP_IND BY MAT BY CURR_DATE WHERE SGBSTDN_TERM_CODE_EFF LE '&TERM' WHERE SFRSTCR_TERM_CODE EQ '&TERM'; WHERE EASTERNID EQ '&ID'; ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL -*ON TABLE PCHOLD FORMAT XLSX ON TABLE HOLD AS HLD1 FORMAT XFOCUS INDEX 'SFRSTCR_PIDM' END -*-EXIT -*JOIN CLEAR * -* -* Gets the students with the incl_sect_enrl eq 'y' JOIN SFRSTCR_RSTS_CODE IN sfrstcr TO MULTIPLE STVRSTS.STVRSTS.STVRSTS_CODE IN stvrsts TAG J1 AS J1 END TABLE FILE SFRSTCR BY SFRSTCR_PIDM WHERE STVRSTS_INCL_SECT_ENRL EQ 'Y'; WHERE SFRSTCR_TERM_CODE EQ '&TERM'; ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL -*ON TABLE PCHOLD FORMAT XLSX ON TABLE HOLD AS HLD2 FORMAT XFOCUS INDEX 'SFRSTCR_PIDM' END JOIN CLEAR * -* Gets the Start Date / End Date JOIN SFRSTCR.SFRSTCR.SFRSTCR_TERM_CODE IN SFRSTCR TO MULTIPLE STVTERM.STVTERM.STVTERM_CODE IN STVTERM TAG J2 AS J2 END TABLE FILE SFRSTCR -*ON TABLE PCHOLD FORMAT AHTML SUM SFRSTCR.SFRSTCR.SFRSTCR_CREDIT_HR BY LOWEST SFRSTCR.SFRSTCR.SFRSTCR_PIDM BY J2.STVTERM.StartDateYYMD BY J2.STVTERM.EndDateYYMD BY J2.STVTERM.STVTERM_DESC WHERE SFRSTCR_TERM_CODE EQ '&TERM'; ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE HOLD AS HLD3 FORMAT XFOCUS INDEX 'SFRSTCR_PIDM' END JOIN HLD1.SEG01.SFRSTCR_PIDM IN HLD1 TO UNIQUE HLD2.SEG01.SFRSTCR_PIDM IN HLD2 TAG J3 AS J3 END JOIN J3.SEG01.SFRSTCR_PIDM IN HLD1 TO UNIQUE HLD3.SEG01.SFRSTCR_PIDM IN HLD3 TAG J4 AS J4 END DEFINE FILE HLD1 BOX1/A130V = &BOX1; BOX2/A130V = &BOX2; BOX3/A130V = &BOX3; BOX4/A130V = &BOX4; ABOX/A130V = &ABOX; TBOX/A30V = &TBOX; END TABLE FILE HLD1 BY HLD1.SEG01.EASTERNID AS 'ID' BY HLD1.SEG01.NAME AS 'Name' BY J4.SEG01.SFRSTCR_CREDIT_HR AS 'SEM_CREDITS' BY J4.SEG01.StartDateYYMD AS 'Start' BY J4.SEG01.EndDateYYMD AS 'End' BY HLD1.SEG01.LEVEL AS 'Level' BY J4.SEG01.STVTERM_DESC AS 'Term' BY FP_IND AS 'Status' BY MAT BY CURR_DATE BY BOX1 BY BOX2 BY BOX3 BY BOX4 BY ABOX BY TBOX ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET ASNAMES ON ON TABLE NOTOTAL ON TABLE PCHOLD FORMAT XLSX ON TABLE SET HTMLCSS ON ON TABLE SET STYLE * INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/warm.sty, $ ENDSTYLE ENDThis message has been edited. Last edited by: Anguel,
Windows, All Outputs
If this is still an issue please open a case with techsupport since no one has been able to provide you any guidance.
Thank you for using Focal Point!
Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
I'll do just that then as the problem still persists. Thank you.
Windows, All Outputs
|Powered by Social Strata|