Question

IFS Cloud 22R2 - Creating a Dataset using a Data Source in SSRS error

  • 12 May 2023
  • 1 reply
  • 68 views

Userlevel 3
Badge +6

IFS Cloud 22R2 customer is using SSRS and trying to create a Dataset using a Data Source that they have successfully connected to and they are receiving errors as per the screenshots - any feedback as to whether this is a bug or how to fix these errors in SSRS is appreciated.  

 


1 reply

Badge +1

 

We just configured our SSRSOR extension recently. However, keep in mind that using IFS Data Source, it does not support SQL statement, only operational reports (%_REP). You will use different syntax like PRODUCT_CATALOG_REP:DATA to get available fields in the report.

 

You could follow IFS document here: Example of Creating a Basic Report for BI Development Studio - Technical Documentation For IFS Cloud

 

Hope this helps,

 

Reply