I have about 10 parameters in my report which is been set by the stored procedure that i am accessing in the report. so my stored procedure takes all the 10 parameters. I need to hardcode 6 of those parameters. I tried setting the 6 parameters properties as "Do Not Show" and gave a default value. When I execute the report, it takes about a minute to fetch the results which is ok. when i triedto access the second page, it again starts processing and takes a while to display.

The SP is being used by other application. I can create another SP with a different name and do it but in that case i have to reassign all the report parameters to all the detail sections and change other properties which i am trying to skip. I just need to hide a few parameters by hard coding its values and make it invisible to the user. When I set the Show on (Viwerver)panel property to  "Do not show", it still shows on the viewer. I dont know why this property doesnt work for automatically generated params such as SP.

Awesome, it works when i update the SP with a new one. Now my question is when i look at the properties and formulas, it still points to the old SP name which is fine since i am no longer using the old one. But in case if the old SP gets deleted from the database for some reason in future, will my report still work ?