Hi
We are getting an Invalid Member Name error upon running an IFS Quick report.
The SQL used runs fine in PL/SQL Developer.
The report contains a number of parameters which require user input so have used prompts such as ('%&User_ID%') which have worked fine previously. The report also contains a couple of UNION ALL statements.
Any suggestions on what is causing this would be appreciated.
Thanks
Best answer by SHAUN_KERSLAKE
The issue was use of & within the SELECT part of the quick report and resolved by referring to the topic below
Using ampersand , “&” in plsql as a character | IFS Community
+1Hi
Can you provide a screenshot of your error? Or if possibly share the structure used for the quick report?
The issue was use of & within the SELECT part of the quick report and resolved by referring to the topic below
Using ampersand , “&” in plsql as a character | IFS Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
