How do I programatically set the graph color (actual bar colors) and bypass the use of the palette?
You need at least RS 2000 SP1 or later installed on report designer and report server machines. Then take a look at the following whitepaper: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/MoreSSRSCharts.asp
Specifically, read the section about "Custom Chart Color Palettes and Legends".
-- Robert
|||Thanks.Wanted to enquire how this is done. Tried doing it in the setUsageType method I have overwritten but only allows description to be changed. Basically need to change "Name".
Best option would be to change it instantly when a user selects a column from the inputs in the custom component, ie. it changes the Output Alias to a desired value. (Input tab in advanced editor)
All this is being done in a custom component which I would like to be synchronous, can achieve a similar result asynchronously.
Thanks
Not relaly sure if this can be done, as there is no output column, just the upstream input column which has already been named. If you select the column, then can you not change the IDTSInputColumn90 name in SetUsageType? What happens? The other thing to try would be to change the name property on the IDTSVirtualInputColumn90, can you?
You do not really have an output alias. When you see this in the stock UIs it is because you are creating a new output column, which is not what you appear to be doing.
|||If you change the name is setUsageType you see a change in debug mode but eventually it does not change the column name (strangely description can be changed however), basically change is ignored. When I change the Output Alias in the gui advanced designer (non programatically) it does not create a new output column in the output column tab listing but does successfully change the alias and column name, which is basically the result I want. Have been able to achieve the change with a new output column and asynchronous component but wanted to do it synchronously. Also figured it could be done programatically due to the fact you can do it non-programatically in the gui advanced editor.
Thanks, will try the virtual column thing.
