Focal Point Banner


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.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]How do you change the default no results message

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[Solved]How do you change the default no results message
 Login/Join
 
Platinum Member
posted
How do you change the default no results message? This is the message that reads:

Your request did not return any output to display.
Possible causes:
- No data rows matched the specified selection criteria.
- Output was directed to a destination such as a file or printer.
- An error occurred during the parsing or running of the request.

I want to add something about if you see this message, please send the entire message to IT support for resolution.

This message has been edited. Last edited by: Geri,




Prod: WebFOCUS 7.7.05 OS:Linux; Upgrading to: WebFOCUS 8.1.05 OS:Windows; Outputs: HTML, PDF, Excel; Adapters: SAP, MySQL, Oracle incl Report Caster
 
Posts: 102 | Location: Cincinnati, Oh USA area | Registered: November 02, 2006Report This Post
Gold member
posted Hide Post
U can give ur own message, if no rows are retrieved for ur selection as below:

Give the below code at the end of ur report

  
-RPTEND
-IF &LINES EQ 0 THEN GOTO NODATA;
-ELSE GOTO THEEND;

-NODATA
-SET &ERRMSG1 = 'There is no data retrieved for the selected parameters.';
-*****U can give ur entered I/P parameter bottom *******-
-SET &ERRMSG2 = 'DATE RANGE    : ' | &STARTDT | ' to ' | &ENDDT;';
-SET &ERRMSG3 = 'Try again with new set of values';
-GOTO ERRORMSG

-ERRORMSG
-HTMLFORM BEGIN
<HTML>
<BODY>
<P> &ERRMSG1 </P>
<P> &ERRMSG2 </P>
<P> &ERRMSG3 </P>
</BODY>
</HTML>
-HTMLFORM END
-GOTO THEEND

-THEEND


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
Gold member
posted Hide Post
Found this with some research:

 

http://documentation.informati.../wf77sec/wf77sec.pdf
 


Start on page 336.

In the file look for "err_42" message. There are several messages in the file mentioned.


WF 7.6.10, Windows, PDF, Excel
 
Posts: 75 | Location: Dallas, TX | Registered: February 12, 2004Report This Post
Gold member
posted Hide Post
quote:
Originally posted by Mary Watermann:
Found this with some research:

 

http://documentation.informati.../wf77sec/wf77sec.pdf
 


Start on page 336.

In the file look for "err_42" message. There are several messages in the file mentioned.


Thanks for sharing the doc...


WebFocus Version 7.7.05
Windows, HTML/PDF/EXL2K/AHTML
 
