Force prompt when using default parameters

Force prompt when using default parameters

Post by QXNoX0Nhd » Sat, 17 Jun 2006 02:23:35


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
have all default values but give me a prompt in preview.
 
 
 

Force prompt when using default parameters

Post by Tim Dot No » Sat, 17 Jun 2006 03:19:11

Someone answered this a few ones back.

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

-T

 
 
 

Force prompt when using default parameters

Post by QXNoX0Nhd » Sat, 17 Jun 2006 07:22:02

Cool! Thx Tim