Crystal Report + IFS Develop statements customization process

admin

Crystal Report + IFS Develop statements customization process

[Basic principles]
1) write the corresponding view
2) the development of statements of Crystal Reports / corresponding view associated
3) report rpt related to the IFS application

[Preparatory]
1) write the corresponding view
The personal recommendations practice, a report associated with a view
There are three reasons: easy report design (without a lot of trouble in the Crystal Reports lot of view related)
Convenient permission settings
Routine maintenance (you can directly modify the background SQL script)
Cited previously written examples are as follows (according to the report needs to write the appropriate view):
DEFINE MODULE = QLHMOD
DEFINE LU = HVIEW
DEFINE VIEW = HV_SO_WIP

CREATE OR REPLACE VIEW & VIEW AS
select 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_321
from DPCC_RPT_WIP_HIST
where contract = HPUB_FUN_API.gSite
and (qty_issued - (qty_complete + qty_scrapped) * qty_required / lot_size) <> 0
WITH read only;
COMMENT ON TABLE & VIEW
IS 'LU = & LU ^ PROMPT = & VIEW ^ MODULE = & MODULE ^';

2) the development of statements of Crystal Reports / corresponding view associated
This information online, you can easily google it.
Points to note:
- The best selection of view not to use the table;
- Report view selection, and then separate the individual name:
(Alias ??settings: Click the main menu "Database / SET Alias ??..." entry, the system will pop up the "Set Alias ??dialog box, select a view or table, and then click" Set Alias ??... "button, the system will pop up "Alias ??Name dialog box, in each view name with a" / ", such as" HV_SO_WIP / ;) - This step is not linked to the IFS application, the login dialog box will pop up.

-------------------------------------------------- -------------------------------------------------- -----
All information 20,080,305 update adds;
The following information 20,040,625 wrote:
The operation process Step 3) statements the rpt related to the IFS application;
-------------------------------------------------- -------------------------------------------------- -----

1) design statements Seagate CryStal Reports => Design *. Rpt

2) Add the statements IFS/Admin-> Fnd1 AdMin -> Quick Report -> Add a sum of Quick Report

3) Find the id IFS / Admin -> Installation-> SQL Query tool under SQL statement
select quick_report_id, description from quick_report; find just added statements id: 42

4) Add to the corresponding form IFS / admin -> FND1 admin / CustomMenu / CustomMenu-Detail add a piece of data:
ActionType-> SAL Code
Windows-> Form Name
Parameter => InfoServer.QuickReportStart (SalNumberToStrX (42,0) | | '@')
/ / Note 42 of the sentence

5) the appropriate form to open the customized menu options: open the IFS applications -> Forms -> right click -> selected CustomItem "

So the midpoint of the form right you can see just the development of the report.