Microsoft Report Viewer在导出到Excel时显示隐藏的列

I'm using Microsoft Report Viewer in an ASP.Net application on the 4.0 framework. I have the report showing fine inside the webpage, but I was recently requested to hide several columns. I found out that through editing the Column Visibility by right clicking on the column in the .RLDC file would allow me to hide it, but I need to be able to show the hidden columns upon Exporting to Excel. As far as I can tell Microsoft Report Viewer exports exactly what it has shown to Excel.I'm using Microsoft Report Viewer in an ASP.Net