So, the problem is that report on SSRS is executing immediately after opening. I use query based default parameters.. And i saw the solution with adding additional parameter without default value. It doesn't work for me because of the textbox which cannot be hidden (i tried to hide it and report stop working). So is there a way to hide this additional parameter? or maybe another way to solve this issue?
The problem is happening because you are setting a required parameter as nullable or you are giving it a default value that is invalid. To fix the problem, remove the default values. When you go to the report it will not be able to run until you give it the required value(s).