Solved

Invalid Member Name

  • 14 July 2023
  • 2 replies
  • 53 views

Userlevel 5
Badge +10

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

 

icon

Best answer by SHAUN_KERSLAKE 25 July 2023, 14:45

View original

2 replies

Badge

Hi @SHAUN_KERSLAKE ,

Can you provide a screenshot of your error? Or if possibly share the structure used for the quick report?

Userlevel 5
Badge +10

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