hi every1
i am using sql server,vb and crystal report ;i have made stored procedure and sending variable through vb and crystal report to that pro but i want to do the same with view i.e i wanna use view instead of stored pro ;but i am unable to declare variable over there plz help me out and write a code that how to declare a variable over there
thanxxx

How are you access the view?

Like SELECT Collist FROM myView?

Why not just do

SELECT Collist FROM myView WHERE Col1 = 'your criteria'

How do you call your view...

What parameter do you want to pass

consider creating an inline function that accepts a parameter and call that in a query.
like a view with parameters

[Books Online] user defined functions