Change MR message "No Html Output!"

You can do a

SET EMPTYREPORT = ON

and that will make a blank report come up.

You could also check your rowcount before you present your results and then go to a "canned" message that says no results or something spiffy like that.

TABLE FILE CAR
PRINT MODEL NOPRINT
WHERE RECORDLIMIT EQ 1
HEADING
"There are no changes that meet your parameters."
"please revise your selections and re run the report"
END

Production: 7.6.6 WF Server <=> 7.6.6 WF Client <=> 7.6.6 Dev Studio
Testing: <none>
Using MRE & BID. Connected to MS SQL Server 2005
Output Types: HTML, Excel, PDF

Posts: 230 | Location: Wichita, KS | Registered: May 27, 2005

Ignored post by Trav posted

Gold member

posted

Where would I add this in the Reporting Object?

Posts: 64 | Location: Denver | Registered: July 20, 2005

Ignored post by Joan Williamson-Kelly posted

Gold member

posted

OK,

I found how to use the EMPTYREPORT command in an MR Reporting Object.

Open the Reporting Object in the Reporting Object Tool through Dev Studio.

Edit the "Other" item.

Type the command in the editor:
SET EMPTYREPORT = ON

Close and save the "Other" editor and the reporting object.

Now, when a report runs and returns no lines, the headings display with no data, instead of the "No HTML Output!" and all of the code.

That will do!

Posts: 64 | Location: Denver | Registered: July 20, 2005

Ignored post by Joan Williamson-Kelly posted

Anatess

Guru

posted

Hi Joan,
Just another idea...
I normally do this at the end of my table requests:

-IF &FOCERRNUM NE 0 GOTO DBERR;
-IF &RECORDS NE 0 GOTO ENDFEX;
-HTMLFORM NO_RECORDS
-GOTO ENDFEX
-DBERR
-HTMLFORM REPORTERR
-ENDFEX

Then I have NO_RECORDS.htm that contains the empty report message. The cool thing about this is if an empty report is not ideal, then you can add links/instructions on what to do next. Same for REPORTERR.htm. It usually links to the tech support contact page.

WF 8.1.05 Windows

Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006

Ignored post by Anatess posted

Expert

posted

Anatess,

How does one stick that code in a Reporting Object - that is the question.

I don't know if this has changed for versions post 5.3.2, but there is an HTML file that contains all or most of the client response messages at this location: Drive:\ibi\client53\home\etc\xxib00e.html where xx is the language your software is set to - English: enib003e.html.

Look for the text "No HTML Output" - 'error' 00042. Each 'error' has its' own HTML section - you can replace the existing HTML with whatever you want (probably within limits - I wouldn't do crazy JavaScript, DHTML, ASP stuff). Make a backup of the file before modifying it!

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

susannah

Expert

posted

oh my..
FrankieMartini you've just opened up a gigantic box of play toys...we can change the error messages to say whatever we want them to say?...
Oh i'm going to have fun for the rest of the day...

joan, you can also put that in your edasprof..i find it so uniformly useful that i put things like that in my edasprof, then my users can be independent in building their own reporting objects and have consistent results.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Expert

posted

Susannah,

I've customized the error messages for these errors:

00042 – No HTML Output
32033 – Unrecognized User ID
32034 – Invalid Password
32035 – Password has expired
32063 – User ID access has been revoked
32076 – WebFOCUS session has expired

We're laughing...

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Prarie

Virtuoso

posted

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

Posts: 1903 | Location: San Antonio | Registered: February 28, 2005

Ignored post by Prarie posted

susannah

Expert

posted

but what did you customize them to?
00042 – you have to pay extra for this.
32033 – who the sam hill are you?
32034 – no, gimme the password for your bank account.
32035 – that one is so last millenium!
32063 – fat chance!
32076 – I'm napping now.

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Expert

posted

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Gold member

posted

Wow! I had no idea what I had started.

So to summarize:

I can change the message/behavior for all of MR on the server in:

1) drive:\ibi\srv76\home\etc\enib00e.html
(Our environment is in WF 7.6.1)

2) edasprof
SET EMPTYREPORT=ON

I'll experiment with these.

Posts: 64 | Location: Denver | Registered: July 20, 2005

Ignored post by Joan Williamson-Kelly posted

Tony A

Expert

posted

quote:
I'll experiment with these.

... after taking a backup of course

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Anatess

Guru

posted

Hey Francis, Tony,
Does that also control the EDASERVE crash error? I ran a fex yesterday where I forgot to put COMPUTE... like this:

