Hi, I am trying to add a parameter to the a report using the report module.  My query example is simple.
Select * from Customers where CustomerID = @url_CustomerID
However I am receiving the following error message:
There was an error executing the data source: There is an error in your SQL at line 7: Must declare the scalar variable "@url_CustomerID".
I am unclear how to implement a parameter into an SQL query.  Do I need to use the Allowed URL Parameters input field?  Can you give me an example using my query on how I can implement this?  Thank you

hi .sir
I also have this problem..
First...I write in Allowed Url Parameter text box " @moduleID"
and in Query text box " Where ModuleID=@moduleID"
I get this result " The report query return no result"
But I dont add exactly parameter as @moduleID=442
Where can I add exactly value to my parameter?