parameter with 2 date time pickers

[Melvin Francisco]

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.

[Stef]

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

[Melvin Francisco]

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.

[Melvin Francisco]

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.

[Stef]

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