Skip to main content
Question

Excel Output Error when using WildCard in Quick Report

  • May 27, 2024
  • 1 reply
  • 192 views

Forum|alt.badge.img+1

Hello IFS Community,

In my company we are using IFS 9.0.20.0 version. When we made quick report and tried this report we are getting an issue. When we use WildCard in PL/SQL query, we get this problem when we click the export to excel button from quick report. 

PL/SQL query is “SELECT order_no,
       customer_no
  FROM customer_order
 WHERE customer_no = '&[M----]CNO'

And this problem exists in the image

 

Do you have a solution for this issue? 

 

Thank you, Muzaffer

 

1 reply

baris.halici
Hero (Customer)
Forum|alt.badge.img+12
  • Hero (Customer)
  • 127 replies
  • August 6, 2024

Hello Community,

 

When a flag is used in a query, Excel output cannot be obtained from the quick report. This is the case for version 9. Does anyone have a solution?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings