Save to Excel (data only) inserting empty columns

[sandynith]

If I try to save a report to 'Microsoft Excel' with 'Export Data only' option then the saved report has empty or blank columns in it.

Steps to reproduce:
+ Open the 'Simple List' report from the 'Demo for WPF' reports.
+ Click Save - Microsoft Excel file - Under settings select 'Export Data only' option - click ok and open the saved report.
+ You will notice that the saved report has two empty columns.

I have seen this problem in our reports as well. When we save to excel we just export the data only.

We haven't seen this problem in 2013 releases (or in early 2014 release). Please have a look and advice me on this.

Thanks,
Sandeep

[HighAley]

Hello.

The same issue was in previous versions.
The columns are made for the while report. Unfortunately, it's impossible to remove them if you use Data Only option.

Thank you.

[sandynith]

Thanks Aleksey for your reply.

>> The columns are made for the while report.
Could you please explain what do you mean here?

>> Unfortunately, it's impossible to remove them if you use Data Only option.
Do you know any workaround for this problem (other than deleting empty columns manually )

[HighAley]

Hello.

>> The columns are made for the while report.
Could you please explain what do you mean here?

Sorry, I meant that the columns in Excel file are created for the whole report. Like if you don't select Data Only option.

>> Unfortunately, it's impossible to remove them if you use Data Only option.
Do you know any workaround for this problem (other than deleting empty columns manually )

You could follow the suggestions from How to Create Report for Export? article.

Thank you.