Is there a way to generate a report based on a dynamic SQL query to get dynamic columns? (But not only using the 'WHERE' part)
I could left the entire SQL query and used parameters and 'Print When Expression' in a Table component but I need users to select the order of fields.
I think my best chance is to use the Table component but I don't see how to leave users the order of columns.
By the way : how to pass a full SQL query in a parameter ? The fields names will generate at runtime ?
Thanks in advance,