Focal Point
[SOLVED] Active Reports (AHTML) does not print more than 10 rows

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1021094652

November 09, 2007, 10:16 AM
BIGuru
[SOLVED] Active Reports (AHTML) does not print more than 10 rows
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>,
November 09, 2007, 11:23 AM
Frans
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.
November 09, 2007, 12:01 PM
GinnyJakes
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
November 09, 2007, 12:40 PM
BIGuru
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
February 03, 2014, 07:38 AM
Mikey
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
February 03, 2014, 08:52 AM
njsden
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.
February 04, 2014, 12:00 PM
David Briars
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.