Merge some cells in the report

jchen · May 15, 2025, 11:50am

Hi there, I'm currently working on the report module's table display. My data source (from python script not SQL) returns values in the following format:

This presentation doesn't look very user-friendly. Would it be possible to merge the "Shift" and "Date" cells to appear as shown below?

PGriffith · May 15, 2025, 4:55pm

You might be able to achieve this with a crosstab table: CrossTab and Simple Tables | Ignition User Manual

Though, to be honest, I don't think I've ever gotten a crosstab to work correctly. Another option would be to change to using 'unstructured' rows and manually setting up the text shapes within that row to make your hybrid rows - but that won't automatically scale to multiple duplicated rows.

kvane · May 15, 2025, 5:28pm

The default Table component does love to return rows.

If you are more so looking to group the rows more appropriately consider turning on Grouping:

If your data is that simple:

Select Table
Click the Grouping "+" button, add the Shift column
Uncheck the Shift column Row > Details checkbox
From there the preview will have them grouping which may be more along the lines of what you're going for:

jchen · May 16, 2025, 5:25am

Thanks for all the suggestions.
Finally got something like this, use script to blank out the duplicate data and use the table row versioning to hide either the top or bottom border.

But it doesn't center vertically for "Shift" and "Date" because the row is actually there, it's just not displayed.