TABLE FILE whatever
SUM NEWFIELD/D12.2=FIELD1 + FIELD2; AS 'TITLE'
...

And I got that EDASERVE crash message. Took me forever to find the problem with several calls to wf admin who must now think i deprived a village of their idiot.

WF 8.1.05 Windows

Posts: 333 | Location: Orlando, FL | Registered: October 17, 2006

Ignored post by Anatess posted

Glenda

Guru

posted

Joan,

I have a lot of user that think the report is "broke" if they get a report that says "No HTML Output".

We use the following code to generate a message stating "No records found that match your parameters." and they quit reporting "broke" reports.

TABLE FILE CAR
PRINT COUNTRY
CAR
MODEL
DEALER_COST
RETAIL_COST
WHERE COUNTRY EQ 'GERMANY'
ON TABLE HOLD AS FDATA
END

-*******************************************************************************
-* TEST FOR EMPTY DATASET
-IF &LINES EQ 0 THEN GOTO BLANKER ELSE GOTO CONT;
-*******************************************************************************
-CONT
TABLE FILE FDATA
PRINT COUNTRY
CAR
MODEL
DEALER_COST
RETAIL_COST
END
-EXIT
-BLANKER
DEFINE FILE CAR
NOREC/A50='No records found that match your parameters.';
END
TABLE FILE CAR
PRINT NOREC AS ''
BY COUNTRY NOPRINT
WHERE RECORDLIMIT EQ 1
END
-EXIT

Sometimes users can be a headache!

Glenda

In FOCUS Since 1990
Production 8.2 Windows

Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004

Ignored post by Glenda posted

Expert

posted

Anatess, I'm not sure. If the EDASERVE crash message is one of the ones in the enib003e.html file, then you could change it.

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Gold member

posted

Glenda,

Thanks for the additional idea for a way to handle zero record results sets in a fex. I'll try that in my fexes.

Joan

Posts: 64 | Location: Denver | Registered: July 20, 2005

Ignored post by Joan Williamson-Kelly posted

Darin Lee

Virtuoso

posted

we use Glenda's technique frequently to help users overcome the ID10T error (they put in bad parameter values and expect to get valid results.)

A note on editing the HTM file containing error messages - remember that this is a system file and any patches or updates to your software will overwrite your changes. That being said, we still do things like this - just need to have them documented as part of any software updates so we remember what and where the custom modifications were made.

Regards,

Darin

In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat

Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007

Ignored post by Darin Lee posted

Jaywill

Member

posted

For some reason, modifying enib00e.html did not work at our site.
Instead, I had to change C:\ibi\WebFOCUS761\client\wfc\etc\ENwebfoc_strings.lng

WF 8.0.08 ... Windows Server 2008

Posts: 21 | Registered: January 27, 2006

Ignored post by Jaywill posted

RSquared

Guru

posted

You can also add the attached code as a .fex that you include at the end of your focexec.
"/-RUN
-IF &FOCERRNUM NE 0 GOTO FOCERROR;
-IF &LINES EQ 0 GOTO NODATA;

-EXIT
-FOCERROR
-HTMLFORM BEGIN

A FOCERROR of &FOCERRNUM was returned by your program.

Please contact the Help Desk (7-8227) immediately.

-HTMLFORM END
-EXIT
-NODATA
-HTMLFORM ZeroRecords

END
-EXIT
/"

You also have t oinclude an html page so that you can send back a nice error page.

WF 7.6.11
Oracle
WebSphere
Windows NT-5.2 x86 32bit

Posts: 398 | Registered: February 04, 2008

Ignored post by RSquared posted

dhagen

Virtuoso

posted

Jaywill,

That didn't work for you in 761 because it no longer exists in 761 (sorry Francis, all that beautiful work is going to have to change when you upgrade). The way these messages are generated in 76 has changed to a couple of language specific files. One for the message, and one for the complete html that is generated. It makes a lot more sense now ... to me anyway. You can edit the complete html code block for the no data message.

Look into ENtemplate.xml and ENwebfoc_strings.lng in your client/wfs/etc directory.

Make backups

"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, 2004

Ignored post by dhagen posted

Waz

Expert

posted

Sometimes the best way is the hard way.

We always check &LINES to see of there are no records at appropriate points in the fex to show either a nice error message or a -HTMLFORM.

We also always check &FOCERRNUM after every TABLE FILE to handle errors.

Its more coding but is safer in the long run, in particular with upgrades.

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006

Ignored post by Waz posted