Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Excel Output makes one extra row with nothing it in when doing a mail-merge
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Excel Output makes one extra row with nothing it in when doing a mail-merge
 Login/Join
 
Member
posted
Good Afternoon,

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.

From,

Anguel Esperanza

 -* 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
END
 

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


WebFOCUS 8

Windows, All Outputs
 
Posts: 11 | Registered: May 02, 2018Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Anguel

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
 
Posts: 1428 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
I'll do just that then as the problem still persists. Thank you.


WebFOCUS 8

Windows, All Outputs
 
Posts: 11 | Registered: May 02, 2018Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Excel Output makes one extra row with nothing it in when doing a mail-merge

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.