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] Report Caster With Excel output not sending email
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Report Caster With Excel output not sending email
 Login/Join
 
Member
posted
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
 
Posts: 12 | Registered: August 19, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1871 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
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
 
Posts: 12 | Registered: August 19, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1871 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
Yeah, when I run it outside of report caster an excel report is produced just like I would expect.


WebFOCUS 8
Windows, All Outputs
 
Posts: 12 | Registered: August 19, 2015Reply With QuoteReport This Post
Virtuoso
posted Hide Post
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
 
Posts: 1871 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
OMG! That did it! THANK YOU!!!


WebFOCUS 8
Windows, All Outputs
 
Posts: 12 | Registered: August 19, 2015Reply With QuoteReport This Post
Master
posted Hide Post
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.



 
Posts: 976 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
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)
 
Posts: 251 | Location: Melbourne, Australia | Registered: February 07, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Report Caster With Excel output not sending email

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