I'm new to Telerik Reporting so forgive me for my ignorance. I read this article about using SQL parameters in a report:
But I can't get it to work and I'm wondering what I'm doing wrong. I have a simple query that looks something like this:
"SELECT order_date, order_cost, order_customer</p><p>FROM orders</p><p>WHERE order_date = @OrderDate"
And I set the Parameter in the database connection Name: @OrderDate; Db Type: Date; Value: = Parameters.Order_Date.Value
In the report, I created one ReportParameter, and I called it "Order_Date". It is set to AutoRefresh: True; Type: DateTime; Value: 1/6/2019; Visible: True.
When I try to execute the query from within the SQL box where I enter the parameter information, it works. But when I try to Preview the report, the wheel just turns forever and nothing ever displays and I get no error. Can someone help me figure out what I'm doing wrong?