# Set default value of a report's dataset parameter to empty

**URL:** <https://forum.inductiveautomation.com/t/set-default-value-of-a-reports-dataset-parameter-to-empty/11861>\
**Category:** Ignition\
**Created:** [June 24, 2016, 7:36pm UTC](https://forum.inductiveautomation.com/t/set-default-value-of-a-reports-dataset-parameter-to-empty/11861 "2016-06-24T19:36:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![DougSN](https://avatars.discourse-cdn.com/v4/letter/d/a9adbd/32.png) [@DougSN](https://forum.inductiveautomation.com/u/DougSN)\
**Post date:** [June 24, 2016, 7:36pm UTC](https://forum.inductiveautomation.com/t/set-default-value-of-a-reports-dataset-parameter-to-empty/11861/1 "2016-06-24T19:36:01Z")

</div>

I have a report (using the new report designer) with three dataset parameters. They are not bound to a SQL query because they are set when the window loads. If I don’t set something as the default value of the datasets within the report designer, it fills up the gateway’s console with warning messages. I would like the default value to be an empty dataset so that nothing is accidentally displayed on the screen if it takes a moment for the window to load the data and set the parameters. What is the best way to create an empty dataset?

I tried using the expression language’s toDataSet() function, but it doesn’t like my syntax. What I have gotten to work is creating a Client tag called EmptySet and setting the paramater’s default value to {[Client]EmptySet}. It works, but I would think there must be a better way to do this.

Thank you for any help offered!

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [June 24, 2016, 8:19pm UTC](https://forum.inductiveautomation.com/t/set-default-value-of-a-reports-dataset-parameter-to-empty/11861/2 "2016-06-24T20:19:39Z")

</div>

Try this expression:`runScript('system.dataset.toDataSet([],[])')`

---

<div class="post-metadata">

**Author:** ![d.laquidain](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@d.laquidain](https://forum.inductiveautomation.com/u/d.laquidain)\
**Post date:** [May 18, 2018, 1:37pm UTC](https://forum.inductiveautomation.com/t/set-default-value-of-a-reports-dataset-parameter-to-empty/11861/3 "2018-05-18T13:37:49Z")

</div>

I´ve test that expression in 7.9.5 and runs perfect but in 7.8.5 I receive the following message in design section "Error parsing default value expression for parameter “DataIn” – java.lang.NullPointerException

Is there any limitation with this expression in 7.8.5?

Regards