• Post category:BI Publisher
  • Post comments:2 Comments
  • Post last modified:June 12, 2020
  • Reading time:3 mins read
You are currently viewing Prevent Merging Columns in Excel Output using RTF template
Prevent Merging Columns in Excel Output using RTF template

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.

merge1 - Prevent Merging Columns in Excel Output using RTF template

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

merge2 - Prevent Merging Columns in Excel Output using RTF template

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.

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

  • In visible box by plugintheme