Custom process of crystal report + ifs develop tables

[Basic principle]
1) write the corresponding View
2) crystal report Development Report/associated with the corresponding View
3) Report RPT associated with Ifs Application

[Preparations]
1) write the corresponding View
Recommended Practice: associate a report with a view
Three reasons: ease of report design (do not bother to associate multiple views in the Crystal Report)
Easy permission setting
Routine maintenance is convenient (you can directly modify the SQL script in the background)
The following is an example of a previous write (write a view based on report requirements ):
Define module = qlhmod
Define Lu = hview
Define view = hv_so_wip

Create or replace view & view
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, '000000') * (qty_issued-(qty_complete + qty_scrapped) * qty_required/lot_size,
Hpub_fin_api.getpartcost (contract, rpt_month, mat_part, '000000') * (qty_issued-(qty_complete + qty_scrapped) * qty_required/lot_size,
Hpub_fin_api.getpartcost (contract, rpt_month, mat_part, '000000') * (qty_issued-(qty_complete + qty_scrapped) * qty_required/lot_size,
Hpub_fin_api.getpartcost (contract, rpt_month, mat_part, '000000') * (qty_issued-(qty_complete + qty_scrapped) * qty_required/lot_size
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) crystal report Development Report/associated with the corresponding View
There is a lot of information on the Internet. You can Google it as you like.
Note the following:
-- It is best to select a view instead of a table;
-- Select a view in the report and use another alias:
(Alias setting method: click "database/set alias..." in the main menu... "entry, the system will pop up the" set alias "dialog box, select each view or table, and then click" set alias... "button, the system will pop up the" Alias Name "dialog box, add a"/"after each view name, such as" hv_so_wip/;) --> if this step is not done, the Login Dialog Box is displayed when you log on to the IFS application.

Bytes ---------------------------------------------------------------------------------------------------------
The above information is updated in 20080305;
The following information is written in 20040625:
Step 3. Associate the report RPT with the IFS application;
Bytes ---------------------------------------------------------------------------------------------------------

1) design metric table Seagate Crystal Reports => Design *. rpt

2) Add the External table ifs/admin-> fnd1 admin-> quick report-> Add an external quick report.

3) Find the SQL statement under ID ifs/admin-> Installation-> SQL query tool.
Select quick_report_id, description from quick_report; find the region table ID that is added only by region: 42

4) Add a token to the image window ifs/admin-> fnd1 admin/custommenu-detail:
Actiontype-> Sal code
Windows> window Host Name
Parameter => infoserver. quickreportstart (salnumbertostrx () | '@')
// Pay attention to the 42

5) Select a custom menu for opening the corresponding window: Open the Ifs Application> WINDOW> click "right"> select "customitem"

In this way, you can click "right" in the window to view the development progress table.

By foreveryday007 20040625.
The universe is as big as the heart.
Http://blog.csdn.net/foreveryday007