Skip to main content
Question

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

  • May 12, 2023
  • 1 reply
  • 90 views

cmdriordan
Sidekick (Employee)
Forum|alt.badge.img+7

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

Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 5 replies
  • June 3, 2023

 

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,