Replies posted by iyoung

2 Replies

J
Sidekick (Partner)
jporterSidekick (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

22R2: SSRS set up in IFS hosted cloud

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

2
I
Do Gooder (Customer)
11 months ago
cmdriordan
Sidekick (Employee)
cmdriordanSidekick (Employee)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

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

 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, 

1
I
Do Gooder (Customer)
11 months ago

Badges

Show all badges
Terms & ConditionsCookie settings