The number of comments to the report on the Report Server

[Anonymous]

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?

[Medina]

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.

Spoiler

I DO NOT RECOMMEND PLAYING WITH THE SSRS/PBI RS STORED PROCEDURES

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!