SQL Server Performance

Export to Excel - Without the Colors

Discussion in 'SQL Server Reporting Services' started by PaulTeal, Oct 1, 2006.

  1. PaulTeal New Member

    I am using Report Manager as my report interface. I am exporting Reporting Services reports with multiple colors to MS Excel (which has a very limited color palate).

    When I export the reports to Excel, the system chooses the colors automatically, and I am not very happy with the colors selected. I would like to either control the colors in the export or make the exports black and white.

    Does anyone have an idea how to do this?
  2. saladk New Member

    The only way I know of how to do this is to edit the report in Report Designer (Visual Studio .net 2003) and make the desired color choices there and then deploy the report back to Report Manager.

Share This Page