Chart - bar colors

[lumaar]

Ravi,

For the colors of the bar programatically, make sure you have the reporting services Service Pack 2 installed and browse the properties of the data value.

There is no way to include two types of chart together. However you can have a column and a second data values as a Plot line and that would simulate a paretto chart (columns and a line) That's all the best you can do with this version of RS. (perhaps in 2005 version this might change)

hope it helps

Lumaar

[Ravi Muppavaram]

Hi Lumaar,
Thanks for Replay, now I am using SSRS 2005 (IDW14) , I didn't find any such service or any other option. Can you give suggestions?

Ravi,

[lumaar]

Ravi,

I am just using SQL Server 2000 RS with the service pack 2 which I downloaded from here
http://www.microsoft.com/sql/reporti...s/default.mspx

to change the color programmatically, go to:

Chart properties
Data tab
Edit Values
Appearance tab
Series style
Fill tab and change the color of the background using a predefined color or an expression.

You can also click on "Plot data as line" under the same appearance tab to draw a line among columns.

I am not sure in 2005 how this is layed out, haven't tried it yet

Lumaar

[Ravi Muppavaram]

lumaar,
Thanks Very much,
They incorporated with SSRS 2K5. process is same as what you told.
Regards,
Ravi m.

[Ravi Muppavaram]

Hi lumaar,
how can u control space between bars, in my cahrt i am using Columns chart, Showing something Type and A,B,C groups, for Each Type need to show A,B,C.

Type1(A,B,C)
Type2(A,B,C)
Type3(A,B,C)
Type4(A,B,C)
i need to give bit more space between Type1,2,3,4. how can we set it? any way?
Cheers
Ravi.