2007年10月14日 星期日

How to use Crystal Report for IFS Application

step by step as below:

1)Report Design thru Seagate CryStal Reports (xxx.rpt)

2)To add the xxx.rpt in Quick Report
thru IFS/Admin/Fnd1 AdMin/Quick Report

3)To Find Report id thru IFS/Admin -> Installation-> SQL Query tool
by using sql as belos:
select quick_report_id,description from quick_report;
(let quick_report_id is 99 as a example)

4)To add quick_report_id to Customer-Menu
Thru IFS/Admin - Fnd1 Admin\CustomMenu\CustomMenu-Detail

ActionType: SAL Code
Windows :enter the window identity – like :tbwPurchaseOrderLinePart
Parameter :InfoServer.QuickReportStart(SalNumberToStrX(99,0)//'@')
//please note :the number 99 is quick_report_id

5)To activate In IFS Application & enabled Custom Menus

the form ‘Properties’ – Window tab pop-up details
have enabled Custom Menus (tick the box).