# Multiple rows for one date in a report table

**URL:** <https://forum.inductiveautomation.com/t/multiple-rows-for-one-date-in-a-report-table/28688>\
**Category:** Ignition\
**Created:** [October 1, 2019, 8:57am UTC](https://forum.inductiveautomation.com/t/multiple-rows-for-one-date-in-a-report-table/28688 "2019-10-01T08:57:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![silverbacknet](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/silverbacknet/32/7385_2.png) [@silverbacknet](https://forum.inductiveautomation.com/u/silverbacknet)\
**Post date:** [October 1, 2019, 8:57am UTC](https://forum.inductiveautomation.com/t/multiple-rows-for-one-date-in-a-report-table/28688/1 "2019-10-01T08:57:21Z")

</div>

Is it possible to have multiple rows in a report table from a single datasource row, or merge rows with the same date? I put together this mockup to show what I mean; it’d be even better if the date could be centered vertically. I know there’s lots of workarounds, I’m just wondering if this is possible.

 ![water%20sketch](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/be78f8841ac47541a99f0e31382a23595b1ae3ea.png)

---

<div class="post-metadata">

**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\
**Post date:** [October 1, 2019, 1:39pm UTC](https://forum.inductiveautomation.com/t/multiple-rows-for-one-date-in-a-report-table/28688/2 "2019-10-01T13:39:21Z")

</div>

Depends on your query but if it is MS SQL, you could CAST the Date to date and then group by it.

```auto
SELECT 
CAST(MyDateField as date) as RecordDate,SUM(Well1) as Well1,SUM(Well2) as Well2
GROUP BY CAST(MyDateField as date)

```

---

<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:** [October 1, 2019, 3:19pm UTC](https://forum.inductiveautomation.com/t/multiple-rows-for-one-date-in-a-report-table/28688/3 "2019-10-01T15:19:11Z")

</div>

You could do this with a single table with unstructured rows, and a simple table inside of it, but it’s not going to be “pretty”. It would probably be easier to maintain by putting the records together as @MMaynard suggested, then “blanking out” the Site 2 date cell on the alternate row version.