Start Date / End Date using Parameters

[Jason]

I am trying to set up a Start Date / End Date Parameter for a report based on the following example but I can't get it to work. 

http://www.telerik.com/blogs/telerik-reporting-filtering-your-reports-using-report-parameters

Using the AdventureWords DB, I setup the parameters and filters per the example for Employee Hire Date and Employee ID.

If I attach the DataSource to the Report it returns all results not the filtered ones. If I remove the DataSource from the report it doesn't return any results.

Can you provide a demo of how it should be configured.

Thank you,

Jason

[Stef]

Hi Jason,

The linked blog post is out-dated.

If your intent is to use Telerik Reporting, details how to start creating Telerik Reports and display them in viewers are available in the Quickstart help section. For the purpose, my recommendation is to start with the provided Report Designers. The overview articles contain descriptions of the designers UI.

To start test to create a new ClassLibrary project with the minimum system requirements of Telerik Reporting, and add a new item (Best practices).  To connect your data, you can use any of the reporting data source components, where you can use report parameters to control the data retrieval e.g. SqlDataSource Wizard step 4 which is based on Using Parameters with the SqlDataSource component.


There are local demos installed by default under C:\Program Files (x86)\Telerik\Reporting Q2 2015\Examples, where you can see most of the features of Telerik Reporting.


Let us know if you need any further help.

Regards,
Stef
Telerik

[Jason]

Hi Stef,

Thank you for the response. I have read all of the documentation and viewed the demos. I have created about 15 reports using different parameters and expressions but I still can not get the Start Date / End Date to work. I could not find a demo where Telerik has a Start Date / End Data for an example. Do you know of a working Telerik demo that demonstrates how a Start and Stop Date works on a report? I attached screenshots of all my settings. Do you see any setting that does not look correct?

[Jason]

I figured it out. I was using the wrong syntax in my SQL statement. My WHERE should have been:

WHERE [HumanResources].[Employee].[HireDate] BETWEEN (@Start_Date) AND (@End_Date)

 

Thanks again for your help​