While running Ad Hoc Report for Performance Management the Comments get cut off and the full comment cannot be reported on.
Reproducing the Issue
- Go to Adhoc Report
- Run the Adhoc report and see the comment field.
- Comment field showing truncated data as compared to UI.
- It is a known limitation that ad hoc reporting only supports reporting on ~4,000 characters due to DB limitations.
- This is by design, Adhoc report pulls the data from FEEDBACK table which has the limitation of 4000 character and PM form pulls the data from form content blob, hence the difference in form and Adhoc.
Adhoc report comment truncated 4000 charated limitation , KBA , LOD-SF-ANA-ADH , Adhoc Reports & Report Builder , Product Enhancement