Link to report

https://iawmqy-dev7.fa.ocs.oraclecloud.com/analytics/saw.dll?bipublisherEntry&Action=open&itemType=.xdo&bipPath=%2FCustom%2FIncentive%20Compensation%2FGlobal%20SCP%20Governance%20Solution%2FDirect-MPA%20Screen-PPH%2FScreensMashupRpt.xdo&path=%2Fshared%2FCustom%2FIncentive%20Compensation%2FGlobal%20SCP%20Governance%20Solution%2FDirect-MPA%20Screen-PPH%2FScreensMashupRpt.xdo] https://iawmqy-dev7.fa.ocs.oraclecloud.com/xmlpserver/Custom/Incentive Compensation/Global SCP Governance Solution/Direct-MPA Screen-PPH/ScreensMashupRpt.xdo?_xmode=4&Id={Id_Value} // 1. Define base environment (Hardcoded for stability in Mashup URLs) def host = "iawmqy-dev7.fa.ocs.oraclecloud.com" def protocol = "https://" // 2. Define the Report Path def reportPath = "/xmlpserver/Custom/Incentive%20Compensation/Global%20SCP%20Governance%20Solution/PPHScreenMashUp/ScreensMashupRpt.xdo" // 3. Get Field Value safely def batchValue = Id?.toString() // 4. Construct URL WITHOUT _xf parameter // This allows the report to pick up its own default format (e.g., PDF, HTML, or Excel) if (batchValue != null) { return "${protocol}${host}${reportPath}?_xmode=4&_xautorun=true&id=${batchValue}" } else { return "${protocol}${host}${reportPath}?_xmode=4&_xautorun=true" } // 1. Define base environment def host = "iawmqy-dev7.fa.ocs.oraclecloud.com" def protocol = "https://" // 2. Define the Report Path (Ensure no trailing slash before xmlpserver) def reportPath = "/xmlpserver/Custom/Incentive%20Compensation/Global%20SCP%20Governance%20Solution/PPHScreenMashUp/ScreensMashupRpt.xdo" // 3. Get Field Value safely // Ensure 'Id' matches your field API name exactly (e.g., ParticipantId_c) def batchValue = Id?.toString() // 4. Construct URL // Added _xmode=4 (Document Only) and _xautorun=true (Execute immediately) if (batchValue != null) { return "${protocol}${host}${reportPath}?_xmode=4&_xautorun=true&id=${batchValue}" } else { // Return report without ID filter or a default message return "${protocol}${host}${reportPath}?_xmode=4&_xautorun=true" } new path /shared/Custom/Incentive Compensation/Global SCP Governance Solution/Direct-MPA Screen-PPH/ScreensMashupRpt.xdo Paremeter = id

Comments

Popular posts from this blog

dev7 from eror

EPA

Unified Currency Report- Krithika