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
Save to Excel (data only) inserting empty columns
Save to Excel (data only) inserting empty columns
- Attachments
-
- How to save to Excel with Export data only option
- Save to Excel settings.JPG (193.49 KiB) Viewed 2696 times
-
- Screen shot showing empty columns
- Empty columns in saved report.JPG (156.1 KiB) Viewed 2696 times
Re: Save to Excel (data only) inserting empty columns
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.
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.
Re: Save to Excel (data only) inserting empty columns
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
)
>> 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

Re: Save to Excel (data only) inserting empty columns
Hello.
Thank you.
Sorry, I meant that the columns in Excel file are created for the whole report. Like if you don't select Data Only option.sandynith wrote:>> The columns are made for the while report.
Could you please explain what do you mean here?
You could follow the suggestions from How to Create Report for Export? article.sandynith wrote:>> 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)
Thank you.