i am trying to build a report that a user can customize. I am using the column selector under the reporting tab to let the user pick which columns to include in the query.
I am building a query this way, so any user can build the query used as the data keys in a report.
on my window i have:
and a report viewer
See photo for a better explanation
the data from the report viewer should look like the photo, but the columns in the column selector tool are output as a dataset not anything i can use in a query. any ideas how to easily get around this.