Ssrs default parameter not updating dating a borderline personality disorder man
If you do provide a value, the value overrides the default value.
To specify multiple combinations of parameter values, create a separate cache refresh plan for each combination.
You parameterise not just a the values you want to update (you want to update the answer to @Q with respnse QA) but also a parameter which tells the query to do its job.
This parameter is called @Action If you write the query as written above then click save, the Query input dialogue will prompt you for some parameter values in order to parse and verify the query.
Just enter some randm values (DON'T enter the value "Update" for @Action) - the query will be accpeted and saved, but because you didn't enter "Update" it didn't actually update anyway... The second dataset we'll call "delete", and will do its job when the value of @Action is "Delete" - but it's actually another UPDATE statement in SQL terms - it's just updating all your answers back to NULL. This needs to be added the update statements, because it needs to run in order to refresh the report display after the changes.
A refresh plan includes a schedule and the option to specify or override values for parameters.You must type or select a default value for each report parameter.The value that you set overrides the default value that is defined for the report parameter on the report server.If the shared dataset definition specifies the option Omit from query for a parameter, you do not need to provide a default value.This flag indicates that the dataset parameter is not used in the query.