parameter with 2 date time pickers

5 posts, 1 answers
  1. Melvin Francisco
    Melvin Francisco avatar
    6 posts
    Member since:
    Nov 2016

    Posted 05 Dec 2016 Link to this post

    Hi again, i keep on learning about the usage of this reporting tool, been happy with it so far now ive come to another issue, what im trying to achieve is, i have a field on my database named InstallationDate which is a datetime data type, now in parameters i would like to have 2 date time pickers where i can choose the starting date where to start from that field and an end date to choose from and with that chosen display the resulting rows in the report.

    How can i achieve that in the standalone designer?

    Thanks again.

  2. Answer
    Stef
    Admin
    Stef avatar
    3610 posts

    Posted 06 Dec 2016 Link to this post

    Hi,

    You can add two report parameters of type DateTime - How to: Add Report Parameters. The editors in the Standalone Report Designer does not include a time part, but this can be applied for the used HTML5 viewer's parameters area - How To: Create a Custom Parameter Editor.

    Once you have the report parameters, you can:
    1. Filter data on report level, through the data item's Filters collection.
    2. Filter data on retrieval, by using a parameterized data-retrieval method. The method's arguments can be mapped to the report parameters e.g. the last example in Using Parameters with the SqlDataSource component.
    For more details, please check Filtering Data.

    Regards,
    Stef
    Telerik by Progress
    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. Melvin Francisco
    Melvin Francisco avatar
    6 posts
    Member since:
    Nov 2016

    Posted 06 Dec 2016 in reply to Stef Link to this post

    Hi Stef, thanks for your reply. I was playing with the report designer and i found a way to do it way easier without having to leave the standalone designer, just in case this is all i did and it worked fine!

    Thanks again.

  4. Melvin Francisco
    Melvin Francisco avatar
    6 posts
    Member since:
    Nov 2016

    Posted 06 Dec 2016 in reply to Stef Link to this post

    New question, where can i edit the html reportviewer template?

    for example to not take 100% of the screen so i can place a footer.

  5. Stef
    Admin
    Stef avatar
    3610 posts

    Posted 07 Dec 2016 Link to this post

    Hello,

    There is no need to modify the HTML template of the viewer. The HTML5 Viewer's content is placed in a DIV element with the ID of the viewer. The content size will change based on the size of the DIV element. You can place CSS on the page like:
    #reportViewer1
              {
                 width:100%;
                 height:800px;
              }


    In case you need to apply other changes in the viewer's HTML template, please check Providing Templates.

    Regards,
    Stef
    Telerik by Progress
    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
Back to Top