in earlier versions of IFS cloud, when printing a report; for instance Customer Ledger Open Items. The data was stored in cust_open_item_rep, which could be accessed via Quick Report and hence be exported to excel.
These views are empty when printing reports in 25R2, are the information stored elsewhere now?
Question
Where are %_REP reports stored in 25R2?
They are still used the same way.
Just tried: select * from ifsapp.CUST_OPEN_ITEM_REP order by result_key desc and all looks fine.
I am taking that back, it is only reports created before upgrade to 25R2 that is visible in ifsapp.CUST_OPEN_ITEM_REP. any report created after upgrade is not visible in this view.
Maybe the results do not exist anymore. Please bear in mind that every report has a number of days defined for the report results to exist in the archive.
Edit: I tested in on report created in 25R2 when I sent my first reply.
+14
EBR Preparations for Reporting - Technical Documentation For IFS Cloud
However, IFS decides they will bring back this feature in SU3 in order to support customers who use crystal reporting. So you will get this feature back when you upgrade to SU3. Read below thread for information on this.
Removal of Crystal Reports in 25R1 | IFS Community
We are indeed on 25R2SU2. Do I understand the documentation correct that data generated to be printed on PDF is not stored in any table at all? Is it only stored in the XML-file in report archive?
As the crystal functionality eventually will be removed anyway I rather find a permanent solution to our issue, all we want is to be able to get standard reports in spread sheet formats as a complement to printed reports.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.