Just passing one parameter on a SP in reporting services 1

[Chance1234]

I have a SP which accepts 3 values,

@dtStart
@dtEnd
@dtDept

I want to be able to pre fill in teh dtDept but leave the dtStart and dtEnd as parameters which the user can defined.

I ahve tried adding this informatoin to the parameters tab on the datasource, but this does not seem to have the required effect.

What am i missing ?

Chance,

F, G + 1MSTG

 

[AlexCuse]

If dtDept is always going to be the same, maybe you could just assign it a default value in the database level?

You can also assign your default value (or expression) and indicate it should be "non-queried". Then check the box that says "Hidden" and your users will not know about it.

Does this work, or is there more to it?

(I've only tested this on SSRS 2005)

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[memdiscount]

Hi;

You can set default value in your Stored Procedure parameter.

Thanks

 

[Chance1234]

cheers alex, was looking in the wrong place.

Chance,

F, G + 1MSTG

 

[AlexCuse]

Yeah, a lot of that stuff is very confusing at first (was to me anyway, I'm not exactly the sharpest knife in the drawer).

Glad you got it sorted!

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page