Dynamic Table for Reports

[Sergei_Kitov]

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?

Thanks

[pturmel]

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:

How to manage the table component of a report when column number can change at runtime

This approach is probably the best you can do: TL/DR: Reporting tables cannot have variable numbers or columns, nor variable column names. You can fake it to a certain extent by hiding columns and using other variables for the column names in the table header. Consider using a script data source to transform any given dataset to have the needed column names while populating the variables for the column headers from that given dataset. And hiding the unused columns. Good luck.