Prevent Merging Columns in Excel Output using RTF template
Prevent Merging Columns in Excel Output using RTF template

 1,995 total views

While creating a BI Publisher Report, we develop templates using RTF template as it provides multiple output formats like Interactive Mode, PDF, XLSX, XML, CSV etc which are not possible with any other templates like XLS, E-TEXT, etc. 

One problem most of the people face is when they try to download the excel output using RTF template, the excel output contains merged columns and hence the end users cannot apply filters and get meaningful data out of the output. Here is the solution for the issue. There is a setting available in BI Publisher Report properties where we can set the property.



After clicking edit, click on properties at the right top.

Click Save to save the changes.

Once this change is done, now run the report again, then the output will not have any merged columns and the end users can happily filter or sort the data.

If you have any questions, please feel free to reach out to me by posting in comments section.

If you are interested in learning Fusion Technical tools go through this post

If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has 2 Comments

  1. Vignesh

    i dont see any report properties option in the BI Publisher addin for Word..

  2. Bhushan Gupta

    Wow. It was always a pain as I was not able to Sort or filter. Thanks for documenting this option. Really useful

Leave a Reply