Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Wondering if there is a way to prevent commenting on a desktop report. Looking at the table dbo.upgradeinfo (within the reportserver - database), there is a item called "enablecomments" with a status of True. Tried to replace with a false, but once I bounce the website, the value is restored. Dont know if this even refers to commenting on a desktop report, but was wondering if anybody has came across this and knows of a solution.
Thanks.
Solved! Go to Solution.
Okay... so this is a dirty solution, but ended up putting in a trigger on the comments table of which desktop reports I dont want to allow commenting. Below is the *cough* "solution", which we also capture the comment and user name to have it send via email. If a user does attempt to submit a comment, they will receive the error message "An error has occurred. Something went wrong. Please try again later.". I believe the error is a result to not sending anything back from the post. Out of curiosity I imagine if you didn't want the error message, you could have the stored procedure "GetCommentByCommentID" return false data.
declare @commentid int, @comment varchar(2048), @username varchar(260
if (select count(*) from dbo.[Catalog] a
join inserted b on a.ItemID = b.ItemID
where Name like '%your condition%') > 0
begin
select @commentid = a.commentid,@comment = a.[Text], @username = coalesce(b.UserName,'Unknown') from inserted a
left join dbo.Users b on a.UserID = b.UserID
exec dbo.DeleteComment @commentid
end
Yeah I'd really appreciate the capability of turning this off globally as well. If you want to drive people through the portal, then allowing content editors the ability to edit/delete/suppress comments would be useful.
Okay... so this is a dirty solution, but ended up putting in a trigger on the comments table of which desktop reports I dont want to allow commenting. Below is the *cough* "solution", which we also capture the comment and user name to have it send via email. If a user does attempt to submit a comment, they will receive the error message "An error has occurred. Something went wrong. Please try again later.". I believe the error is a result to not sending anything back from the post. Out of curiosity I imagine if you didn't want the error message, you could have the stored procedure "GetCommentByCommentID" return false data.
declare @commentid int, @comment varchar(2048), @username varchar(260
if (select count(*) from dbo.[Catalog] a
join inserted b on a.ItemID = b.ItemID
where Name like '%your condition%') > 0
begin
select @commentid = a.commentid,@comment = a.[Text], @username = coalesce(b.UserName,'Unknown') from inserted a
left join dbo.Users b on a.UserID = b.UserID
exec dbo.DeleteComment @commentid
end
Thanks for sharing the information.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
116 | |
108 | |
107 | |
93 | |
69 |
User | Count |
---|---|
169 | |
134 | |
132 | |
95 | |
93 |