Posts: 63 | Registered: January 12, 2011Report This Post
Virtuoso
posted Hide Post
This is the one I've been using for years in the ENtemplate.xml. Simple, but better than the default (IMHO):
    <template name='error_42'>
         <![CDATA[
<HTML>
<HEAD>
<TITLE>No Results Returned</TITLE>
<style type='text/css'>
     div.msgstyle {
          height:20px;
          font-size:12px;
          color:#333;
          font-family:"Lucida Grande",Verdana;
          padding:7px 5px 7px 5px;
          border-top:1px solid #ddd;
          border-bottom:1px solid #ddd;
          text-align: center;
     }
     div.msgerror {
          font-size:12px;
          font-family:Arial,sans-serif;
          color:#444444;
          background-color:#EEEEEE;
          border-style:solid;
          border-color:#e6e6e6;
          border-width:1px;
          align: center;
     }
     div.msgerrorhead {
          font-size:12px;
          font-family:Arial,sans-serif;
          color:#444444;
          background-color:#EEEEEE;
          border-style:solid;
          border-color:#8a8a8a;
          border-width:1px;
          align: center;
     }
</style>
<script id='il1' type=text/javascript>
function window_onload() {
     var focexec = '<insertvariable _executing_fex_name />';
     var domain = '<insertvariable IBIMR_domain />';
     if (document.getElementById('fmsg').innerHTML.indexOf('0 NUMBER OF RECORDS IN TABLE=        0  LINES=      0') != -1) {
          document.getElementById('dmsg').innerHTML = 'No records were returned that match your criteria!<br>Please change your request and try again.';
          document.getElementById('dmsg').innerHTML += '<br><br>Report: <b>' + focexec + '</b>';
          if ( domain != '' )
               document.getElementById('dmsg').innerHTML += ' In Domain: <b>' + domain + '</b>';
     } else {
          document.getElementById('dmsg').innerHTML = 'An error has happened with Report: <b>' + focexec + '</b>';
          if ( domain != '' )
               document.getElementById('dmsg').innerHTML += ' In Domain: <b>' + domain + '</b>';
          document.getElementById('dmsg').innerHTML += '<br><br>Please contact support and provide the error message below.';
          document.getElementById('emsg').style.visibility = 'visible'; 
     }
}
</script>
<script for=window eventname="onload">window.onload = function() { window_onload(); }</script>
</Head>
<Body>
<div id='dmsg' class='msgstyle'>
<inserttext err_42_explain />
</div>
<br>
<div id='emsg' style='visibility: hidden;'>
<div id='ehead' class='msgerrorhead'>
Error Message:
</div>
<div id='femsg' class='msgerror'>
<pre id='fmsg'><insertvariable html_no_output_msg /></pre>
</div>
</div>
</Body>
</HTML>         ]]>
   </template>  


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Virtuoso
posted Hide Post
Geri,

If all you want is that additional short message, then very simply, at the end of your report:
 
-RUN 
-RPTEND
-IF &LINES GT 0 GOTO #OUT;
-TYPE if you see this message, please send the entire message to IT support for resolution
-#OUT


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Platinum Member
posted Hide Post
Thanks all, lots of great suggestions.

I prefer to edit the Default message since it is so bold and that is the first thing the user see and frequently all they see at the bottom of the screen. They do not always page down when they see the message. For now, I added a message based on 0 lines as suggested here.

As for the default message, I changed the message (per your suggestion) but the original message still appears. I might need to contact IBI on that issue.




Prod: WebFOCUS 7.7.05 OS:Linux; Upgrading to: WebFOCUS 8.1.05 OS:Windows; Outputs: HTML, PDF, Excel; Adapters: SAP, MySQL, Oracle incl Report Caster
 
Posts: 102 | Location: Cincinnati, Oh USA area | Registered: November 02, 2006Report This Post
Virtuoso
posted Hide Post
Make sure you change the correct file:

ibi/WebFOCUS77/client/wfc/etc/ENtemplate.xml

Then restart the web application.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Report This Post
Virtuoso
posted Hide Post
The messages, in English, are in file \ibi\WebFOCUS77\client\wfc\etc\ENwebfoc_strings.lng
lines 99 to 103

You'll have to remember to update this file after an update...


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Platinum Member
posted Hide Post
Re-starting the client forced the changes to the default message to take.

Thank you all for the suggestions.




Prod: WebFOCUS 7.7.05 OS:Linux; Upgrading to: WebFOCUS 8.1.05 OS:Windows; Outputs: HTML, PDF, Excel; Adapters: SAP, MySQL, Oracle incl Report Caster
 
Posts: 102 | Location: Cincinnati, Oh USA area | Registered: November 02, 2006Report This Post
Member
posted Hide Post
Thanks for the html code for the error_42 template Daryl

We are on 8.0.0.4 and needed to change the the reference to element id 'fmsg to emsg

SO we change this line

if (document.getElementById('fmsg').innerHTML.indexOf('0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0') != -1)

to

if (document.getElementById('emsg').innerHTML.indexOf('0 NUMBER OF RECORDS IN TABLE= 0 LINES= 0') != -1)


Webfocus 8.0
HTML
 
Posts: 20 | Location: Guelph, Ontario | Registered: May 17, 2013Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [Solved]How do you change the default no results message

Copyright © 1996-2020 Information Builders