 |
|||||
|
As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Join the TIBCO Community
Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community. | |||||
Focal Point 
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point How can Report Caster send no report if no data?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point How can Report Caster send no report if no data? Read-Only TopicGo | Search | Notify | Tools |
| How can Report Caster send no report if no data? | Login/Join |
| Platinum Member |
Hi, I have a report that rarely contains data, but that is emailed daily to users. They have requested that they only want to receive the report if it contains data. At present they receive an Excel document with just the headings present. Any pointers would be really appreciated. Thanks Mark. WebFocus 765. iSeries v5r4 | ||
|
| Guru |
Put in some code: IF &RECORDS EQ 0 GO TO SOMELABEL -SOMELABEL -INCLUDE NADAMSG (a focexec with imbedded HTML saying there is no data for the day) I'll send an example to you. Sandy Kadish Dev: 8.2.04- PostgreSQL Test: 8.2.04 - PostgreSQL Prod: 8.2.04 - PostgreSQL | |||
|
| Expert |
Mark, I suppose you could insert a pre-processing fex to check the number of records that the report would contain and thne exit focus if the return is zero records. I can't remember whether the pre-processing fex can abort the process, but it's worth trying to see. T
| |||||||||
|
| Expert |
Mark, Tony, Used in conjunction with the &&KILL_RPC variable, this is exactly what the Pre-Process fex can be used for - to verify that the main report fex should run or not. Look for KILL_RPC in the online docs. Cheers, Francis  Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
Thanks Francis, I knew there was something. It just needed the grey cells to work though - and they're not fully working at the moment  T
| |||||||||
|
| Expert |
The Guinness isn't helping?  Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Expert |
That will be the reason then, I haven't had any since Friday 8th! | |||
|
| Platinum Member |
Mark : As long as the final TABLE FILE step that creates the Excel-sheet is being executed, you will keep receiving an empty-sheet attached email. If it is the only step in your fex, then try putting in another step prior to it that writes to a Hold file. If (&RECORDS = 0) on that step, then -EXIT else, execute the Excel creating step. And Francis, I am not sure if we have to tweak something in the way we use the pre-processing routine to NOT get an error email. The way we have it, FOCUS treats the execution of KILL_RPC as an error and sends out an email to recepients on the "NOTIFY ON ERROR" list. Of course, it is usually the programming staff here and no email is sent to the end-users. Is this something that we can supress and not be bothered with those un-necessary emails ? Thank you, Sandeep Mamidenna ------------------------------------------------------------------------------------------------- Blue Cross & Blue Shield of MS WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !!  | |||
|
| Expert |
Sandeep, Read this thread, Susannah has a suggestion that might avoid the email message: https://forums.informationbuilders.com/eve/forums/a/tpc/...171028331#5171028331 As well, the message only gets sent to the Report Caster Administrator, so it shouldn't be a real problem. Cheers, Francis Give me code, or give me retirement. In FOCUS since 1991 Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server | |||
|
| Platinum Member |
Thanks so much for your note Francis. Goooooooooooooooood day !! Sandeep Mamidenna ------------------------------------------------------------------------------------------------- Blue Cross & Blue Shield of MS WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! | |||
|
| Platinum Member |
Thanks for all the suggestions everyone! I thought I would give Susannah's method a try, in the post that Francis found (thanks Francis): https://forums.informationbuilders.com/eve/forums/a/tpc/...171028331#5171028331 easier.... Do your Fex in 2 steps. 1) create the exact hold file from which the report would be created. 2) test the &LINES variable for value if &LINES EQ 0 GOTO ENDOFJOB; 3) table file hold write your nice report This is easy and works like a charm. I do it 8zillion times a day. If there is no data, the fex bypasses the nice fancy html report generator; If there is no html output, the RC log will show NO REPORT TO DISTRIBUTE and nothing goes to anybody. ok ok...it was 3 steps. This works fine, apart from now myself and another developer get a failure message, as we are the Report Caster Administrators. The only options for the receipt of email are NEVER/ALWAYS/ON ERROR and I guess this is treated as 'ON ERROR'? It would be great if I could find a way to turn the error flag off in this case, as we would still want to receive notification if the report has genuinely failed, but not if it is just empty! Thanks Mark WebFocus 765. iSeries v5r4 | |||
|
| Guru |
This sounds like an opportunity to use an alert. Check out the manuals for that. ttfn, kp Access to most releases from R52x, on multiple platforms. | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point How can Report Caster send no report if no data?
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point How can Report Caster send no report if no data?Copyright © 1996-2020 Information Builders
| View $GS_USERNAME's Public Profile |
| Add $GS_USERNAME to my Ignore List |
| View Recent Posts by $GS_USERNAME |
| Notify me of New Posts by $GS_USERNAME |