Skip to main content
Question

Excel Output Error when using WildCard in Quick Report

  • May 27, 2024
  • 1 reply
  • 269 views

cokaslan12
Do Gooder (Customer)
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)
  • 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?