nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to prevent hidden charts and tables to be exported to PDF

Saroj1234

Hi, 
 
I have 3 charts and 3 tables bound to different datasets in my report. 
Based on user input, I'm showing any one pair of table and chart at any given time and hiding the other 2 pairs. There are no parameters in the report as the user selection drop downs are created by HTML data element. 
This means all the report elements are already rendered when the report is shown to the user (with all the graphs and tables hidden initially). 
 
I'm setting the display by using below in javascript if user selects "bar chart": 
<pre class='_prettyXprint _lang-auto _linenums:0'>[b]
document.getElementById("BarChart").style.display="block";[/b]
document.getElementById("LineChart").style.display="none";
document.getElementById("PieChart").style.display="none";
</pre>
 
The problem is when I'm exporting the report as PDF, all the hidden charts are also getting exported. 
Is there a way I can avoid exporting hidden elements of the report? 
 
I did find below on some post in this forum to be put in beforeFactory: 
reportContext.getDesignHandle().findElement("mychart").setProperty("allowExport", false); 
 
But where should I put this in my report which has no parameters? Also, can this be done in the same javascript in HTML text element where I'm hiding or unhiding tables/charts? 
 
Please help. 
Saroj

Find more posts tagged with

Comments

Saroj1234

Just to test, I set the allow export property in Advanced tab to "false" but still all the report charts and tables are getting exported.

mluggen

Hi Saroj, 
 
The script you are using is changing the HTML in the Browser when viewing. For the PDF output you need to change the report already in this generation phase. This you can do in the "Script" tab which is where also "Layout" and "Master Page" is. 
 
If you for example focus the whole page in the Layout and switch to Script you can choose the beforeFactory() function. 
 
To hide an element try this: 
<pre class='_prettyXprint _lang-auto _linenums:0'>reportContext.getDesignHandle().findElement("test").setProperty("display", "none");</pre>
 
HTH Michael