Skip to main content
Question

_RPT tables alternative

  • April 8, 2026
  • 2 replies
  • 25 views

Forum|alt.badge.img+2

In 25R2 there is information about RPT tables being phased out. 

Changes to IFS Operational Reporting 

Operational Reports (RDF) reports had an associated _RPT table, which should no longer be used. Therefore, RDF reports should be uplifted so that they are correctly reflected in the model and that the _RPT table is not used.

 

I have scenarios where I reach to those tables to provide external reports (as a SQL query against _RPT tables).
The user runs the report in IFS, provides the report key as a parameter to my own report.

This allows me to avoid replicating the logic of the operational report just so I can use data for my own needs. 

I am sure I am not the only one who uses this trick. 
Has anybody found a viable alternative that would work in this scenario?

 

2 replies

PhillBronson
Hero (Customer)
Forum|alt.badge.img+11
  • Hero (Customer)
  • April 9, 2026

@lstanczyk You are not the only one and we are interested in a like-for-like solution from IFS as well.


Forum|alt.badge.img+11
  • Hero (Partner)
  • April 9, 2026

Same issue. What I did was Created a Excel Plug In Report and set a template to get the data in the format I want. This produces a .xlsx file when previewing the Report Print using the Excel Plugin Report Layout.

 

 

 

See help file on how to configure this….
https://docs.ifs.com/techdocs/25r2/060_development/025_operational_reporting/190_using_report_plugins/040_excel_plugin/

 

NOTE: There are some limitations