changing colors in charts

Hello,
I'm trying to change the color of a chart region based on a report parameter
and I'm not having any luck. Can any one tell me where I change this? I see
all of the available color palattes, but I don't want to use those. The
regions need to be a specific color based on the report parameter option that
was choosen by the user.
ThanksYou will need RS 2000 with SP1 or later. In that case, you can control the
color of data points based on an expression. Please check the "Chart Styles"
section under 4.1.3 in the SP1 Readme:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"dataGirl" <dataGirl@.discussions.microsoft.com> wrote in message
news:324B9D30-B779-4402-9E68-9FC8FE0941FD@.microsoft.com...
> Hello,
> I'm trying to change the color of a chart region based on a report
> parameter
> and I'm not having any luck. Can any one tell me where I change this? I
> see
> all of the available color palattes, but I don't want to use those. The
> regions need to be a specific color based on the report parameter option
> that
> was choosen by the user.
> Thankssql

Changing Chart with dynamically

Hi,

I have a chart which gets generated dynamically for as many months as specified in the front end.But every time the width of the chart remains constant.How do i make it change as per the No: of months to be displayed?

One way of doing this is to apply an approach described in this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=369675&SiteID=1

-- Robert

Changing chart type at run-time

Hello,

I'm coding a web application using ASP.NET 2.0 and I'd like to show users some charts allowing them to chose the chart type at run-time.
I'm building a rdlc (local) report source at run-time starting from a template and working in memory.
Users can select wich rows and columns from a table to display in the chart. They can also chose che chart type (Bar, line, pie etc.)

Now the code works fine the first time it's run. Then the report viewer keeps showing the chart with the same chart type and columns data. Only rows change accordingly to the user selection.

I'm using the following code to initialize the reportviewer:

Dim str As System.IO.MemoryStream = New MemoryStream
rptDoc.Save(str) //->that's the xml doc being saved to a memory stream
str.Position = 0
repView.LocalReport.ReportPath = String.Empty 'Just in case...
repView.LocalReport.LoadReportDefinition(str)
repView.LocalReport.DataSources.Clear() 'Just in case again...
repView.LocalReport.DataSources.Add(New ReportDataSource("DataSet1_01E01000", dt2))
repView.LocalReport.Refresh()

Any suggestion?

Thank you all.Can you share with me how you change the Chart Type at Runtime? Thanks!|||

Sorry for the late reply, I haven't checked forums lately.

As I said I'm building the rdlc (local) report source file at run-time starting from some templates.

The rdlc files are nothing more that XML files and the chart type is defined inside a node. All I do is put the desired type in the right node.

You can also build a rdlc right from scratch and pass it to the ReportViewer component via its LoadReportDefinition method using the overloaded version that gets a IO.Stream as source.

Ask me if you need a sample.

Bye.

|||

You need to reset the report by doing a

ReportViewer1.Reset();//Then setting the datasource and all the properties.

|||

Hello Stojilcoviz,

Can you share with me the sample of your code which changes the chart types at run-time in the RDLC? Thanks.

changing Chart Type

Hi
Do any one have idea on how to change the chart type in Reporting
Services. I'm new to SQL server RS. So if you have any code snippet,
please send. It will very help full for me.
Thanks and regards
SanthamurthyHi,
Are you asking dynamic chart type changing?
I dont think you are asking from layout (while designing) "chart type" since
it is very simple.
Regards
Amarnath
"Santhamurthy" wrote:
> Hi
> Do any one have idea on how to change the chart type in Reporting
> Services. I'm new to SQL server RS. So if you have any code snippet,
> please send. It will very help full for me.
> Thanks and regards
> Santhamurthy
>

Change the displayed name in the Series Group for a chart

Hi,
I created a chart in sql reporting services. I added a series group to it.
Now what i want to do is to dispaly different series names when the chart is
viewed . For example, in my database, I have Region code as numbers. I have
used this Region Code as the Series group. What i want to do is, ...
if (RegionCode ==01
{
//the series group should display North
}
Similarly for other region codes. Is it possible? & how?
Thanks
pmudYes this is possible through the Label expression of a chart series
grouping.
* right-click on the chart and open the chart properties dialog
* go to the Data tab and edit the series grouping
* the grouping dialog has a grouping expression and a label expression
below. If no label expression is set, it will take the group expression
value as label by default.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:13D0A129-DEAA-4C05-9736-04E3104A9935@.microsoft.com...
> Hi,
> I created a chart in sql reporting services. I added a series group to it.
> Now what i want to do is to dispaly different series names when the chart
> is
> viewed . For example, in my database, I have Region code as numbers. I
> have
> used this Region Code as the Series group. What i want to do is, ...
> if (RegionCode ==01
> {
> //the series group should display North
> }
> Similarly for other region codes. Is it possible? & how?
> Thanks
> pmud

Change the color of the chart items

Does anybody know how to change the color of the chart items? I dont want to
use the default palette that the reporting have. I want to change the color
of the bars and the pie chart.SQL Server 2000 Reporting Services SP1 added support in this area.
Using the Chart Properties dialog you will need to navigate to
Data Tab : Values : Edit
Edit Chart Value Dialog : Appearance Tab : Series Style button
Style Properties dialog
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nelson" <Nelson@.discussions.microsoft.com> wrote in message
news:4A94A89C-9297-4508-AF08-060CB3CC86E7@.microsoft.com...
> Does anybody know how to change the color of the chart items? I dont want
> to
> use the default palette that the reporting have. I want to change the
> color
> of the bars and the pie chart.|||Bruce,
I followed the navigation steps that you mentioned, but still
couldnt figure out what next to do in order to define explicit color to
the series, rather than allowing it to be defaulted which it is doing
now.
I have downloaded the SP1 and installed the same, but still not sure
how to implement individual color of my choice,
An, earlier response is appriciated.
Thanks,|||If you have not done yet, please read this section in the SP1 readme about
using colors in charts:
http://download.microsoft.com/download/7/f/b/7fb1a251-13ad-404c-a034-10d79ddaa510/SP1Readme_EN.htm#_chart_enhancements
You may also search this newsgroup for chart color related posting, e.g.:
*
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=c8620b23-0340-4d35-a154-4a797ecfab2f&sloc=en-us
*
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=73b9ddf6-58a7-4088-955b-9a03a4d56efa&sloc=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Srini" <turlsri1@.yahoo.com> wrote in message
news:1103664443.478130.45620@.c13g2000cwb.googlegroups.com...
> Bruce,
> I followed the navigation steps that you mentioned, but still
> couldnt figure out what next to do in order to define explicit color to
> the series, rather than allowing it to be defaulted which it is doing
> now.
> I have downloaded the SP1 and installed the same, but still not sure
> how to implement individual color of my choice,
> An, earlier response is appriciated.
> Thanks,
>|||Thanks,
I appriciate the early response, will go through the
articles.

Change the chart size dynamically

Hi All,
I have a small problem ,i am not able to change the size of the chart and the bar in the bar chart dynamically.

The only items that grow horizontally are matrix and chart. Some people have created reports with multple copies of the chart and had a flag that hid all but one of them. Also, custom report items will have the ability to grow dynamically. The width of the bars in the chart are determined based on the number of points.|||thanks for the reply
but how to grow the chart horizantally.

Change Pie chart color

Hi,

I am using SQL Server 2005 Reporting Services.

I need to change the Pie chart data element colors depending on the value

for the data element.

eg: Yes should be in Green and No in RED

Assuming that you have two data fields / values in the chart, one for Yes and one of No - you could just edit the data values, go to the appearance tab, click on the series styles button and set the Fill Color to Green and Red, respectively.

-- Robert