Tuesday, November 19, 2013

Over lapping of views when exported to Excel


One of the major issue what everyone faces is the 'Overlapping of the Chart and table or filter view when downloaded to Excel'


So, here is a small workaround to resolve the issue:

Place a narrative text between the chart and the table/pivot table view. With the following code:
<span style="display:none">[br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/][br/]</span>


Check the HTML and also the number of [br/] tags depends on the requirement.

Save it and export the reports.  You will see the chart and the table view separately.
 

No comments:

Post a Comment