# Filtering report data in a perspective view **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [July 24, 2023, 5:59pm UTC](https://forum.inductiveautomation.com/t/filtering-report-data-in-a-perspective-view/76803 "2023-07-24T17:59:38Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Marc-Antoine\_Thibaul](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@Marc-Antoine\_Thibaul](https://forum.inductiveautomation.com/u/Marc-Antoine_Thibaul)\ **Post date:** [July 24, 2023, 5:59pm UTC](https://forum.inductiveautomation.com/t/filtering-report-data-in-a-perspective-view/76803/1 "2023-07-24T17:59:38Z")
Hi, I use a report viewer in a perspective view and I want the user to be able to select for which date he wants to see the data in the report from the perspective view. Is there a simple way to perform this ? Here is an example of a row in my report ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/c/6ce2cecb520826b79431ee9dac0f25f040daa40d.png) ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [July 24, 2023, 6:08pm UTC](https://forum.inductiveautomation.com/t/filtering-report-data-in-a-perspective-view/76803/2 "2023-07-24T18:08:43Z")
Create a start and end date time input and pass those values to the report viewer as parameters and use them in the reports data query. ---
**Author:** ![Marc-Antoine\_Thibaul](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@Marc-Antoine\_Thibaul](https://forum.inductiveautomation.com/u/Marc-Antoine_Thibaul)\ **Post date:** [July 24, 2023, 6:38pm UTC](https://forum.inductiveautomation.com/t/filtering-report-data-in-a-perspective-view/76803/3 "2023-07-24T18:38:07Z")
Hi , how do you pass the value to the parameter in a querry ? Do you use a tag ? ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [July 24, 2023, 6:54pm UTC](https://forum.inductiveautomation.com/t/filtering-report-data-in-a-perspective-view/76803/4 "2023-07-24T18:54:11Z")
Here's an example from one of my meter data reports. I have a date time input for the start and end date time parameters. There is a button that will set the start and end times to the parameters but you could just directly bind them also. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d80f591648f91f322b06af6c0165d32f1d5634dd.png) This is the data query for the report ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/d/fddb6aafe59c5714dc75d9630021ae69c7297939.png) ---
**Author:** ![Marc-Antoine\_Thibaul](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@Marc-Antoine\_Thibaul](https://forum.inductiveautomation.com/u/Marc-Antoine_Thibaul)\ **Post date:** [July 25, 2023, 3:44pm UTC](https://forum.inductiveautomation.com/t/filtering-report-data-in-a-perspective-view/76803/5 "2023-07-25T15:44:54Z")
I do not understand how do you link the end & start date input from the perspective to the querry, can you elaborate please ? Thank you ---
**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\ **Post date:** [July 25, 2023, 3:54pm UTC](https://forum.inductiveautomation.com/t/filtering-report-data-in-a-perspective-view/76803/6 "2023-07-25T15:54:28Z")
In my 2nd screenshot you can see my two parameters "start" and "end", i created them by clicking the plus icon up by the parameters area in the top left. They are referenced in the query by the question marks. In the perspective view you can bind the date time inputs to the report viewer's "start" and "end" parameters or assign their values on a button event like i did. Hopefully that answers your question, if not let me know what specific part you are having trouble with. ---
**Author:** ![user66](https://avatars.discourse-cdn.com/v4/letter/u/b487fb/32.png) [@user66](https://forum.inductiveautomation.com/u/user66)\ **Post date:** [July 25, 2023, 4:47pm UTC](https://forum.inductiveautomation.com/t/filtering-report-data-in-a-perspective-view/76803/7 "2023-07-25T16:47:03Z")
You can go through these two videos as well. > **[Parameters Video at Inductive University](https://inductiveuniversity.com/videos/parameters/8.1)** > > Parameters are similar to custom properties on a Vision component. Learn how to create and configure default values for parameters. > **[Reports in Perspective Sessions Video at Inductive University](https://inductiveuniversity.com/videos/reports-in-perspective-sessions/8.1)** > > Learn how to embed your reports directly in a Perspective Session.