Dynamic Table for Reports

Hello all!
I want to create a report that would show the number of faults over a certain period of time. I ran into the problem that in -Reporting Module- it is impossible to explicitly create a dynamic table. For example, if I need data for the period from January 12, 2021 to January 14, 2021, then I need 3 columns with data, if I need it from January 12 to January 15, then 4 columns, and so on. Are there any ideas other than creating tables for all possible dates?

image

Thanks

You don’t have to make multiple tables. You do have to use a table with enough columns for your worst case, and then hide the extras. Displaying variable layout datasets generally requires a script datasource to re-arrange things into a predictable format. Start here:

1 Like