Working with 8.1.0.
I am attempting to make a report that shows equipment downtime where the alarms are categorized into (potentially) 10 different categories.
The report will look like this -
The tables labeled 1 and 2 are the firs two categories that could likely appear. It’s possible that there will only be one category (and thus one table) or up to 10 categories requiring 10 tables.
My first idea is that I am going to have to make 10 reports, 1 with 1 table, 1 with 2 tables, etc, and then when the user opens up the report preview in Vision, I see how many datasets I get back and choose the report with the appropriate number of tables.
Alternatively I was thinking (and mostly hoping) a table group with 10 tables with hardcoded data keys, many of which would be left blank if say there only 3 categories were used, and hope that the empty ones would just not appear at all.
Has anyone done anything like this and what was your approach?