Category: | Feature request |
Priority: | High |
Status: | Feedback Requested |
Project: | Severity: | Minor |
Resolution: | Open |
|
Component: | Reproducibility: | Not Attempted |
Assigned to: |
Hi,
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,
Yann
v6.4.2
2 Comments:
Does anyone have an idea to choose the order of the columns ?