SSRS Pass a Report Parameter Within a URL

You can pass report parameters to a report by including them in a report URL. These URL parameters are not prefixed because they are passed directly to the report processing engine.

Reference : 
https://docs.microsoft.com/en-us/sql/reporting-services/pass-a-report-parameter-within-a-url


http://localhost/Reports/Pages/Report.aspx?ItemPath=%2f%5bQuality+Sales+Report%5d%2fCP+Quailty+Sales+Details+Report+Preview&ViewMode=Detail

Above link is your report server link which provide you to make subscription and etc.
Instead of above link try below

Go to http://localhost/Reportserver find your report in above link and pass "&ID=(value) at the end of the url or

http://rpt.Server.local/Reportserver/Pages/Report.aspx?ItemPath=%2f%5bQuality+Sales+Report%5d%2fCP+Quailty+Sales+Details+Report+Preview&ID=(value)

Database name databasename ignored, referencing object in tempdb

This type of warning you got while working with stored procedure.

Warning : Database name <databasename> ignored, referencing object in tempdb.


Causes: while working with the temporary table you might be used the temp table reference with schema.

ex: select * from databasename.dbo.#tmpTable

this syntax gives you a warning message

Solution:
Don't use reference in your query.

ex: select * from #tmpTable

Sql server will auto manage the temp table with the different different database temp table in tempdb.

Delete encryption key from report server

If unable to delete encryption key from SQL server reporting service configuration manager, to delete it manually use below stored procedure.

use ReportServer

exec DeleteEncryptedContent


If you find any difficulty, feel free revert.

Above stored procedure is predefined in Report Server.