So, you have created RTF template which has output in excel form.
But in the output, some of the columns are shown merged. Please see below column G and H are merged under SDO header -
But the users don't want merged columns and you don't see this in RTF template at design time .. So how to fix this ?
Here are the steps -
- Navigate to BI Publisher Catalog
- Go to Report Properties - > Formatting
- Look for the property 'Keep Values in same column'
- Set the value to True
- Save
- Run the report and you will see the columns are no more merged.