# Reporting Module Perspective

**URL:** <https://forum.inductiveautomation.com/t/reporting-module-perspective/36637>\
**Category:** Ignition\
**Created:** [July 13, 2020, 2:02pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637 "2020-07-13T14:02:39Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![amalric.sterlin](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@amalric.sterlin](https://forum.inductiveautomation.com/u/amalric.sterlin)\
**Post date:** [July 13, 2020, 2:02pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/1 "2020-07-13T14:02:39Z")

</div>

Hello,  
Has anyone succeeded in passing a dataset as a parameter in a report, in the reporting module for Perspective ?  
Is there a trick to be able to show properly the data, and maybe choose what column I want to show ?  
Thanks,

---

<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:** [July 13, 2020, 2:13pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/2 "2020-07-13T14:13:29Z")

</div>

The reporting module’s objects require data with known column names. You will need to script (probably in the report) a transform from a given column name to a new dataset with a fixed column name, then fake out the column header/pen name with the original column name.

This applies to both Vision and Perspective, as reports are always _generated_ in the gateway.

---

<div class="post-metadata">

**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\
**Post date:** [July 13, 2020, 3:14pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/3 "2020-07-13T15:14:32Z")

</div>

I’ve successfully passed in a dataset as a parameter. There isn’t a trick to choose what column(s) you want to display. You will specify what columns you want to display in the design tab of the report.

Demo of selecting which columns to display:

[https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/0/a082458ecc06d662e87bb16fe914fdef05d9b314.mp4](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/0/a082458ecc06d662e87bb16fe914fdef05d9b314.mp4)

Edit; screenshot of Report Viewer Component passing in a dataset via tag binding:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/4/c4ba72fd5eb258892c8fd363f8fb70bea1da7527.png)

---

<div class="post-metadata">

**Author:** ![amalric.sterlin](https://avatars.discourse-cdn.com/v4/letter/a/87869e/32.png) [@amalric.sterlin](https://forum.inductiveautomation.com/u/amalric.sterlin)\
**Post date:** [July 15, 2020, 7:27am UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/4 "2020-07-15T07:27:48Z")

</div>

Thank you for your replies, it is now working 😀

---

<div class="post-metadata">

**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\
**Post date:** [March 29, 2021, 2:34pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/5 "2021-03-29T14:34:02Z")

</div>

How can one pass a dataset into a report as a parameter without going through a gateway tag?

---

<div class="post-metadata">

**Author:** ![code\_skin](https://avatars.discourse-cdn.com/v4/letter/c/43a26b/32.png) [@code\_skin](https://forum.inductiveautomation.com/u/code_skin)\
**Post date:** [March 30, 2021, 2:47pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/6 "2021-03-30T14:47:53Z")

</div>

I’m not sure. Maybe you can construct a dataset through the expression language? The demo in this thread was to show how to select columns from a dataset. Using a tag is my preference when developing new reports. Hopefully this helps!

---

<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:** [March 30, 2021, 2:55pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/7 "2021-03-30T14:55:52Z")

</div>

Did a property binding to a dataset property not work?

---

<div class="post-metadata">

**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\
**Post date:** [March 31, 2021, 12:13pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/8 "2021-03-31T12:13:03Z")

</div>

Thank you both for the responses. I’d like to try to avoid rebuilding a dataset in expression.

Trying to pass a dataset into a report as a parameter in the code below. Nothing comes across in the report which has a dataset parameter. Directly calling the columns of the dataset or just trying to display the raw dataset.

```auto
	ribbon = self.parent.parent.parent.getChild("ContPickedItems").getChild("tblPallets").props.data

	par={
		"ReportDate": system.date.now(),
		"Data": ribbon
	}
	
	system.perspective.openPopup(
		id="qwertyu", 
		view="RibbonReport",
		showCloseIcon=True,
		title="Ribbon Shipment Report",
		viewportBound=True,
		overlayDismiss = True, 
		modal = True,
		params=par)

```

---

<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:** [March 31, 2021, 12:50pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/9 "2021-03-31T12:50:17Z")

</div>

Is there a binding in your popup view on the report viewer pulling the report’s data parameter from the view’s parameter? (In your code, you aren’t passing your parameters to a report. You are passing them to a view.)

---

<div class="post-metadata">

**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\
**Post date:** [March 31, 2021, 1:26pm UTC](https://forum.inductiveautomation.com/t/reporting-module-perspective/36637/10 "2021-03-31T13:26:28Z")

</div>

Sorry, yes. I have a input parameter on the view with the report params bound to it.

Following that trail more closely, my dataset was not coming into my report component params via the expression structure binding. Any idea why that type of binding would nullify a dataset?

Directly binding each param to the view’s input parameter worked.