Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
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
Go
New
Search
Notify
Tools
Reply
  
[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, 2007Reply With QuoteReport 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: 434 | Location: Europe | Registered: February 05, 2007Reply With QuoteReport 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, 2006Reply With QuoteReport 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, 2007Reply With QuoteReport 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, 2013Reply With QuoteReport 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, 2005Reply With QuoteReport 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: 803 | Registered: April 23, 2003Reply With QuoteReport This Post
  Powered by Social Strata  
 

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-2018 Information Builders, leaders in enterprise business intelligence.