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

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

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)
  • 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