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     how to solve the problem ?(report show a lot of records)

Read-Only Read-Only Topic
Go
Search
Notify
Tools
how to solve the problem ?(report show a lot of records)
 Login/Join
 
Lisaqq
Member
posted
The management has a requirement about WebFocus Report.
The problem now is: When we do a search, some reports will show a lot of records (like 10000 records).
It takes long time to get the data. So is there any way that we can just read the first 100 records. Then when we click another link, it will show the second 100 records and so on?
So Every time, it only takes several seconds to show the data.

Anybody could give me some help?
Thanks a lot!
 
Posts: 19 | Registered: January 05, 2007Report This Post
Lisaqq
Member
posted Hide Post
BTW, the version is 714
Thanks!
 
Posts: 19 | Registered: January 05, 2007Report This Post
Carol Dobson
Guru
posted Hide Post
This might help if your output is HTML SET WEBVIEWER - ON It works in 5.2.8 - have not tested in WF 7 yet.

SET WEBVIEWER = ON
TABLE FILE CAR
PRINT MODEL MPG
BY COUNTRY
ON TABLE SET ONLINE-FMT HTML
END

The WebFOCUS Viewer improves your ability to handle long reports by allowing you to view a single page of report output. You can use the WebFOCUS Viewer to:

View single pages of long reports.
Search for specific pages in a report.
Search for specific strings of information.
Deliver a full report to your Web server.

The WebFOCUS Viewer uses the On demand Paging facility. When On demand paging is enabled, WebFOCUS saves the bulk of your report to your Web server and delivers one page of report output at a time, decreasing the amount of time you wait for your report to process. The bulk of your report remains on the Web server until you request it or close the WebFOCUS Viewer.

Good Luck!



WebFOCUS 7.6.6/TomCat/Win2k3
 
Posts: 428 | Location: Springfield, MA | Registered: May 07, 2003Report This Post
Lisaqq
Member
posted Hide Post
quote:
SET WEBVIEWER = ON


hi, Thanks a lot for your help!
I just tried. But WebFocus said "Error parsing report request" ">SET< SET WEBVIEWER = ON"

I put "SET WEBVIEWER = ON" in the source (I used GUI to generate the report)

When I tried to create a new "Set". I fount there is no "WEBVIEWER" in the list

Hope you could give me more help!
Thanks!
 
Posts: 19 | Registered: January 05, 2007Report This Post
susannah
Expert
posted Hide Post
Lisaqq,
Carol's code exactly as written works perfectly.
Copy it and paste it and run it.
that should give you the confidence to figure out what is wrong in your fex.



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
oceannative
Member
posted Hide Post
Lisaqq - don't know if you were able to resolve this... when I want what you have requested, in Report Painter, I navigate to Report>Format and then check the box for "On Demand Paging".



Prod: WebFOCUS 7.1.6 - on Win 2K3/Tomcat - MRE/BID/RCaster/VisDis and AS400 (JDEWorld)
 
Posts: 23 | Location: North Carolina | Registered: May 16, 2006Report This Post
Piipster
Guru
posted Hide Post
I'd want to push back on the requirements. A web based report of 10000 records doesn't make much sense to me. There isn't going to be much you can do with a report of that size in a browser window. I find that people who request reports like this are accustomed to getting them on paper. They need some prodding to push them into a better way of delivering the data when it's on the web.

Give them a high level report, then drill down to more detail on a subset of the data.


ttfn, kp


Access to most releases from R52x, on multiple platforms.
 
Posts: 346 | Location: Melbourne Australia | Registered: April 15, 2003Report This Post
<JJI>
posted
I agree with Piipster. A report of 10000 does not make much sense! Big Grin Therefore in my opinion it's better to create a param screen (with autoprompting or a selfmade html screen).
That way you still can both directions. But most important is that you explain your endusers how to use those param screens and how these screens will help them to produce the report they want fast and correct.

Dirk JJI
 
Report This Post
Lisaqq
Member
posted Hide Post
hi,
Thanks a lot for your suggestions!

I have talked to the manager. And we will change the requirement.

Thanks again!
 
Posts: 19 | Registered: January 05, 2007Report 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     how to solve the problem ?(report show a lot of records)

Copyright © 1996-2020 Information Builders