Changing Colors of Set of Rows based on Group / Matrices

Norman Yuan helpe me very much with changing colors on alternate rows, but
now I need help with a couple of other reports that use matrices.
Is there an ""on group change" event that I can test so that I can determine
when the group changes so that I can change the background color for all the
rows in that group?
Please let me know.
Thanks in advacne.I guess that you used ROWNUMBER(Nothing) now, simply use the
ROWNUMBER(Groupname) for putting the same logic in place for groups.
HTH, Jens K. Suessmeyer.
--
http://www.sqlserver2005.de
--

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

Change subreport colors

I have a report in which I alternate colors between white and whitesmoke.
Simple report that contains a table with a header and a body. The body is
set to =iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White") I then add
another row to my table, merge all cells into one and add a sub report to it.
Here I display more data by setting the parameter of the current customerID
that I am on. Is there a way to pull the current row color from by non
subreport row and apply it to the entire sub report? This way the main row
and sub report (no matter how may row of data it contains) will have the same
color.Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to set colors according
to per row's settings (For example, if the current row background color is
whitesmoke, the want the whole subreport background to be whitesmoke also).
If I have misunderstood your concern, please feel free to point it out.
Yes, we could add another parameter in the subreport and then set this
parameter value to be iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")
in main report. This parameter will pass the value to subReport,
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Just what I was looking for...Thanks!!!
"Michael Cheng [MSFT]" wrote:
> Hi,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you would like to set colors according
> to per row's settings (For example, if the current row background color is
> whitesmoke, the want the whole subreport background to be whitesmoke also).
> If I have misunderstood your concern, please feel free to point it out.
> Yes, we could add another parameter in the subreport and then set this
> parameter value to be iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")
> in main report. This parameter will pass the value to subReport,
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi,
You are welcome! If you have any questions or concerns next time, don't
hesitate to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

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