Groups | Blog | Home
all groups > sql server reporting services > june 2006 >

sql server reporting services : Force prompt when using default parameters


Ash_Cat
6/15/2006 10:23:35 AM
I wrote an sp and assigned static values to fields for easy testing, after
that I created the parameters and assigned default values to them, now
everytime I click preview I don't get a prompt for new values, the report
automatically runs with the defaults.
I want to be able to use the default values most of the time but also want
the option to change them if needed. The only option is to stop the report
and enter different values. This is strange because I have other reports that
Tim Dot NoSpam
6/15/2006 2:19:11 PM
Someone answered this a few ones back.

Add a boolean "Run Report" parameter to the report with no default.

-T

[quoted text, click to view]

Ash_Cat
6/15/2006 3:22:02 PM
Cool! Thx Tim


[quoted text, click to view]
AddThis Social Bookmark Button