Ron Renninger
asked on
sql views
I am using crystal report to print a packing slip. I found a way to use a database view to do it. The question i have is i wan it to be able to have the program to have a variable to use in a where clause
(@OrderId Int)
As
select billName, billAddress1, billAddress2
from Orders
Where OrderId = @OrderId
Will this work or do i need to do something else
(@OrderId Int)
As
select billName, billAddress1, billAddress2
from Orders
Where OrderId = @OrderId
Will this work or do i need to do something else
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
https://www.tutorialspoint.com/crystal_reports/crystal_reports_parameters.htm