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] Active Reports (AHTML) does not print more than 10 rows

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Active Reports (AHTML) does not print more than 10 rows
 Login/Join
 
Member
posted
Hi All,

In our current environment (WF 7.6.2/SQL Serv. 2005), Active Reports (AHTML) does not print more than 10 rows.
Is there a configuration change to be made to make it print all rows on the page? Any work around?

Thanks in advance for any suggestions.

This message has been edited. Last edited by: <Kathryn Henning>,
 
Posts: 14 | Registered: September 13, 2007Report This Post
Guru
posted Hide Post
Hi BIGuru,

Try adding this to your style:

TYPE=REPORT, LINES-PER-PAGE=UNLIMITED,$

ps. add your Webfocus configuration to you profile so people can always see what kind of configuration you are running.


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
 
Posts: 454 | Location: Europe | Registered: February 05, 2007Report This Post
Expert
posted Hide Post
I also have 762 and have not had any problems with the number of rows in AHTML.

Try this code agains a demo file. The file is in the ibidemo directory if you installed the demo.

If you problems with this, you can use this example to open a case with IBI.

TABLE FILE CENTURYSALES
SUM
     QUANTITY
     LINEPRICE
BY PLANTNAME AS 'Plant '
BY ORDERNUMBER AS 'Order,Number'
BY ORDERDATE AS 'Date of ,Order '
WHERE ( ORDERDATE GE '20060101' ) AND ( ORDERDATE LE '20060102' );
-*WHERE TOTAL QUANTITY GE 1000;
HEADING
"Order Quantities Greater Than 1000"
"Active Reports - Popup"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     UNITS=IN,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRAPHCOLOR='GREEN',
     GRAPHCOLORNEG='RED',
$
TYPE=REPORT,
     GRID=ON,
     FONT='ARIAL',
     SIZE=9,
     RIGHTGAP=0.125000,
     LINES-PER-PAGE=20,
     CALC-LOCATION=TOP,
     MENU-LOCATION=COLUMN,
$
TYPE=TITLE,
     STYLE=BOLD,
$
TYPE=TABHEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=TABFOOTING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     SIZE=12,
     STYLE=BOLD,
$
TYPE=HEADING,
     LINE=1,
     JUSTIFY=CENTER,
$
TYPE=HEADING,
     LINE=2,
     JUSTIFY=CENTER,
$
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
  


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
Member
posted Hide Post
Thanks for the input Franc and GinnyJakes. Sorry I didn't put my question in detail.

Here is the acutal problem -
The Active report displays the default number or rows (which I think is approx. 50+ rows) per page in Internet Explorer. But, when we try to print from Internet Explorer it only prints 10 or sometimes less (yep! its got its own mind!) rows of the first page.

And the other thing I just noticed is if the same report is run in FireFox I am able to print all the rows on the page!!! Interesting!.

Appreciate your input. Thanks.

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


---------------------------------
Prod - WebFOCUS 7.7.03/ MS-SQL Server 2005/ParAccel/Windows 2008 R2 64Bit
Test - WebFOCUS 7.7.03/ MS-SQL Server 2005/ParAccel/Windows 2008 R2 64Bit
Dev - WebFOCUS 7.7.03/ MS-SQL Server 2005/ParAccel/Windows 2008 R2 64Bit
Output - PDF/HTML/AHTML/Excel
 
Posts: 14 | Registered: September 13, 2007Report This Post
Gold member
posted Hide Post
I cant believe no one has answered this by now. I opened a case with IBI and got the correct answer:

The Active HTML reports have a Print option that is available in the Active Report menu. This option allows you to print all records.
To use the Active Report Print option, simply select the Print -> All records from the Active menu at the top of each column.

The Active PDF report does not have this option and is a documented limitation:
Ref.: Active Technologies User's Guide
http://ecl.informationbuilders....jsp?DN=4501006.0713
Chap.6 Working With Active Technologies Reports for Adobe Flash Player
p. 181 Active Technologies Report Integration With Adobe Flash Player

The following HTML active report functionality is not available when you
use Adobe Flash Player: printing, the value selection dialog box when
filtering multiple values, the Grid Tool, tab window navigation,
comments, saving, exporting, and sending active reports.


8007
Windows 7, PDF, Excel
 
Posts: 75 | Registered: September 03, 2013Report This Post
Virtuoso
posted Hide Post
Cool. Thanks for sharing.



Prod/Dev: WF Server 8008/Win 2008 - WF Client 8008/Win 2008 - Dev. Studio: 8008/Windows 7 - DBMS: Oracle 11g Rel 2
Test: Dev. Studio 8008 /Windows 7 (Local) Output:HTML, EXL2K.
 
Posts: 1533 | Registered: August 12, 2005Report This Post
Master
posted Hide Post
Sweet! This looks like 'printer-friendly' functionality, that you will see on many web pages. Using this option I see a new web page, consisting of the Active Report data formatted for printing.

Nice thread follow-up, Mikey.
 
Posts: 822 | Registered: April 23, 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     [SOLVED] Active Reports (AHTML) does not print more than 10 rows

Copyright © 1996-2020 Information Builders