[Drew Rosen]

I have a SSRS report that I am using a query to get the available value for the parameter.  I am also using the same query to get the default value for the parameter.  Is it possible in SSRS to get the value from the query but also allow the end user to change the value of the parameter before they click view report button.  Thanks 

Drew G. Rosen
Carolina Services of Fayetteville, Inc.
910-221-3561

——————————
Drew Rosen
Carolina Services of Fayetteville, Inc
fayetteville NC
——————————

[Paul Richard]

Hi Drew :

It sounds like you have a single parameter and given that you are providing a default, SSRS is immediately launching the report. However, you’d prefer that the user have a chance to change the default before running. Is that about right?

I recally running into this annoyance. I think it is SSRS’s programmed behaviour unfortunately. I can’t recall exactly which option I chose to work around the problem, but just found this Stackoverflow post with a few approaches to work around it. I must have done something similar.

Sorry I can’t be more help.

Paul

——————————
Paul Richard
Programmer-Analyst
Ville de Dieppe
——————————
——————————————-

[Blair Christensen]

A lot depends on how you have the parameter defined.  In most cases, you want a specified list of selections for the user to constrain things to only valid options.  That means that if you want to use a default, that’s fine, but you need to be more expansive when you present the list of options.  I use dynamic lookups frequently, even in conjunction with default values.  The most common place I used them is for date values, where I present a list of month end dates but default to the most recent one.  You can even make it so the lookup only lists say the past three years worth of dates rather than dates ten years in the past.

Here’s one thing that I think is hanging you up: the default.  The report will only ask for user input if some of the required parameters don’t have values, i.e. no defaults.  If you supply defaults, the report is always going to run with those defaults and the user will only be able to change the parameters and re-run the report after it has executed once with the default values.  If you want the user to be able to select a value before the report executes, you must declare at least one variable as “required” but NOT supply a default value for it.

If you need specific ideas, you’re welcome to email me personally.  I’ve built over a hundred SSRS reports with varying degrees of complexity and I’d be happy to help if I can.
?

——————————
Blair Christensen
Database Administrator
Oppenheimer Companies, Inc.
Boise Idaho GPUG Chapter Leader
GPUG All-Star
——————————
——————————————-