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>,
Try adding this to your style:
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.
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
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
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
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
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.
Windows 7, PDF, Excel
Cool. Thanks for sharing.
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.
|Powered by Social Strata|