Skip to main content
Question

22R2: SSRS set up in IFS hosted cloud

  • May 25, 2023
  • 2 replies
  • 189 views

jporter
Sidekick (Partner)
Forum|alt.badge.img+10
  • Sidekick (Partner)
  • 126 replies

We are using 22R2 hosted in IFS cloud.

 

What are the steps for setting up SSRS?

2 replies

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31
  • Ultimate Hero (Employee)
  • 1094 replies
  • May 26, 2023

Hi @jporter,

To my knowledge, if the customer has purchased the SSRSOR component, you just need to open a case with IFS and request SSRS integration to be configured. 

For Remote customers, installation instructions can be found in the documentation:

https://docs.ifs.com/techdocs/23r1/070_remote_deploy/400_installation_options/005_operational_reporting/120_configure_ssrs_integration/

Hope this helps!


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

Please note that using SSRSOR component only supports Operational Report using available %_REP to get available data fields in the report. You could follow the Example of Creating a Basic Report for BI Development Studio - Technical Documentation For IFS Cloud.

 

If you want to use SQL statement to query database directly via SSRS, you will need to create a ticket with IFS to setup VPN site-to-site and read-only access account. 

 

Hope this helps