# Passing Parameters in Report (7.9.10)

**URL:** <https://forum.inductiveautomation.com/t/passing-parameters-in-report-7-9-10/28440>\
**Category:** Ignition\
**Created:** [September 20, 2019, 6:01pm UTC](https://forum.inductiveautomation.com/t/passing-parameters-in-report-7-9-10/28440 "2019-09-20T18:01:28Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [September 20, 2019, 6:01pm UTC](https://forum.inductiveautomation.com/t/passing-parameters-in-report-7-9-10/28440/1 "2019-09-20T18:01:28Z")

</div>

For the life on me I can’t figure out how to pass parameters to my report.

I have a simple report with 2 parameter **Start** and **End** they are both formatted like this.  
dateFormat({Start}, ‘yyyy-MM-dd HH:mm:ss’)  
dateFormate({End}, ‘yyyy-MM-dd HH:mm:ss’)

Here is my Query:  
Select Indiana\_Daily, Helm\_Daily from DailyProd where t\_stamp BETWEEN ‘{Start}’ AND ‘{End}’

Now this query give an error as is but if I manually plug in the date as ‘2019-09-13 00:00:00’ it will run  
in the report preview (so i’am assuming this error is caused by no actual date YET!)

Now on my report window I have 2 popup calendars and I have the “Format String” property set to format  
like yyyy-MM-dd HH:mm:ss and I have this bound to the Start property of my report.

But it does not work.

Please can someone point me in the right direction, I have watched all of the videos. I don’t know if it’s a data format problem or I’m not binding to the right property.

Thanks

---

<div class="post-metadata">

**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\
**Post date:** [September 20, 2019, 6:13pm UTC](https://forum.inductiveautomation.com/t/passing-parameters-in-report-7-9-10/28440/2 "2019-09-20T18:13:59Z")

</div>

> [@dcamp1](#):
>
> dateFormate({End}, ‘yyyy-MM-dd HH:mm:ss’)

You want that "E" in there after format? Or typo?

also, you can use 3 backticks ``` to encase code like this...

```auto
var = "Hello World"
print var

```

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [September 20, 2019, 7:58pm UTC](https://forum.inductiveautomation.com/t/passing-parameters-in-report-7-9-10/28440/3 "2019-09-20T19:58:59Z")

</div>

Besides the spelling issue wking pointed out, this seems like a circular reference – your Start parameter refers to itself, as does your End parameter. If you look at the docs for [Basic SQL Query](https://docs.inductiveautomation.com/display/DOC80/Basic+SQL+Query), you’ll see that the example is not referring to itself, but instead refers to one of the previously defined parameters.

---

<div class="post-metadata">

**Author:** ![dcamp1](https://avatars.discourse-cdn.com/v4/letter/d/dc4da7/32.png) [@dcamp1](https://forum.inductiveautomation.com/u/dcamp1)\
**Post date:** [September 20, 2019, 8:59pm UTC](https://forum.inductiveautomation.com/t/passing-parameters-in-report-7-9-10/28440/4 "2019-09-20T20:59:21Z")

</div>

Yes, I finally figure out what I was doing. I needed to refer back to StartDate and EndDate once I did that and went back to the report viewer to bind my properties everything worked.

Thanks