Thanks. Good question, made me think for a minute or two before answering.

If you want them to type a value in, without having to choose from the drop down list, don't feed the parameter with values from the query.

Denormalize, yes.

Add as many details as you think may be useful in the long run, or have been requested.

Quick rule of thumb:

If you want to add it, sum it, average...

I don't care how it started. I really enjoy...

You probably also have a default value set for the parameter.

I don't think so, but I am not positive. However, I think you have a great idea. 🙂

I couldn't build this without a fair amount of research, but I...

I am a bit rusty on this, so sorry if I am a bit off the mark. In BIDS 2005 report parameters and query parameters are different. It...

Are you pulling the list of parameter values from a query?

Great article. Short, easy to understand, and helpful. Great follow on discussion to review some of the finer points of indexes and when to create & modify. ...

jocularity:-D

Good question thanks. I had to read just a bit to confirm what I thought I knew. Keep pushing newer features with QoTD, it helps us all stay/get...

So if you execute the sp in a query window it will be

EXEC spName Parm1, Parm2, Parm3

but since you are not providing parm 2 or 3 you are essentially using

EXEC...

Ray K (7/22/2010)

1.21 Gigawatts?!?!?!?!?

I'm sure in 1985 you can get plutonium at your corner store,...

November 5, 1955.

The day Doc Brown came up with the idea for the Flux Capacitor.

Good question.

Filtered index....who knew.