# Reporting Table with Many Assets as rows?

**URL:** <https://forum.inductiveautomation.com/t/reporting-table-with-many-assets-as-rows/36930>\
**Category:** Ignition\
**Created:** [July 22, 2020, 3:51am UTC](https://forum.inductiveautomation.com/t/reporting-table-with-many-assets-as-rows/36930 "2020-07-22T03:51:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![donfmorrison](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/donfmorrison/32/15142_2.png) [@donfmorrison](https://forum.inductiveautomation.com/u/donfmorrison)\
**Post date:** [July 22, 2020, 3:51am UTC](https://forum.inductiveautomation.com/t/reporting-table-with-many-assets-as-rows/36930/1 "2020-07-22T03:51:18Z")

</div>

Hello! Pretty new to Ignition and I’m trying to create a report that would act as a daily summary/report to show status of many assets in one table. I could use some pointers, advice, and/or direction on how to get started!

I have some tags that look like this in the Tag Browser:

```auto
- Tags
   - Assets
      - Asset 1
         - Datapoint 1
         - Datapoint 2
         - Datapoint 3
      - Asset 2
         - Datapoint 1
         - Datapoint 2
         - Datapoint 3
      - Asset 3
         - Datapoint 1
         - Datapoint 2
         - Datapoint 3

```

The datapoints on each asset are very consistent wrt naming.

I’d like to be able to create a reporting table that looks like this:

| Asset | Datapoint 1 | Datapoint 2 | Datapoint 3 |
| --- | --- | --- | --- |
| Asset 1 | 45 | 76 | ON |
| Asset 2 | 41 | 84 | OFF |
| Asset 3 | 52 | 32 | STANDBY |

Some of the values will eventually be daily averages, max/min; but, I thought starting with a table of just current values might be more straightforward? Ultimately, I want to create a daily CSV from this reporting dataset, but I figure creating the report is step 1!

I didn’t see anything in Inductive University that was similar and I must not be searching for the right terms because I’m not having much luck finding examples of this kind of report.

Can someone help me get going on this?

---

<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 22, 2020, 10:33am UTC](https://forum.inductiveautomation.com/t/reporting-table-with-many-assets-as-rows/36930/2 "2020-07-22T10:33:23Z")

</div>

You are going to want to use a scripted data source within the report designer. You would bulk read (system.tag.readBlocking) all of the tags you wish to display, and construct a dataset (system.dataset.toDataSet) with the rows arranged as you wish. Then you can use that dataset in the design tab of the report as if it came from your database.