# Reports - Row Versioning with parameters

**URL:** <https://forum.inductiveautomation.com/t/reports-row-versioning-with-parameters/15275>\
**Category:** Ignition\
**Tags:** ignition79\
**Created:** [September 7, 2017, 6:17pm UTC](https://forum.inductiveautomation.com/t/reports-row-versioning-with-parameters/15275 "2017-09-07T18:17:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![patrick.maltais](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/patrick.maltais/32/3958_2.png) [@patrick.maltais](https://forum.inductiveautomation.com/u/patrick.maltais)\
**Post date:** [September 7, 2017, 6:17pm UTC](https://forum.inductiveautomation.com/t/reports-row-versioning-with-parameters/15275/1 "2017-09-07T18:17:23Z")

</div>

I would like to hide some rows based on an option passed as a parameter to the report.

Lets say I have a parameter named “showType2” and the this option is controlled from the calling window and passed to the Report Viewer.

In the report, there’s a table with data containing a field named fkID\_Type which can have values 1 to X. This table also has a row version called INVISIBLE which is invisible.

I want to show the row when showType2 is True (the parameter is a boolean) AND fkID\_Type is equal to 2.

What is the syntax for the Row Versionning property on the table?

I have in mind something like this: `{showType2==1}&&fkID==2?"Standard":"INVISIBLE"`

But it’s not working.

Any help would be appreciated

Thanks

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 7, 2017, 7:13pm UTC](https://forum.inductiveautomation.com/t/reports-row-versioning-with-parameters/15275/2 "2017-09-07T19:13:40Z")

</div>

The correct keychain expression should be something like:  
`showType2==1 && fkID == 2?"Standard":"INVISIBLE"`

No curly braces should be needed. See [https://docs.inductiveautomation.com/display/DOC79/Key+Calculations](https://docs.inductiveautomation.com/display/DOC79/Key+Calculations) for more info.

---

<div class="post-metadata">

**Author:** ![patrick.maltais](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/patrick.maltais/32/3958_2.png) [@patrick.maltais](https://forum.inductiveautomation.com/u/patrick.maltais)\
**Post date:** [September 7, 2017, 7:47pm UTC](https://forum.inductiveautomation.com/t/reports-row-versioning-with-parameters/15275/3 "2017-09-07T19:47:05Z")

</div>

The showType parameter is of type Boolean. Should I compare with True, true? Or is comparing it to 1 is enough?