Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
One of the published reports had the following error when adding a new comment:
"You cannot add new comments. The number of comments has reached its maximum (100)."
Tell me, is it possible to increase the number of comments to the report in the settings? How can I do that?
Hi sleep_sonya,
There is no setup to change the limit of 100 comments per a report, as far as I know. The comments are stored in the table Comments and there is a stored procedure- [dbo].[GetCommentsCountByItemID]- Reporting Services execute to check for the number of comments stored in the table.
You can alter the code inside it to return a value less than 100, see below
Current
SELECT COUNT(*) FROM [Comments] as C WHERE C.[ItemID] = @ItemID
After change
SELECT 1 FROM [Comments] as C WHERE C.[ItemID] = @ItemID
That should do the trick.
I will recommend putting in place a policy on how many comments are allowed and how they will be deleted/archived and educating your users.
Thank you!