The clr procedure is itself wrapped in another stored procedure, as follows:

create procedure the_procedure

as

begin

exec the_clr_procedure

end

1) Logging on...

Somehow, when I updated the report by using the web url it worked fine !!!

1) SSRS server -> Home -> Folder -> ...

2) properties

This is very strange !!

Somehow I was creating my assembly with permisssion_set = safe and once I changed to EXTERNAL_ACCESS, it worked like a charm.

I have noted the detailed steps and if anyone...