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 TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.
From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
Request access to the private WebFOCUS User Group (login required) to network with fellow members.
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.
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:
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
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...
WebFOCUS 7.7.04M/8001 Windows Server 2008 Excel, PDF, HTML, AHTML
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
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.
WebFOCUS 7.7.04M/8001 Windows Server 2008 Excel, PDF, HTML, AHTML
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
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003
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
WebFOCUS 7.7.04M/8001 Windows Server 2008 Excel, PDF, HTML, AHTML
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)
WebFOCUS 7.7.04M/8001 Windows Server 2008 Excel, PDF, HTML, AHTML
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.
WebFOCUS 7.7.04M/8001 Windows Server 2008 Excel, PDF, HTML, AHTML
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
Posts: 175 | Location: Pomona, NY | Registered: August 06, 2003