crystal report quick report in IFS 9 empty value

Did you add slash ‘/’ at the end of view alias in Crystal?

For operational reports, there were some additional requirments eg. add cr_web_init function.

Hi,

CR_WEB_INIT view should be added to the Crystal report-> Database file field.

In the view you created, fnd_session_api.Get_Fnd_User user_name, '40000101000000' objversion1

fields should be added.

Then, the OBJVERSION field in the CR_WEB_INIT view in the crystal report should be connected to the OBJVERSION1 field that you wrote in the view you created.

ok I did what you say and now report ask me login information for CR_WEB_INIT
 

​@orkuno  - I know that, but thanks for full explaint  for ​@atezcan .
This is described in documentation.

​@atezcan  it look now, that you don;t have \ at the end. Sorry I write previosly about slash. It should be backslash. You can modify aliases in Database Expert.
Paste SQL Query from Crystal, please.

 

I add \ and now report give en arror 

I did something wrong 

here is my query 

SELECT
    CASE 
        WHEN ifsapp.TRBRD_PERSONEL_CALISMA_API.Get_Isyeri_Kodu('ERD', a.emp_no, d.seq_no) = '01' 
        THEN 'ISTANBUL_ŞUBE' 
        ELSE 'KIRKLARELİ_ŞUBE' 
    END isyeri_kodu,
    ifsapp.TRBRD_PERSONEL_CALISMA_API.Get_Baslama_Tarihi('ERD', a.emp_no, d.seq_no) BASLAMA_TARİHİ,
    a."RAPOR_TARIHI",
    a."PERSON_ID",
    a."COMPANY_ID",
    a."EMP_NO",
    a."ADI_SOYADI",
    a."HIZMET_SURESI",
    a."IZIN_HAKEDIS_TARIHI",
    a."TOPLAM_HAKETTIGI_IZIN",
    a."TOPLAM_KULLANDIGI_IZIN",
    a."KALAN_IZIN",
    a."DOGUM_TARIHI",
    fnd_session_api.Get_Fnd_User user_name,  
    '40000101000000' objversion1                    
FROM 
    ifsapp.TRIFM_IZINLER4 a,
    (SELECT 
         MAX(b.seq_no) seq_no,
         b.emp_no
     FROM 
         ifsapp.TRBRD_PERSONEL_CALISMA_2 b
     GROUP BY 
         b.emp_no
    ) d
WHERE 
    a.emp_no = d.emp_no
    AND a.rapor_tarihi = TRUNC(SYSDATE)
and A.emp_no= '{?EMP_NO}'

Is the IFSAPP prod name correct?

It look You don’t heve ‘\’.
Below example from crystal Show SQL Query
 

 SELECT "OPERATION_HISTORY_CFV\"."DATE_APPLIED", "OPERATION_HISTORY_CFV\"."PART_NO", "OPERATION_HISTORY_CFV\"."QTY_COMPLETE", "OPERATION_HISTORY_CFV\"."QTY_SCRAPPED", "OPERATION_HISTORY_CFV\"."RESOURCE_ID", "OPERATION_HISTORY_CFV\"."TRANSACTION_CODE", "INVENTORY_PART\"."DESCRIPTION", "OPERATION_HISTORY_CFV\"."CF$_SHIFT", "OPERATION_HISTORY_CFV\"."CF$_LAST_OPERATION", "OPERATION_HISTORY_CFV\"."CREATED_BY_TEAM_ID", "OPERATION_HISTORY_CFV\"."TRANSACTION_ID", "SHOP_ORD\"."ROUTING_ALTERNATIVE"
 FROM   ("IFSAPP"."OPERATION_HISTORY_CFV" "OPERATION_HISTORY_CFV\" INNER JOIN "IFSAPP"."INVENTORY_PART" "INVENTORY_PART\" ON ("OPERATION_HISTORY_CFV\"."PART_NO"="INVENTORY_PART\"."PART_NO") AND ("OPERATION_HISTORY_CFV\"."CONTRACT"="INVENTORY_PART\"."CONTRACT")) INNER JOIN "IFSAPP"."SHOP_ORD" "SHOP_ORD\" ON (("OPERATION_HISTORY_CFV\"."ORDER_NO"="SHOP_ORD\"."ORDER_NO") AND ("OPERATION_HISTORY_CFV\"."RELEASE_NO"="SHOP_ORD\"."RELEASE_NO")) AND ("OPERATION_HISTORY_CFV\"."SEQUENCE_NO"="SHOP_ORD\"."SEQUENCE_NO")
 WHERE  "OPERATION_HISTORY_CFV\"."CREATED_BY_TEAM_ID" LIKE 'SPM%' AND "OPERATION_HISTORY_CFV\"."CF$_LAST_OPERATION"='Y' AND "INVENTORY_PART\"."DESCRIPTION" NOT  LIKE 'Człon%' AND ("OPERATION_HISTORY_CFV\"."TRANSACTION_CODE"='OPFEED' OR "OPERATION_HISTORY_CFV\"."TRANSACTION_CODE"='OPFEED-SCP' OR "OPERATION_HISTORY_CFV\"."TRANSACTION_CODE"='UNOPFDSCP' OR "OPERATION_HISTORY_CFV\"."TRANSACTION_CODE"='UNOPFEED') AND ("OPERATION_HISTORY_CFV\"."DATE_APPLIED">=TO_DATE ('19-12-2024 00:00:00', 'DD-MM-YYYY HH24:MI:SS') AND "OPERATION_HISTORY_CFV\"."DATE_APPLIED"<TO_DATE ('20-12-2024 00:00:00', 'DD-MM-YYYY HH24:MI:SS')) AND ("OPERATION_HISTORY_CFV\"."RESOURCE_ID"='L1' OR "OPERATION_HISTORY_CFV\"."RESOURCE_ID"='L2' OR "OPERATION_HISTORY_CFV\"."RESOURCE_ID"='L3' OR "OPERATION_HISTORY_CFV\"."RESOURCE_ID"='L5' OR "OPERATION_HISTORY_CFV\"."RESOURCE_ID"='SPM13')
 ORDER BY "OPERATION_HISTORY_CFV\"."RESOURCE_ID", "OPERATION_HISTORY_CFV\"."PART_NO", "OPERATION_HISTORY_CFV\"."CF$_SHIFT"