sql server reporting services: Parameter with @ sign -- sql server reporting services

Parameter with @ sign

Ed
5/31/2007 6:18:00 PM

sql server reporting services:

Hi,
I would like to know under Data Set --> Parameter, do I have to add a @
sign right before the name of parameter? I know I have to use it in SQL like
select * from customers where customerID = @CustomerID. Can I just use
CustomerID in Parameter box or I have to use @CustomerID? which one is a
best pratice?
Any idea?

Thanks

Re: Parameter with @ sign

EMartinez
6/1/2007 11:58:06 PM

[quoted text, click to view]

You can leave the @ sign off of the parameter name (in Dataset ->
Parameters: -> Name column). For consistency purposes, you can leave
the @ sign there; however, it is up to your personal preferences. Hope
this is helpful.

Regards,

Enrique Martinez
Sr. Software Consultant