Focal Point
[SOLVED] Report Caster With Excel output not sending email

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4217079296

March 27, 2020, 07:13 PM
Rozalind
[SOLVED] Report Caster With Excel output not sending email
I have a report built. The report renders in Excel, and has 4 tabs in it. I go and schedule the report. When I run the schedule nothing populates. When I look at the log this is what I get:
0 XLSX FILE SAVED ...

1

Connection to the Reporting Server EDASERVE closed at 2020-03-27 15:30:03.268-0700 (1,585,348,203,268)

Job ran on the Reporting Server EDASERVE for 86.419 seconds

Task finished.

No report from Task 'Task 1'.

No report to distribute.
I am probably missing a step but I am not sure what. Thank you for your help!

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


WebFOCUS 8
Windows, All Outputs
March 27, 2020, 07:55 PM
FP Mod Chuck
Rozalind

I suspect your code says ON TABLE HOLD FORMAT XLSX and not ON TABLE PCHOLD FORMAT XLSX.

If I am wrong please post the code of report.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
March 30, 2020, 01:50 PM
Rozalind
It looks like it is correct. Here is the code for the report:

-* File: IBFS:/TEST/WFC/Repository/STCU/Reports/Corporate/Loans/Procedure1.fex Created by WebFOCUS AppStudio
TABLE FILE COVID19LOANSKIPPAY
BY COVID19LOANSKIPPAY.COVID19LOANSKIPPAY.ACCT_NUM AS 'ListAcct'
BY COVID19LOANSKIPPAY.COVID19LOANSKIPPAY.PRODUCT_CLASS_CODE AS 'ListProc'
BY LOWEST COVID19LOANSKIPPAY.COVID19LOANSKIPPAY.MBR_NUM AS 'ListMbrNum'
ON TABLE SUBHEAD
"SkipPayList"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS SkipPayList
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
ENDSTYLE
END
TABLE FILE A_TRANS_DLY
SUM
A_TRANS_DLY.TRANSACTION_DAILY.TRANS_CNT
BY A_TRANS_DLY.ACCOUNT.ACCT_NUM
BY A_TRANS_DLY.DATE_POSTED.DTE AS 'PostDate'
BY A_TRANS_DLY.DATE_EFFECTIVE.DTE AS 'EffDate'
BY A_TRANS_DLY.TRANSACTION_DAILY.TRANS_NARR_1
BY A_TRANS_DLY.TRANSACTION_TYPE.SRC_TRANS_CD
BY A_TRANS_DLY.TRANSACTION_TYPE.SRC_TRANS_DESCR
BY A_TRANS_DLY.ACCOUNT.ACCT_DURABLE_KEY
BY A_TRANS_DLY.PRODUCT.PROD_CLASS_CD
BY A_TRANS_DLY.PRODUCT.PROD_DESCR
ON TABLE SUBHEAD
"TransDaily"
ON TABLE SUBFOOT
"post date GE 3/16/2020"
"transaction code EQ '309' or '310'"
WHERE ( A_TRANS_DLY.DATE_POSTED.DTE GE '03162020' ) AND ( A_TRANS_DLY.TRANSACTION_TYPE.SRC_TRANS_CD EQ '309' OR '310' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS TransDaily
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TYPE=TABHEADING,
SIZE=14,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
$
TYPE=TABFOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=9,
$
ENDSTYLE
END
TABLE FILE A_TRANS_DLY
SUM
A_TRANS_DLY.TRANSACTION_DAILY.TRANS_CNT
BY A_TRANS_DLY.ACCOUNT.ACCT_DURABLE_KEY
BY A_TRANS_DLY.ACCOUNT.ACCT_NUM
BY A_TRANS_DLY.DATE_POSTED.DTE
BY A_TRANS_DLY.DATE_EFFECTIVE.DTE
BY A_TRANS_DLY.TRANSACTION_TYPE.SRC_TRANS_CD
BY A_TRANS_DLY.TRANSACTION_TYPE.SRC_TRANS_DESCR
BY A_TRANS_DLY.PRODUCT.PROD_CLASS_CD
BY A_TRANS_DLY.PRODUCT.PROD_DESCR
ON TABLE SUBHEAD
"PtransDaily"
WHERE ( A_TRANS_DLY.DATE_POSTED.DTE EQ A_TRANS_DLY.DATE_POSTED.PREV_BUS_DAY_DTE ) AND ( A_TRANS_DLY.TRANSACTION_TYPE.SRC_TRANS_CD EQ '309' OR '310' );
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS PtransDaily
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TYPE=TABHEADING,
SIZE=14,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
ENDSTYLE
END
JOIN
LEFT_OUTER TRANSDAILY.TRANSDAI.ACCT_NUM IN TransDaily TO MULTIPLE
SKIPPAYLIST.SKIPPAYL.ACCT_NUM IN SkipPayList TAG J1 AS J1
END
TABLE FILE TRANSDAILY
SUM
J1.SKIPPAYL.LISTMBRNUM
TRANSDAILY.TRANSDAI.TRANS_CNT
BY LOWEST TRANSDAILY.TRANSDAI.ACCT_DURABLE_KEY
BY TRANSDAILY.TRANSDAI.ACCT_NUM
BY TRANSDAILY.TRANSDAI.POSTDATE
BY TRANSDAILY.TRANSDAI.EFFDATE
BY TRANSDAILY.TRANSDAI.TRANS_NARR_1
BY TRANSDAILY.TRANSDAI.SRC_TRANS_CD
BY TRANSDAILY.TRANSDAI.SRC_TRANS_DESCR
BY TRANSDAILY.TRANSDAI.PROD_CLASS_CD
BY TRANSDAILY.TRANSDAI.PROD_DESCR
BY J1.SKIPPAYL.LISTACCT
BY J1.SKIPPAYL.LISTPROC
ON TABLE SUBHEAD
"TransDaily2"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS TransDaily2
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TYPE=TABHEADING,
SIZE=14,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
ENDSTYLE
END
DEFINE FILE TRANSDAILY2
Match/A1V=IF TRANSDAILY2.TRANSDAI.ACCT_NUM EQ TRANSDAILY2.TRANSDAI.LISTACCT THEN 'Y' ELSE '';
TransCodeDesc/A20V=TRANSDAILY2.TRANSDAI.SRC_TRANS_CD | ' ' | TRANSDAILY2.TRANSDAI.SRC_TRANS_DESCR;
END
TABLE FILE TRANSDAILY2
SUM
TRANSDAILY2.TRANSDAI.TRANS_CNT
BY TRANSDAILY2.TRANSDAI.ACCT_DURABLE_KEY
BY TRANSDAILY2.TRANSDAI.ACCT_NUM
BY TRANSDAILY2.TRANSDAI.POSTDATE
BY TRANSDAILY2.TRANSDAI.EFFDATE
BY TRANSDAILY2.TRANSDAI.TRANS_NARR_1
BY TRANSDAILY2.TRANSDAI.TransCodeDesc
BY TRANSDAILY2.TRANSDAI.SRC_TRANS_CD
BY TRANSDAILY2.TRANSDAI.SRC_TRANS_DESCR
BY TRANSDAILY2.TRANSDAI.PROD_CLASS_CD
BY TRANSDAILY2.TRANSDAI.PROD_DESCR
BY TRANSDAILY2.TRANSDAI.Match
ON TABLE SUBHEAD
"TransDaily3"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS TransDaily3
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TYPE=TABHEADING,
SIZE=14,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
ENDSTYLE
END
DEFINE FILE A_ACCT_LOAN_DLY
CRrange/I1=
IF A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE GE 0 AND A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE LE 589 THEN 6
ELSE
IF A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE GE 590 AND A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE LE 619 THEN 5
ELSE
IF A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE GE 620 AND A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE LE 649 THEN 4
ELSE
IF A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE GE 650 AND A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE LE 679 THEN 3
ELSE
IF A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE GE 680 AND A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE LE 729 THEN 2
ELSE
IF A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE GE 730 AND A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE LE 999 THEN 1
ELSE
0;
PmtProt/A50V=IF A_ACCT_LOAN_DLY.ACCOUNT_LOAN.PAYMT_PROTECT_DET_DESCR EQ '**NOT APPLICABLE**' THEN '' ELSE A_ACCT_LOAN_DLY.ACCOUNT_LOAN.PAYMT_PROTECT_DET_DESCR;
END
TABLE FILE A_ACCT_LOAN_DLY
SUM
A_ACCT_LOAN_DLY.LOAN_ACCOUNT_DAILY.SCHED_PAYMT_AMT
BY A_ACCT_LOAN_DLY.ACCOUNT.ACCT_DURABLE_KEY
BY A_ACCT_LOAN_DLY.ACCOUNT.ACCT_NUM
BY A_ACCT_LOAN_DLY.ACCOUNT.ACCT_OPEN_DTE
BY A_ACCT_LOAN_DLY.MEMBER.MBR_FULL_NAME
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.PmtProt
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.PAYMT_PROTECT_DET_DESCR
BY A_ACCT_LOAN_DLY.MEMBER.MBR_NUM
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE_DTE
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CRrange
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE
BY A_ACCT_LOAN_DLY.PRODUCT.PROD_CLASS_CD
BY A_ACCT_LOAN_DLY.PRODUCT.PROD_DESCR
SUM
A_ACCT_LOAN_DLY.LOAN_ACCOUNT_DAILY.SCHED_PAYMT_AMT NOPRINT
BY A_ACCT_LOAN_DLY.ACCOUNT.ACCT_DURABLE_KEY
BY A_ACCT_LOAN_DLY.ACCOUNT.ACCT_NUM
BY A_ACCT_LOAN_DLY.ACCOUNT.ACCT_OPEN_DTE
BY A_ACCT_LOAN_DLY.MEMBER.MBR_FULL_NAME
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.PmtProt
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.PAYMT_PROTECT_DET_DESCR
BY A_ACCT_LOAN_DLY.MEMBER.MBR_NUM
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE_DTE
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CRrange
BY A_ACCT_LOAN_DLY.ACCOUNT_LOAN.CURR_CR_SCORE
BY A_ACCT_LOAN_DLY.PRODUCT.PROD_CLASS_CD
BY A_ACCT_LOAN_DLY.PRODUCT.PROD_DESCR
BY A_ACCT_LOAN_DLY.LOAN_ACCOUNT_DAILY.INT_RATE
BY LOWEST A_ACCT_LOAN_DLY.LOAN_ACCOUNT_DAILY.DAYS_DELIQ
BY LOWEST A_ACCT_LOAN_DLY.LOAN_ACCOUNT_DAILY.DLY_BAL
BY LOWEST A_ACCT_LOAN_DLY.LOAN_ACCOUNT_DAILY.ORIGINAL_LOAN_BAL
ON TABLE SUBHEAD
"AcctLoanDly"
WHERE A_ACCT_LOAN_DLY.DATE_EFFECTIVE.DTE EQ A_ACCT_LOAN_DLY.DATE_EFFECTIVE.PREV_BUS_DAY_DTE;
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE NOTOTAL
ON TABLE HOLD AS AcctLoanDly
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TYPE=TABHEADING,
SIZE=14,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
ENDSTYLE
END
JOIN
LEFT_OUTER PTRANSDAILY.PTRANSDA.ACCT_DURABLE_KEY IN PtransDaily TO MULTIPLE
ACCTLOANDLY.ACCTLOAN.ACCT_DURABLE_KEY IN AcctLoanDly TAG J0 AS J0
END
DEFINE FILE PTRANSDAILY
PaymentTotal/D12.2=PTRANSDAILY.PTRANSDA.TRANS_CNT * J0.ACCTLOAN.SCHED_PAYMT_AMT;
END
JOIN
LEFT_OUTER TRANSDAILY3.TRANSDAI.ACCT_DURABLE_KEY IN TransDaily3 TO MULTIPLE
ACCTLOANDLY.ACCTLOAN.ACCT_DURABLE_KEY IN AcctLoanDly TAG J2 AS J2
END
TABLE FILE TRANSDAILY3
SUM
TRANSDAILY3.TRANSDAI.TRANS_CNT
BY TRANSDAILY3.TRANSDAI.POSTDATE
BY LOWEST J2.ACCTLOAN.MBR_NUM
BY TRANSDAILY3.TRANSDAI.ACCT_NUM
BY J2.ACCTLOAN.MBR_FULL_NAME
BY J2.ACCTLOAN.ACCT_OPEN_DTE
BY J2.ACCTLOAN.CRrange
BY J2.ACCTLOAN.PmtProt
BY J2.ACCTLOAN.PAYMT_PROTECT_DET_DESCR
BY J2.ACCTLOAN.CURR_CR_SCORE_DTE
BY J2.ACCTLOAN.CURR_CR_SCORE
BY J2.ACCTLOAN.PROD_CLASS_CD
BY J2.ACCTLOAN.PROD_DESCR
BY TRANSDAILY3.TRANSDAI.Match
BY TRANSDAILY3.TRANSDAI.TRANS_NARR_1
BY J2.ACCTLOAN.ORIGINAL_LOAN_BAL/P16.2C
BY J2.ACCTLOAN.INT_RATE
BY LOWEST J2.ACCTLOAN.DLY_BAL
BY LOWEST J2.ACCTLOAN.SCHED_PAYMT_AMT
ON TABLE SUBHEAD
"TransDaily4"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE COLUMN-TOTAL
ON TABLE HOLD AS TransDaily4
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
ENDSTYLE
END
DEFINE FILE TRANSDAILY4
PayCount/D12.2=TRANSDAILY4.TRANSDAI.TRANS_CNT * TRANSDAILY4.TRANSDAI.SCHED_PAYMT_AMT;
PaperRange/A10V=
IF EDIT ( TRANSDAILY4.TRANSDAI.CRrange ) EQ '1' THEN '730+'
ELSE
IF EDIT ( TRANSDAILY4.TRANSDAI.CRrange ) EQ '2' THEN '680 - 729'
ELSE
IF EDIT ( TRANSDAILY4.TRANSDAI.CRrange ) EQ '3' THEN '650 - 679'
ELSE
IF EDIT ( TRANSDAILY4.TRANSDAI.CRrange ) EQ '4' THEN '620 - 649'
ELSE
IF EDIT ( TRANSDAILY4.TRANSDAI.CRrange ) EQ '5' THEN '590 - 619'
ELSE
IF EDIT ( TRANSDAILY4.TRANSDAI.CRrange ) EQ '6' THEN '0 - 589'
ELSE 'NA';
END
TABLE FILE TRANSDAILY4
SUM
TRANSDAILY4.TRANSDAI.TRANS_CNT AS 'Number of Skips'
TRANSDAILY4.TRANSDAI.PayCount AS 'Total Amount Skipped'
BY TRANSDAILY4.TRANSDAI.PROD_CLASS_CD AS 'Product Class'
BY TRANSDAILY4.TRANSDAI.PROD_DESCR AS 'Product Descr'
ON TABLE SUBHEAD
"Loan Skip Payment COVID19"
ON TABLE SUBFOOT
"Filters:"
"Posted date GE 3/16/2020"
"Transaction code EQ '309' or '310'"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SUMMARIZE
ON TABLE PCHOLD FORMAT XLSX OPEN
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TITLETEXT='Summary',
$
TYPE=TABHEADING,
SIZE=14,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=TABFOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=TABFOOTING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
ENDSTYLE
END
TABLE FILE PTRANSDAILY
SUM
PTRANSDAILY.PTRANSDA.TRANS_CNT AS 'Number of Skips'
J0.ACCTLOAN.PaymentTotal AS 'Total Amount Skipped'
BY PTRANSDAILY.PTRANSDA.PROD_CLASS_CD AS 'Product Class'
BY PTRANSDAILY.PTRANSDA.PROD_DESCR AS 'Product Descr'
ON TABLE SUBHEAD
"Loan Skip Payment COVID19 as of ON TABLE SUBFOOT
"Filter:"
"Posted Date EQ Previous Business Day"
"Transaction code EQ '309' or '310'"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SUMMARIZE
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TITLETEXT='Previous Day Summary',
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD+ITALIC,
JUSTIFY=CENTER,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
SIZE=10,
$
TYPE=TABFOOTING,
LINE=2,
SIZE=10,
$
TYPE=TABFOOTING,
LINE=3,
SIZE=10,
$
ENDSTYLE
END
TABLE FILE TRANSDAILY4
SUM
TRANSDAILY4.TRANSDAI.TRANS_CNT AS 'Number of Skips'
TRANSDAILY4.TRANSDAI.PayCount/D12.2C AS 'Total Amount,Skipped'
BY HIGHEST TRANSDAILY4.TRANSDAI.PaperRange AS 'Credit Score,Range'
ON TABLE SUBHEAD
"Loan Skip Payment COVID19 - Credit Score"
ON TABLE SUBFOOT
"Filters:"
"Posted date GE 3/16/2020"
"Transaction code EQ '309' or '310'"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SUMMARIZE
ON TABLE PCHOLD FORMAT XLSX
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TITLETEXT='Credit Score Summary',
$
TYPE=TABHEADING,
LINE=1,
SIZE=12,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=TABFOOTING,
LINE=2,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=2,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
TYPE=TABFOOTING,
LINE=3,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
LINE=3,
OBJECT=TEXT,
ITEM=1,
SIZE=10,
$
ENDSTYLE
END
TABLE FILE TRANSDAILY4
SUM
TRANSDAILY4.TRANSDAI.TRANS_CNT AS 'Number of Skips'
TRANSDAILY4.TRANSDAI.PayCount/D12.2C AS 'Total Amount Skipped'
BY TRANSDAILY4.TRANSDAI.POSTDATE AS 'Posted Date'
BY LOWEST TRANSDAILY4.TRANSDAI.PROD_CLASS_CD AS 'Product Class'
BY TRANSDAILY4.TRANSDAI.PROD_DESCR AS 'Product Descr'
BY TRANSDAILY4.TRANSDAI.MBR_NUM AS 'Member Number'
BY TRANSDAILY4.TRANSDAI.PaperRange AS 'Credit Score,Range'
BY TRANSDAILY4.TRANSDAI.CURR_CR_SCORE AS 'Credit Score'
BY TRANSDAILY4.TRANSDAI.CURR_CR_SCORE_DTE AS 'Credit Score,Date'
BY TRANSDAILY4.TRANSDAI.ACCT_NUM AS 'Account Number'
BY TRANSDAILY4.TRANSDAI.PmtProt AS 'Payment,Protection'
BY TRANSDAILY4.TRANSDAI.Match AS 'Pre-approved'
BY TRANSDAILY4.TRANSDAI.ACCT_OPEN_DTE AS 'Open Date'
BY LOWEST TRANSDAILY4.TRANSDAI.ORIGINAL_LOAN_BAL/P16.2C AS 'Original Amount'
BY LOWEST TRANSDAILY4.TRANSDAI.DLY_BAL AS 'Daily Balance'
BY LOWEST TRANSDAILY4.TRANSDAI.INT_RATE/P8.2 AS 'Interest Rate'
BY LOWEST TRANSDAILY4.TRANSDAI.SCHED_PAYMT_AMT AS 'Scheduled,Payment Amount'
ON TABLE SUBHEAD
"Loan Skip Payment COVID19 - Detail"
ON TABLE SUBFOOT
"Filters:"
"Post date GE 3/16/2020"
"Transaction code EQ '309' or '310'"
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET ASNAMES ON
ON TABLE SET BYDISPLAY ON
ON TABLE SUMMARIZE
ON TABLE PCHOLD FORMAT XLSX CLOSE
ON TABLE SET XLSXPAGESETS ON
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/WFC/Repository/STCU_Shared_Content/Style_Sheets/angular.sty,
$
TITLETEXT='Detail',
$
TYPE=DATA,
BACKCOLOR='WHITE',
$
TYPE=TABHEADING,
SIZE=14,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
TYPE=TABFOOTING,
SIZE=10,
STYLE=BOLD+ITALIC,
JUSTIFY=LEFT,
$
ENDSTYLE
END


WebFOCUS 8
Windows, All Outputs
March 30, 2020, 02:53 PM
FP Mod Chuck
Rozalind

Now that I see your code I agree that it looks correct, the message XLSX FILE SAVED is curious because that is a message you will get when it is ON TABLE HOLD. When you run it outside of ReportCaster does it generate a XLSX file that opens for you?


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
March 30, 2020, 03:01 PM
Rozalind
Yeah, when I run it outside of report caster an excel report is produced just like I would expect.


WebFOCUS 8
Windows, All Outputs
March 30, 2020, 03:11 PM
FP Mod Chuck
Rozalind

One thing you could try is in the schedule under the task check the Override the format specified and choose EXL07 (XLSX). I know it seems silly to choose the same format but I have seen this fix weird behavior before.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
March 30, 2020, 03:29 PM
Rozalind
OMG! That did it! THANK YOU!!!


WebFOCUS 8
Windows, All Outputs
March 30, 2020, 04:19 PM
John_Edwards
Yeah, that override format is just something you gotta do with the 8.x versions of ReportCaster. Only for Excel as best I can tell.



March 31, 2020, 07:17 AM
StuBouyer
quote:
Yeah, that override format is just something you gotta do with the 8.x versions of ReportCaster. Only for Excel as best I can tell.


For us, regular Excel works fine it is only the compound Excel that seems to have an issue.

One of the quirks of ReportCaster in 8x


WebFOCUS 8.2.03 (8.2.06 in testing)