This is a migrated thread and some comments may be shown as answers.

parameter with 2 date time pickers

4 Answers 65 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Melvin Francisco
Top achievements
Rank 1
Melvin Francisco asked on 05 Dec 2016, 09:06 PM

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.

4 Answers, 1 is accepted

Sort by
0
Accepted
Stef
Telerik team
answered on 06 Dec 2016, 04:08 PM
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
0
Melvin Francisco
Top achievements
Rank 1
answered on 07 Dec 2016, 02:35 AM

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.

0
Melvin Francisco
Top achievements
Rank 1
answered on 07 Dec 2016, 03:31 AM

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.

0
Stef
Telerik team
answered on 07 Dec 2016, 09:31 AM
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
Tags
Report Designer (standalone)
Asked by
Melvin Francisco
Top achievements
Rank 1
Answers by
Stef
Telerik team
Melvin Francisco
Top achievements
Rank 1
Share this question
or