Start Date / End Date using Parameters

4 posts, 1 answers
  1. Jason
    Jason avatar
    4 posts
    Member since:
    Apr 2015

    Posted 18 Aug 2015 Link to this post

    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

  2. Answer
    Stef
    Admin
    Stef avatar
    3036 posts

    Posted 21 Aug 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. DevCraft banner
  4. Jason
    Jason avatar
    4 posts
    Member since:
    Apr 2015

    Posted 21 Aug 2015 in reply to Stef Link to this post

    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?

  5. Jason
    Jason avatar
    4 posts
    Member since:
    Apr 2015

    Posted 21 Aug 2015 Link to this post

    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​

Back to Top