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     Report Output to display number of rows

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Report Output to display number of rows
 Login/Join
 
kitten
Gold member
posted
Hello again everyone. I wanted to know if it is possible to have have my reports display the number of row at the bottom of the report like SQLPLUS does. I love seeing detail but sometimes I'd like to see the number of rows selected. Sounds crazy...but right now I pull the reports into excel and subtract the number of rows used for the heading to get the number of rows selected. Can anyone help with this?


WebFOCUS 7.6.2, MS Windows Server/______, Excel, PDF, HTML
 
Posts: 91 | Registered: May 15, 2008Report This Post
Tom Flynn
Expert
posted Hide Post
kitten,

There are many ways to acheive this in WebFOCUS, especially if you've never programmed in Crystal; here is 1 way, many others will chime in with their ideas, I hope!:

  
TABLE FILE CAR
SUM
   CAR
   COMPUTE ROWS/I5 = LAST ROWS + 1; NOPRINT
 BY COUNTRY
 BY CAR NOPRINT
 ON TABLE SUBFOOT
"Total Rows: <TOT.ROWS"
END
-EXIT


Hope this starts you in the right direction...

Tom


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006Report This Post
kitten
Gold member
posted Hide Post
Tom I am using Report Painter....how does your instructions translate to GUI Smiler.


WebFOCUS 7.6.2, MS Windows Server/______, Excel, PDF, HTML
 
Posts: 91 | Registered: May 15, 2008Report This Post
Prarie
Virtuoso
posted Hide Post
You would make a Compute with the GUI and follow what he had in the COMPUTE then add a Subfoot and type what He has under SUBFOOT Into the SubFoot section.

oR Open it up in the text editor and just add it.


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

You can also use the variable &RECORDS for displaying the number of rows in a report.

&RECORDS does not count the heading as a line . So i guess you can add this variable in the sub-foot

Thanks

Aravind


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Arvind,

You cannot use &RECORDS (nor &LINES - which is what you need) in your footing because it is set only after the report is run.

Kitten,

To add to Tom's example I did this in the GUI:
  
TABLE FILE CAR
SUM 
     SALES
     COMPUTE R/I5 = 1 + R; NOPRINT
BY COUNTRY
BY CAR
BY BODYTYPE
HEADING
""
FOOTING
""
ON TABLE SUBFOOT
"Rows: <R"
WHERE SALES GT 0;
ON TABLE SET PAGE-NUM OFF 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON


How to do it:
After you set the fields, do the following:
Position yourself after the lsat field
Click on Report->Computes
Define a field named R with format I5
In the box type 1 + R
Click OK
Make R invisible (r-click on R, uncheck visible)
Click Report footing
Type Rows:<R
Run

Try it


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
arvind
Platinum Member
posted Hide Post
oh ,

Thanks daniel for that tip..my grey cells are not there


WebFOCUS 714
Windows XP
Output: HTML,PDF,Excel
 
Posts: 189 | Registered: January 30, 2008Report This Post
Alan B
Virtuoso
posted Hide Post
If you can get to the source, rather than just the painter, a slightly esoteric approach is:
TABLE FILE CAR
SUM 
   CAR
   COUNT NOPRINT
 BY COUNTRY
 BY CAR NOPRINT
ON TABLE SUBFOOT
"TOTAL ROWS  <ST.COUNT"
END

which I don't believe could be done in the painter.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Alan,

You really read the book! Few people know the use of COUNT as a pseudo-field...


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
Tony A
Expert
posted Hide Post
quote:
really read the book
No, he's just been using FOCUS and WebFOCUS for far too long 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
Alan B
Virtuoso
posted Hide Post
Just years of trivia Danny. There used to be a trivia quiz, one of my favourites was, without running it, what do you get from:
TABLE FILE CAR
STORE COUNT TYPE COUNT
END

Tony, you're right!


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Alan,
What is "STORE"? Could you mean "SUM" or "PRINT"?
The rest is:
"COUNT" is short for COUNTRY
"TYPE" is the alias of BODYTYPE
"COUNT" is the pseudo-field

Nice!


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
Alan B
Virtuoso
posted Hide Post
You have to go back to the origins of FOCUS for STORE. I think only Gerry/Noreen/Art may know the true meaning, which I supposed was a precursor to MATCH FILE, but nowadays seems to be a synonym for SUM.


Alan.
WF 7.705/8.007
 
Posts: 1451 | Location: Portugal | Registered: February 07, 2007Report This Post
Danny-SRL
Virtuoso
posted Hide Post
Well, I don't know in which version there was STORE. I tried it now in PC/FOCUS (1994): unknown. However WRITE (=SUM) is valid.


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
kitten
Gold member
posted Hide Post
Danny it worked...thanks everyone for all your input....i will start using the editor.


WebFOCUS 7.6.2, MS Windows Server/______, Excel, PDF, HTML
 
Posts: 91 | Registered: May 15, 2008Report 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     Report Output to display number of rows

Copyright © 1996-2020 Information Builders