 |
|||||
|
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 [SHARING] Customize No Data Message
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SHARING] Customize No Data Message Read-Only TopicGo | Search | Notify | Tools |
| [SHARING] Customize No Data Message | Login/Join |
| Gold member |
Can someone point me to the file or method to customize the text displayed when no data is returned? I know about the empty report option, I want to customize the text. I am looking to do this for a large body of IA users, so I am looking at a server-wide solution. This is not for reports produced in Developer Studio, so I can't introduce custom code per report. I have already read the following posts, which don't suggest a way to do this for IA users: http://forums.informationbuild...171078331#2171078331 http://forums.informationbuild...1077331/r/4951077331This message has been edited. Last edited by: TOM SCHULTE, | ||
|
| Expert |
Tom, Take a look at this thread: Change MR message "No Html Output!", particularly to what dhagen specifies. File C:\ibi\WebFOCUS77\client\wfc\etc\ENtemplate.xml contains the html that is displayed for different errors. Look for "error_42". You can replace the html between the HTML tags. MAKE A BACKUP FIRST! You will see proprietary inserttext tags - these are to insert text based on the selected language if multi-language is on. These text strings are contained in file C:\ibi\WebFOCUS77\client\wfc\etc\ENwebfoc_strings.lng. You don't need to use these text strings, unless you want to. If so, you can change the text in XXwebfoc_strings.lng, where XX is EN or FR or ES, etc. 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 | |||
|
| Gold member |
Thanks, Francis! | |||
|
| Gold member |
Hmm, I can't get the reports made by my IA users to return anything but the empty report. I have put I haven't been able to figure out how to get us back to the EOF report with "EDA no data" to appear. I just get the empty report (headers, no rows). I have tried placing "SET EMPTYREPORT = OFF" in the server profile (edapsprof.prf) and the FEX file we are using as our indicated _site_profile with no change in behavior in either case even after a restart of the workspace. Any one have any ideas? I have looked for relevant configuration settings... | |||
|
| Expert |
I'm a bit confused by your last post, particularly "I have put I haven't been able to figure out how to get us back to the EOF report with "EDA no data" to appear." Are you getting an empty report even when there is data? Did this start happening since you made a change to the configuration file? SET EMPTYREPORT={ANSI|ON|OFF} ANSI - Produces a single-line report and displays the missing data character or a zero if a COUNT is requested. In each case, &RECORDS will be 0, and &LINES will be 1. If the SQL Translator is invoked, ANSI automatically replaces OFF as the default setting for EMPTYREPORT. ON - Produces an empty report (column headings with no content). This was the default behavior in prior releases. OFF - Produces no report output. OFF is the default value except for SQL Translator requests. When the SQL Translator is invoked, ANSI replaces OFF as the default setting for the EMPTYREPORT parameter, so the results are the same as for the ANSI setting. 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 | |||
|
| Gold member |
Sorry, no I have made some reports that always return zero rows in order to test, but no matter where I put SET EMPTYREPORT = OFF, I always get an empty report (column headings, no rows). What I want, is the text "... EDA no data" so I can test customizing it. | |||
|
| Platinum Member |
I don't know if this helps but you can add a message to the Empty Report like this: TABLE FILE CAR PRINT COUNTRY CAR WHERE COUNTRY EQ 'CANADA' ON TABLE SET EMPTYREPORT ON END -IF &RECORDS EQ 0 THEN GOTO XXX ELSE GOTO ENDD; -XXX -HTMLFORM BEGIN No Records Found For Your Selection -HTMLFORM END -EXIT -ENDD -EXIT You can do whatever you like between the 'HTMLFORM' tags WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF | |||
|
| Gold member |
Thnks, Alex That would be great if I were writing WebFOCUS code in Developer Studio. I am supporting InfoAssist users that can't even use editor. So I am looking for something to configure or do server-side that would affect all IA users. I have tried putting "SET EMPTYREPORT = OFF" in edasprof and our server-level site profile fex, to no effect. Either I am missing some configuration spot, or maybe this has something to do with our upgrdrade from 7.7.03 to 7.7.04M | |||
|
| Expert |
I didn't know what "IA" was until now - I have no experience with Info Assist, so I don't know if the suggestion I made will work. 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 | |||
|
| Gold member |
Francis - I appreciate your help all the same, it ends up this is a change due to the 7.7.04M version we are on. Apparently for WF8 (which requires the 7.7.04 server, there is coming a different set of rules for EMPTYREPORT. It certainly looks like it is affecting my IA users, but I don't know that reports developed in Studio will be affected. If any are interestedl, I can update here when I get some resolution or final answer, IBI CASE# 82012555) | |||
|
| Expert |
I've been warned to stay away from v7.7.04M! 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 | |||
|
| Gold member |
Well, we're multi-tenant SaaS, and in my opinion you can't fully express multi-tenant SaaS BI on 7.7.03 and you have to have 7.7.04M to connect up WF8 cleints where the multi-tenant SaaS is more fully realized... So, we really have no choice... By and large our WF8 beta is exciting and the whole product by and large looks great, for us. | |||
|
| Platinum Member |
This file [drive]:\ibi\WebFOCUS77\client\wfc\etc\ENwebfoc_strings.lng contains messages that are returned for various conditions. You can alter the text for Message 42, returned when there is no data. Keep in mind that changing this file will have to be repeated when you upgrade. WF 7.7.04, WF 8.0.7, Win7, Win8, Linux, UNIX, Excel, PDF | |||
|
| Powered by Social Strata |
 | Please Wait. Your request is being processed... |
Read-Only TopicFocal Point Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SHARING] Customize No Data Message
Focal Point Forums WebFOCUS/FOCUS Forum on Focal Point [SHARING] Customize No Data MessageCopyright © 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 |