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     EMPTYREPORT=ON and FOOTERS

Read-Only Read-Only Topic
Go
Search
Notify
Tools
EMPTYREPORT=ON and FOOTERS
 Login/Join
 
Platinum Member
posted
We have observed that when a report run with EMPTYREPORT 'ON' and it is indeed "empty", i.e LINES=0, that the HEADERS are displayed but not the FOOTERS.

Is this as designed? Do others observe this behavior, too?

Without the footers, the empty report appears incomplete.


WIN/2K running WF 7.6.4
Development via DevStudio 7.6.4, MRE, TextEditor.
Data is Oracle, MS-SQL.
 
Posts: 154 | Location: NY | Registered: October 27, 2005Report This Post
Virtuoso
posted Hide Post
SET EMPTYREPORT = ANSI Should get you a footer.


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Guru
posted Hide Post
Chris,

According to the documentation, if no records satisfy the report selection criteria, you can choose to display or print anempty report, that is, the report without data but including column titles, a report heading (if one was specified in the report request), and a page heading (if one was specified).

Which by the way is exactly what it does. My users where constantly asking us to verify that this was correct. So I began using the following routing:

TABLE FILE CAR
PRINT COUNTRY
      CAR
      MODEL
WHERE MODEL EQ 'TUCKER'
ON TABLE HOLD AS FDATA
END
-*
-IF &LINES EQ 0 GOTO NODATA;
-*
TABLE FILE FDATA
PRINT COUNTRY
      CAR
      MODEL
-GOTO STYLER
-*
-EXIT
-*
-NODATA
DEFINE FILE CAR
MESSAGE1/A50 = 'NO RECORDS MET THE CRITERIA OF THIS REPORT';
MESSAGE2/A75 = 'THE REPORT REQUEST ALL RECORDS WHERE MODEL EQUALS TUCKER';
END
-*
TABLE FILE CAR
PRINT MODEL NOPRINT
      MESSAGE1 AS '' OVER
      MESSAGE2 AS ''
WHERE RECORDLIMIT EQ 1
-GOTO STYLER
-*
-STYLER
HEADING CENTER
"TEST CODE"
-*
FOOTING
"Data from"
"Produced by :     Created on :  "
""
ON TABLE SET STYLE *
     UNITS=IN,
     LEFTMARGIN=0.000000,
     RIGHTMARGIN=0.000000,
     TOPMARGIN=0.000000,
     BOTTOMMARGIN=0.000000,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
     PAGECOLOR=RGB(172 192 233),
$
TYPE=REPORT,
     TITLETEXT='TEST CODE',
$
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END
-EXIT


What we wou't do to please our users.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Guru
posted Hide Post
Prairie,

That works great! Winky

Unfortunately, my users are spoiled. They don't want to have to use their grey matter if they don't have to. So alas, I'll stick to my routine. Frowner


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Expert
posted Hide Post
Glenda,

So what makes your Users different to "normal" ones then? Wink

T



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, 2004Report This Post
Guru
posted Hide Post
Tony,

On that statement, I have two comments:

1) How can you use normal and user in the same sentence.

2) Obviously you do not have users who claim to have a degree in "computers" and can not tell you where their "desktop" is.

If you do, please so I don't feel so alone. Big Grin


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Guru
posted Hide Post
OOPS

Please share so I don't feel so alone.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Virtuoso
posted Hide Post
I recently had to attend an ITIL course
Information Technology Infrastructure Library.
Which is a framework of best practices for IT customer service.
In it - we were scolded that there were no Stupid Users or SU - because they are the ones that keep us IT folks employed.
My co-workers and I are still trying to except this. Roll Eyes


In Focus since 1993. WebFOCUS 7.7.03 Win 2003
 
Posts: 1903 | Location: San Antonio | Registered: February 28, 2005Report This Post
Virtuoso
posted Hide Post
Reminds me of the old joke (that we still use sometimes) when a user has (what IT would consider) a dumb question/request/problem. We say they've experienced an "ID ten T" error. That would be ID10T. Smiler


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, 2007Report This Post
Guru
posted Hide Post
Prairie,

Oh but I would never call my users stupid (at least not where they can here me Music). I simply said they were not normal....or in the words of Igor - "Abby Normal"!

Darin,

I'm going to have to remember the "ID ten T" error. Good One


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Guru
posted Hide Post
I must have been hanging around the users too long. I can't seem to spell any more!


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Expert
posted Hide Post
Glenda,

I've met a whole raft of users over the years.

When introduced to one chap, by way of identifying his level of expertise, told me he had difficulties with calculators. To be fair on him, he had spent most of his working life "on the tools" and had only recently moved into an area where he required basic IT user skills. An interface of stone and chisel would suit!!

You also get those that consider themselves experts because they have written VB code within MS Abcess. Unfortunately it doesn't take long to comprehend the depths of their talents as you find a level of 10 or more queries. These tend to be the most dangerous because they don't accept suggestions on how to improve their code.

