Jump to content

Specify Which Columns to Download on Deployed Tabular Report


Recommended Posts

Is there a way to specify which columns will be included in the download of a tabular report?

For context, I have a tabular report and I wanted to conditionally hide columns that were not being used depending on the filtering of the data. I did this by creating calculated fields that would specify if a column was being used, and hide it if it was not being used, sort of like what the article below walks through. That works well for viewing the table, but when I make the table downloadable all the helper columns are also downloaded. So, is there a way to specify which columns I would like to be included in the download? Or is there a better way to conditionally hide columns that does not involve creating a bunch (in my case, 30) of calculated fields?

 

Link to comment
Share on other sites

Hi @DrSimi,

Thank you for sending this over. Looking at that post, it looks like that would have the same issues I am running into currently, it would just use JavaScript instead of CSS. If calculated fields are needed as helper cells, then we are hiding them, then they would still be present when downloading the table. Would there be any way to hide these columns without the helper calculated fields, or to have them not be included in the data download?

Any help or ideas would be greatly appreciated!

Link to comment
Share on other sites

hi @Connonymous,

The only way I can think of, is to not use Calculated Fields for the "helper cells" at all, if your use case allows it. This means you will need to code all the conditions in your current Calculated Fields in JavaScript, then hide the columns with that too. This method has limitations in that you cannot perform certain calculations that rely on the database, but may work for most cases.

In any case, I don't know of any method to hide columns in the download, it always displays everything as configured in the DP settings.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...