[Basic Principle] 1) Write the corresponding view 2) Crystal Report Development Report / With the corresponding view 3) Report RPT Related to IFS Application [Preparation] 1) Write the corresponding view Personal suggestion, one report is associated with a view reason There are three: convenient report design (don't have any troubles in crystal reports) Convenient permissions to set our daily maintenance convenience (directly modifying the background SQL script) Give the previously written example as follows (according to the report needs to write the corresponding view : Define module = qlhmoddefine l = hviewdefine view = HV_SO_WIP
CREATE OR REPLACE VIEW & VIEW ASselect HPUB_FUN_API.gCompName CompName, substr (SITE_API.Get_Description (CONTRACT), 1,100) site_desc, rpt_month, contract, so_no, mat_part, mat_part_desc, inventory_part_api.Get_Unit_Meas (contract, mat_part) unit_meas, qty_issued - (qty_complete qty_scrapped ) * qty_required / lot_size wip_qty, HPUB_FIN_API.GetPartCost (contract, rpt_month, mat_part, 'ALL') * (qty_issued - (qty_complete qty_scrapped) * qty_required / lot_size) cost_all, HPUB_FIN_API.GetPartCost (contract, rpt_month, mat_part, '110' ) * (qty_issued - (qty_complete qty_scrapped) * qty_required / lot_size) cost_110, HPUB_FIN_API.GetPartCost (contract, rpt_month, mat_part, '200') * (qty_issued - (qty_complete qty_scrapped) * qty_required / lot_size) cost_200, HPUB_FIN_API.GetPartCost (contract, rpt_month, mat_part, '300') * (qty_issued - (qty_complete qty_scrapped) * qty_required / lot_size) cost_300, HPUB_FIN_API.GetPartCost (contract, rpt_month, mat_part, '321') * (qty_issued - (qty_complete qty_scrapped) * Qty_Required / Lot_Size) COST_321FROM DPCC_RPT_WIP_HIS Twhere contract = HPUB_FUN_API.gSiteand (qty_issued - (qty_complete qty_scrapped) * qty_required / lot_size) <> 0WITH read only; COMMENT ON TABLE & VIEW IS 'LU = & LU ^ PROMPT = & VIEW ^ MODULE = & MODULE ^';
2) Crystal report development report / associated with the corresponding view This online information is more, you can go Google. What should I pay attention to: - It is best to use the viewpoint not to use the table; The "SET Alias" dialog box will pop up, select each view or table, and then click the "SET Alias ..." button, the "Alias Name" dialog box will pop up, add one after each view name "/ " -------------------------------------------------- ------------------------------------ The above information is added to 20080305 update; the following information is written in 20040625: Operation process introduction Step 3) Report RPT is associated into the IFS application; ----------------------------------- -------------------------------------------------- --------------------
1) Design Report Seagate Crystal Reports => Design * .rpt
2) Add report IFS / admin-> fnd1 admin -> Quick Report -> Add a Quick Report
3) Find ID IFS / Admin-> Installation-> SQL Query Tool SQL Statement Select Quick_report_id, Description from Quick_Report; Find the ID: 42
4) Add to the appropriate form IFS / admin -> fnd1 admin / customummenu / CustomMenu-detail Add a profile: ActionType-> Sal codeWindows-> Form Name Parameter => InfoServer.quickReportStart (Salnumbertostrx (42, 0) || ' @ ') // Please note 42 in this sentence
5) Open Customized Menu Options: Open IFS Application -> Form -> Select "CustomItem"
In this form, you can see the reports you just developed.
By ForeveryDay007 20040625 How big is the heart, how big is the universe. Http://blog.9cbs.net/foreveryday007
Related resources: with sound access new year fireworks animation effects - html-code