Another type is the "dyed in the wool" eternal user. They use existing applications and have developed a method that suits them. When the old application has outgrown it's life span and is replaced by new, they show great commitment to trying to use the new app but just don't seem to get away from "the way it's always been done" and "why can't the new system be exactly like the old one".

I've found that most companies have people closely fitting these types and of course there are many, many others. It just helps make the rich tapestry of the user base sooooooo interesting Confused

Darin,

Love the error type, that ones going to be used many times I think Wink

T



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, 2004Report This Post
Master
posted Hide Post
Tony,
You missed your chance, if you had a "raft" of users you should have set them adrift perferably far out to sea.


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes
 
Posts: 755 | Location: TX | Registered: September 25, 2007Report This Post
Platinum Member
posted Hide Post
Darin, good one. I usually ask the 'users' to verify if they are testing with the 'more' feature 'on' or 'off', and thinking they know everything they reply 'more on' of course.
Smiler


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Guru
posted Hide Post
Oh no! I'm slipping into user mode.........what is the "more" feature...or was that the point you were trying to make.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Expert
posted Hide Post
Some great one liners there Smiler I like the thought of setting some of them adrift, oh were it possible!

Glenda, the user is meant to say "moron".



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, 2004Report This Post
Guru
posted Hide Post
Red Face

In the words of my children - Duh!

TGIF and I have tickets to Clay Walker tonight!


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Guru
posted Hide Post
One of my coworkers heard me discussing the "moron" issue and reminded me of the EBCAK error.

The number one compter error is an EBCAK error - Error Between Chair And Keyboard.


Glenda

In FOCUS Since 1990
Production 8.2 Windows
 
Posts: 301 | Location: Galveston, Texas | Registered: July 07, 2004Report This Post
Virtuoso
posted Hide Post
LOL. I love the MORE ON line.


Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011
 
Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Report This Post
Expert
posted Hide Post
A friend sent me this link:

http://www.javameblog.com/2007/08/10-things-your-it-guy-wants-you-to-know.html

I'm sure that there are many things in there that you've wanted to say to your users. I got the biggest kick out of it.

Enjoy!


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
Platinum Member
posted Hide Post
Glenda,

Below is my much simpler single-pass test code.
It autoprompts you for the 3 key parameters and you enter whatever combination you want. OLAP is included because my initial issue was with OLAP reports, but it turns out OLAP is not involved.

I post the code only so that 'newbies' can see example of using DM when you have to easily try different parameter values in different combinations.


Prarie:

Thanks for the hint about 'ANSI'. It solves the problem perfectly, as everyone can see by experimenting with my code and entering ANSI instead of ON or OFF.

Chris


-OLAP &OLAP_ON_OFF
SET EMPTYREPORT = &EmptyReport_ON_OFF
OLAP DIMENSIONS
DIMENSIONS FILE CAR
COUNTRY: COUNTRY, CAR, MODEL, BODYTYPE;
END
TABLE FILE CAR
SUM
'CAR.BODY.DEALER_COST'
'CAR.BODY.RETAIL_COST'
BY 'CAR.ORIGIN.COUNTRY'
BY 'CAR.COMP.CAR'
BY 'CAR.CARREC.MODEL'
BY 'CAR.BODY.BODYTYPE'
HEADING
"Costs of Cars"
"EmptyReport_ON_OFF: '&EmptyReport_ON_OFF' "
"OLAP: '&OLAP_ON_OFF' "
"MODEL contains: '&MODEL_Contains' "
" "
FOOTING
"This is the footer."
WHERE CAR.CARREC.MODEL CONTAINS '&MODEL_Contains';
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET AUTODRILL ON
ON TABLE SET OLAPPANE CONTROL
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='ARIAL',
SIZE=9,
$
TYPE=TITLE,
STYLE=BOLD,
$
TYPE=TABHEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=TABFOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=HEADING,
SIZE=12,
STYLE=BOLD,
$
TYPE=FOOTING,
SIZE=12,
STYLE=BOLD,
$
TYPE=SUBHEAD,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBFOOT,
SIZE=10,
STYLE=BOLD,
$
TYPE=SUBTOTAL,
BACKCOLOR=RGB(210 210 210),
$
TYPE=ACROSSVALUE,
SIZE=9,
$
TYPE=ACROSSTITLE,
STYLE=BOLD,
$
TYPE=GRANDTOTAL,
BACKCOLOR=RGB(210 210 210),
STYLE=BOLD,
$
ENDSTYLE
END


WIN/2K running WF 7.6.4
Development via DevStudio 7.6.4, MRE, TextEditor.
Data is Oracle, MS-SQL.
 
Posts: 154 | Location: NY | Registered: October 27, 2005Report This Post
Expert
posted Hide Post
quote:
SET EMPTYREPORT = ANSI Should get you a footer.

oh man! that is TIP OF THE YEAR, Prarie.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report 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     EMPTYREPORT=ON and FOOTERS

Copyright © 1996-2020 Information Builders