Reporting services -- Export excel with data

Question

I have a report showed as bar chart in sql server reporting services. when I export it to excel from the reporting services web interface, the exported file doesn't contain any data, it only has a bar chart image. Is there any way to make it export to excel with data?

Answer 1

The simple answer is that if you want to include data in your Excel sheet, you'll have to include it somewhere in the report layout in a table or matrix, along with the chart.