Change Graph type at run time

Hi
Can the user not change the graph type at run time the same way you can
change for example background colour. I want to have a parameter for the user
so he can choose line, bar or pie for the same graph.
Thanks
FrancoisSetting chart types dynamically is not supported in the current release.
However, you could approximate the desired behavior by using multiple charts
(of various types) and use an expression to dynamically hide all charts but
the one you want displayed.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Francois" <Francois@.discussions.microsoft.com> wrote in message
news:7CDB8D7C-2444-4C9B-916C-59A2A8946FB2@.microsoft.com...
> Hi
> Can the user not change the graph type at run time the same way you can
> change for example background colour. I want to have a parameter for the
user
> so he can choose line, bar or pie for the same graph.
> Thanks
> Francois

change font color in subtotal

My matrix looks like this:
row1
row2
subtotal
The subtotal background color is different than the regular row and this
part is working, I also want to change the font color of the subtotal based
on the subtotal value.
=IIF(
Parameters!RP_PERCENNUM.Value=1,(IIF(SUM(Fields!Percentage.Value)>100,"Red","Transparent")),(IIF(SUM( Fields!Hours.Value)>40,"Red","Transparent")))
The above statement won't work and it changes everything to red. I have
tried to use InScope and it did the same thing.
=IIF(
Parameters!RP_PERCENNUM.Value=1,(IIF(InScope(SUM(Fields!Percentage.Value))>"100","Red","Transparent")),(IIF(InScope(SUM(
Fields!Hours.Value))>"40","Red","Transparent")))
Anyone has any idea how to change the color? Thanks.You would need to nest your IIF's inside of another IIF
or
write code in the Report Code field, with input parameters, for Percentage
and Hours, and a return parameter of your font color. Then call this code
from the font color property as an expression
"Helen" wrote:
> My matrix looks like this:
> row1
> row2
> subtotal
> The subtotal background color is different than the regular row and this
> part is working, I also want to change the font color of the subtotal based
> on the subtotal value.
> =IIF(
> Parameters!RP_PERCENNUM.Value=1,(IIF(SUM(Fields!Percentage.Value)>100,"Red","Transparent")),(IIF(SUM( Fields!Hours.Value)>40,"Red","Transparent")))
> The above statement won't work and it changes everything to red. I have
> tried to use InScope and it did the same thing.
> =IIF(
> Parameters!RP_PERCENNUM.Value=1,(IIF(InScope(SUM(Fields!Percentage.Value))>"100","Red","Transparent")),(IIF(InScope(SUM(
> Fields!Hours.Value))>"40","Red","Transparent")))
> Anyone has any idea how to change the color? Thanks.
>

Change colour of "Interlaced strips" in chart?

Is it possible to change the colour of the interlaced strips? I can change
the default background colour, but haven't found a setting for the alternate
colour. I need to have two light colours, as the default gray is a bit dark
for some printers.
All help appreciated!
Kaisa M. LindahlThe color for interlaced strips is determined automatically by the chart
control based on the background / plotarea color. Did you try adjusting the
plotarea color of the chart?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:%23$kOwzTBFHA.1260@.TK2MSFTNGP12.phx.gbl...
> Is it possible to change the colour of the interlaced strips? I can change
> the default background colour, but haven't found a setting for the
alternate
> colour. I need to have two light colours, as the default gray is a bit
dark
> for some printers.
> All help appreciated!
> Kaisa M. Lindahl
>|||I noticed that the colour changes a bit when I change the colour in plot
area. Unfortunately, it doesn't change enough.
In the end, we just skipped the interlacing all together.
Kaisa M. Lindahl
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OiM2S8kBFHA.3120@.TK2MSFTNGP12.phx.gbl...
> The color for interlaced strips is determined automatically by the chart
> control based on the background / plotarea color. Did you try adjusting
the
> plotarea color of the chart?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
> news:%23$kOwzTBFHA.1260@.TK2MSFTNGP12.phx.gbl...
> > Is it possible to change the colour of the interlaced strips? I can
change
> > the default background colour, but haven't found a setting for the
> alternate
> > colour. I need to have two light colours, as the default gray is a bit
> dark
> > for some printers.
> >
> > All help appreciated!
> >
> > Kaisa M. Lindahl
> >
> >
>

Change background color on toggle

I have a report with a table, four columns. I added a second row to the
table and inserted a subreport. The subreport's ToggleItem is the first
column in the first detail row of the table. When I toggle a row to display
the subreport, I'd like to change the background color of the row. I can't
seem to get a reference to the ToggleState of the Textbox, or the Visibility
of the subreport. Any ideas?
--
KenHi Ken,
Thank you for your posting!
Based on my research, we could not get the reference to the Visibility of a
report item or the togglestate of a textbox.
Unfortunately, I could not found a workaround now.
To provide your feedback directly to the product groups:
http://lab.msdn.microsoft.com/productfeedback/default.aspx
Thank you for your patience.
Sincerely,
Wei Lu
Microsoft Online Community 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.|||There is an example on www.msbicentral.com called
ConditionalGroupBkgrdColor.rdl. It is in the downloads section for Reporting
Services Reports. Its description is:
This report demonstrates how to change a group's background color when it is
toggled to show its children. The key areas to focus on are the rectangles
and their children. Note the use of a toggle textbox, visible textbox, and a
hidden textbox.
You'll have to register(free) to download it. This might be what you are
looking for.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"GopherGold" wrote:
> I have a report with a table, four columns. I added a second row to the
> table and inserted a subreport. The subreport's ToggleItem is the first
> column in the first detail row of the table. When I toggle a row to display
> the subreport, I'd like to change the background color of the row. I can't
> seem to get a reference to the ToggleState of the Textbox, or the Visibility
> of the subreport. Any ideas?
> --
> Ken|||Thanks, Wayne. I'm using RS2005. When I open the rdl file, I'm asked to
convert it, leading me to believe that this was done for RS2000. Is that
correct? After converting it, something must have broken, because in preview
mode the groups don't toggle.
--
Ken
"Wayne Snyder" wrote:
> There is an example on www.msbicentral.com called
> ConditionalGroupBkgrdColor.rdl. It is in the downloads section for Reporting
> Services Reports. Its description is:
> This report demonstrates how to change a group's background color when it is
> toggled to show its children. The key areas to focus on are the rectangles
> and their children. Note the use of a toggle textbox, visible textbox, and a
> hidden textbox.
> You'll have to register(free) to download it. This might be what you are
> looking for.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "GopherGold" wrote:
> > I have a report with a table, four columns. I added a second row to the
> > table and inserted a subreport. The subreport's ToggleItem is the first
> > column in the first detail row of the table. When I toggle a row to display
> > the subreport, I'd like to change the background color of the row. I can't
> > seem to get a reference to the ToggleState of the Textbox, or the Visibility
> > of the subreport. Any ideas?
> >
> > --
> > Ken|||Hi Ken,
Please try to find the ToggleTextBox and modify the width to 0.3 in. Then
you could see the (+) mark and you could toggle the group.
Thanks for Wayne's great help!
Sincerely,
Wei Lu
Microsoft Online Community 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 Ken,
Have you tried the suggestion? Please let me know if you need any help on
this issue. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community 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 Background Color

Hi,

I am using toggle visibility feature in one of my reports and I am trying to change the background color of some cells when I toggle the view. Please help, any help will be appreciated.

Thanks,

-Rohit

To be more precise, there is a parent and it has several children. At first children are hidden, but when I click parent then children become visible. I would like to change the color of the parent when children are visible and go back to transparent when children are hidden. I hope I clearly discribe my question. Thanks.