I have a Power Table that the user can customize by selecting which columns to display. I would like to generate and print a report with the exact configuration and data. Is there a way to get the columns selected for display in the Power Table to the Report? Any ideas would be greatly appreciated. I am working with v7.8.2.
The Power Table’s View Dataset has the data (and columns) selected for view. system.dataset.getColumnHeaders can get you the column names from that dataset, which you could feed in as parameters to a report through system.report.execute (or system.report.executeAndDistribute). Not sure how you’re going to deal with variable column names in your report design, though… maybe return all the columns in the query and use the columnHeader parameter to toggle visibility and column width?