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?
Unfortunately, the format that you are using to generate the report is not a global parameter. So a report doesn't really know if it's PDF HTML or EXCEL. Try using the web-safe pallette of 256-colors. Or you could pass in the colors you wish to use as parameters. Ugly, but kinda fun.|||Excel does not even have 256 colors. Excel has only 40 colors.
I just want the exports to come out black and white.
|||In that case you'll either have to just make your report black & white or pass in a parameter that is a form of yes/no of whether the report is to be generated as a HTML page or EXCEL file.
No comments:
Post a Comment