Symptom
When you try to run a custom report, the below error is happening:
This report contains Hidden table with expression true which is known to cause issues during execution, and is not recommended. Please modify your report and re-import your report.
Environment
SAP LMS
Reproducing the Issue
Run any custom report that uses hidden tables.
Cause
Starting on release 1708, we are no longer supporting hidden tables in custom Report Designer reports. Customers and partners who develop custom reports using the Report Designer or BIRT must refrain from using hidden tables that can potentially hold large data sets. Large data sets are held in memory and can result in out of memory issues. Issues arising from use of hidden tables will not be addressed.
● Do not use "hidden=true" i.e., the table is always hidden, and the behind data set holds large amount of data.
● We no longer support using hidden tables to provide values or calculations for the visible table or any other fields that are displayed on the report. Exception: If the dataset behind the hidden table has limited rows of data, such as a single row of the data.
Resolution
You need to modify your report to not use hidden tables.
See Also
Keywords
custom report, hidden tables, status , KBA , LOD-SF-LMS-REP , Reporting Data , How To