[#10986] - Dynamic columns based on dynamic SQL query ?

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
yann22300's picture
326
Joined: Apr 29 2015 - 1:10am
Last seen: 1 month 2 weeks ago

2 Comments:

#1
AttachmentSize
Image icon step.png60.77 KB
#2

Does anyone have an idea to choose the order of the columns ?

Feedback
randomness