Hi All, I deleted the Order Task and readded the field and resolvd the problem.
Hi Dumeesha, Thanks for your reply. I add a new record and then select the list of values icon to select an ‘Order Task’ value. Why doesn’t the display text on the list of values show the concatenated values as i specified above in the custom attributes.
From memory, I think it was due to a grant issue. The Crystal report was trying to access an IAL which wasn’t granted to IFSPRINT.
A bit more info, the crystal report is reading _IAL’s and as I said when run as a quick report within IFS it executes fine.
@Charith Epitawatta I am now getting this issue in a different report, I hope you can help with this please. I am getting the pop up window with this again ‘Failed to retrieve Report.Please Contact your System Administrator.’ There is an error at the end 16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQI90Ms89oO9cclAEed2V7IoA==16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[DecryptPassword] Decrypting Password : CgQIYd9gDm3qm9OipK5k6r1oHQ==16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Decrypted.16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-IFSSYS DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-TEST AppOwner-IFSAPP IALOwner-IFSINFO16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[OpenReport] File Name : BA_BRO_ADDR_(v0.1).rpt16/02/2022 21:11:22[IFSCRWebSetupTEST_1]-[GetAppSetting] Get the value for Open
Thanks @Charith Epitawatta, It also looks like you can only build IALS over tables _TAB and _CFT . If you try to reference base IFS views or CFV’s in your IAL’s then the Crystal report runs with no data returned.
Curently on IFS Version 9.0.41
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.