Skip to main content

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

 

Hi @SHAUN_KERSLAKE ,

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 

Reply


Terms & ConditionsCookie settings