Dynamic graphs in SSRS

Hello,

Im building a horizontal bar graph, but according to the parameters it could have a different number of bars, how can i make the SSRS resize the graph?

Or how can i make ssrs to give the same size as a table right next to it?

Thank you

You may need to create a couple of separate graphs with different sizes and show-hide based on # of rows in the dataset.

There is an article here which may also help, though it is more for working inside the chart rather than sizing the object itself. http://www.ssw.com.au/ssw/Standards/Rules/RulesToBetterSQLReportingServices.aspx#maxminvalues

A more flexible approach may be available in Dundas Charts for Reporting Services.

More info here:
http://msdn2.microsoft.com/en-us/library/aa964128.aspx

cheers,
Andrew

Dynamic Graphs

I'm tryin to create a graph, the info comes from a stored proc which takes
in the day (eg Monday) as a parameter.
The graph is then plotted based on that day.
I now want to create graphs for 7 days of the week using this same stored
proc. Can anybody give me any ideas as to how I can change the parameters
for each graph so that I can then display all 7 graphs together using 1
stored proc.Create seven data sets in your report. For each one, change the query
parameters to explicitly hand in the day (and delete the autogenerated Day
report parameter, since you won't need it). Then create seven charts,
binding each to one of the data sets.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"Kershni Chetty" <support@.sqrsoftware.com> wrote in message
news:O4bsCgKdEHA.1356@.TK2MSFTNGP09.phx.gbl...
> I'm tryin to create a graph, the info comes from a stored proc which takes
> in the day (eg Monday) as a parameter.
> The graph is then plotted based on that day.
> I now want to create graphs for 7 days of the week using this same stored
> proc. Can anybody give me any ideas as to how I can change the parameters
> for each graph so that I can then display all 7 graphs together using 1
> stored proc.
>

Dynamic Graph

Hello Group.
I have to do some reports, but the brequeriments are that the reports have
dynamic graphs, can Reporting Services have dynamic graphs?
That's the end user can change between an pie or a bar char'
Tanks.You can make a button that will make visable/hidden the bar and pie chart.
"Carlos López." <CarlosLpez@.discussions.microsoft.com> wrote in message
news:781EAA39-3C33-4301-B3C8-08FD2F0E5197@.microsoft.com...
> Hello Group.
> I have to do some reports, but the brequeriments are that the reports have
> dynamic graphs, can Reporting Services have dynamic graphs?
> That's the end user can change between an pie or a bar char'
> Tanks.
>|||This is one way of doing it but I'd personally avoid hidden regions. First,
the hidden element space is not reclaimed and second, the datasets for
hidden elements are processed which may impact performance.
Instead, I address a similar requirement in the past by changing the report
definition (RDL) file. True, this will require a custom application front
end, so it may not be applicable always.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:uexXpFrxEHA.3908@.TK2MSFTNGP12.phx.gbl...
> You can make a button that will make visable/hidden the bar and pie chart.
>
>
> "Carlos López." <CarlosLpez@.discussions.microsoft.com> wrote in message
> news:781EAA39-3C33-4301-B3C8-08FD2F0E5197@.microsoft.com...
> > Hello Group.
> > I have to do some reports, but the brequeriments are that the reports
have
> > dynamic graphs, can Reporting Services have dynamic graphs?
> > That's the end user can change between an pie or a bar char'
> > Tanks.
> >
>|||Hi
I have a requirement to do excatly the same
Hide/show based on a button with in the report
Please let me know how to do this
Regards
George
"Cindy Lee" wrote:
> You can make a button that will make visable/hidden the bar and pie chart.
>
>
> "Carlos López." <CarlosLpez@.discussions.microsoft.com> wrote in message
> news:781EAA39-3C33-4301-B3C8-08FD2F0E5197@.microsoft.com...
> > Hello Group.
> > I have to do some reports, but the brequeriments are that the reports have
> > dynamic graphs, can Reporting Services have dynamic graphs?
> > That's the end user can change between an pie or a bar char'
> > Tanks.
> >
>
>|||You might be better off creating two reports. One with the Pie Chart and one
with the Bar Graph. This has the added advantage of optimizing the way each
chart appears to the user.
"Carlos López." wrote:
> Hello Group.
> I have to do some reports, but the brequeriments are that the reports have
> dynamic graphs, can Reporting Services have dynamic graphs?
> That's the end user can change between an pie or a bar char'
> Tanks.
>

dynamic change of graphs type

We have a requirement where we show a particular simple graph in type columns. we wanted to give the user a parameter like Type: which has some or different charts in it. i would like to give a user a feature of dynamically changing the chart type.

hope you understand me. let me know which is the property i need to assign the parametere value and where i should write that

there is no such property available. For this you need to writhe the function and make it DLL and refer in your report or u can write the code in code window and refer that in your report|||

I have the same problem, I tried the following but did not work.

<Type>=Parameters!ChartType.Value</Type>

|||

Expression-based chart types are not supported at this point. The closest you can get in RS is to define multiple charts with different types. Then through the Visibility.Hidden property you always hide all but the one chart you want to see for a particular parameter value.

-- Robert

|||

OK, just figured out a work around:

1. Create report a report parameter for chart type, say ChartType, add in all the types you want.

2. Use your current chart as a template, make a few copy of it, and paste them in the same report.

3. Change the type property of each chart to a type corresponding to a item in ChartType parameter.

4. Also change the visibility/Hidden property of each chart from False to expression: e.g. for Pie chart, =iif(Parameters!ChartType.Value="Pie",false,true)

Drawback: I guess the Reporting Server may need to create all the charts and Browser may need to load all the charts' images each time when user sees one chart, the other charts are hidden but has been generated/loaded.

Hope this will help before MS fixes the bug in its next release.

|||

I have just had a user ask for this feature, wondering if it is in RS 2005 or planned for the near future?

99

|||

I have the same problem.

I created 5 charts on one report. but i dont want to execute the report for every graph change.

all the charts are using the same dataset.

Can i show /Hide all the charts except the choosen one by clicking on a textbox?

thanks

|||

I have the same problem too,

I wonder how did you solve problem lastly?

And ...

In last 3 months microsoft deliver SP2 of SQL Server 2005. Does it bring any new property to solve this problem?

I will be glad taking your answers about problem...

|||

Hi,

I didnt find a way to choose the graph type by clicking a text box.

i created all the graphs in the report, all connected to the same dataset.

i also created a list control and the user can choose which type he wants.

and by the graphs visibilty propery, i show only the wanted one.

regarding the sp2, i dont familar with it yet. soory.

dynamic change of graphs type

We have a requirement where we show a particular simple graph in type columns. we wanted to give the user a parameter like Type: which has some or different charts in it. i would like to give a user a feature of dynamically changing the chart type.

hope you understand me. let me know which is the property i need to assign the parametere value and where i should write that

there is no such property available. For this you need to writhe the function and make it DLL and refer in your report or u can write the code in code window and refer that in your report|||

I have the same problem, I tried the following but did not work.

<Type>=Parameters!ChartType.Value</Type>

|||

Expression-based chart types are not supported at this point. The closest you can get in RS is to define multiple charts with different types. Then through the Visibility.Hidden property you always hide all but the one chart you want to see for a particular parameter value.

-- Robert

|||

OK, just figured out a work around:

1. Create report a report parameter for chart type, say ChartType, add in all the types you want.

2. Use your current chart as a template, make a few copy of it, and paste them in the same report.

3. Change the type property of each chart to a type corresponding to a item in ChartType parameter.

4. Also change the visibility/Hidden property of each chart from False to expression: e.g. for Pie chart, =iif(Parameters!ChartType.Value="Pie",false,true)

Drawback: I guess the Reporting Server may need to create all the charts and Browser may need to load all the charts' images each time when user sees one chart, the other charts are hidden but has been generated/loaded.

Hope this will help before MS fixes the bug in its next release.

|||

I have just had a user ask for this feature, wondering if it is in RS 2005 or planned for the near future?

99

|||

I have the same problem.

I created 5 charts on one report. but i dont want to execute the report for every graph change.

all the charts are using the same dataset.

Can i show /Hide all the charts except the choosen one by clicking on a textbox?

thanks

|||

I have the same problem too,

I wonder how did you solve problem lastly?

And ...

In last 3 months microsoft deliver SP2 of SQL Server 2005. Does it bring any new property to solve this problem?

I will be glad taking your answers about problem...

|||

Hi,

I didnt find a way to choose the graph type by clicking a text box.

i created all the graphs in the report, all connected to the same dataset.

i also created a list control and the user can choose which type he wants.

and by the graphs visibilty propery, i show only the wanted one.

regarding the sp2, i dont familar with it yet. soory.

dynamic change of graphs type

We have a requirement where we show a particular simple graph in type columns. we wanted to give the user a parameter like Type: which has some or different charts in it. i would like to give a user a feature of dynamically changing the chart type.

hope you understand me. let me know which is the property i need to assign the parametere value and where i should write that

there is no such property available. For this you need to writhe the function and make it DLL and refer in your report or u can write the code in code window and refer that in your report|||

I have the same problem, I tried the following but did not work.

<Type>=Parameters!ChartType.Value</Type>

|||

Expression-based chart types are not supported at this point. The closest you can get in RS is to define multiple charts with different types. Then through the Visibility.Hidden property you always hide all but the one chart you want to see for a particular parameter value.

-- Robert

|||

OK, just figured out a work around:

1. Create report a report parameter for chart type, say ChartType, add in all the types you want.

2. Use your current chart as a template, make a few copy of it, and paste them in the same report.

3. Change the type property of each chart to a type corresponding to a item in ChartType parameter.

4. Also change the visibility/Hidden property of each chart from False to expression: e.g. for Pie chart, =iif(Parameters!ChartType.Value="Pie",false,true)

Drawback: I guess the Reporting Server may need to create all the charts and Browser may need to load all the charts' images each time when user sees one chart, the other charts are hidden but has been generated/loaded.

Hope this will help before MS fixes the bug in its next release.

|||

I have just had a user ask for this feature, wondering if it is in RS 2005 or planned for the near future?

99

|||

I have the same problem.

I created 5 charts on one report. but i dont want to execute the report for every graph change.

all the charts are using the same dataset.

Can i show /Hide all the charts except the choosen one by clicking on a textbox?

thanks

|||

I have the same problem too,

I wonder how did you solve problem lastly?

And ...

In last 3 months microsoft deliver SP2 of SQL Server 2005. Does it bring any new property to solve this problem?

I will be glad taking your answers about problem...

|||

Hi,

I didnt find a way to choose the graph type by clicking a text box.

i created all the graphs in the report, all connected to the same dataset.

i also created a list control and the user can choose which type he wants.

and by the graphs visibilty propery, i show only the wanted one.

regarding the sp2, i dont familar with it yet. soory.

dynamic change of graphs type

We have a requirement where we show a particular simple graph in type columns. we wanted to give the user a parameter like Type: which has some or different charts in it. i would like to give a user a feature of dynamically changing the chart type.

hope you understand me. let me know which is the property i need to assign the parametere value and where i should write that

there is no such property available. For this you need to writhe the function and make it DLL and refer in your report or u can write the code in code window and refer that in your report|||

I have the same problem, I tried the following but did not work.

<Type>=Parameters!ChartType.Value</Type>

|||

Expression-based chart types are not supported at this point. The closest you can get in RS is to define multiple charts with different types. Then through the Visibility.Hidden property you always hide all but the one chart you want to see for a particular parameter value.

-- Robert

|||

OK, just figured out a work around:

1. Create report a report parameter for chart type, say ChartType, add in all the types you want.

2. Use your current chart as a template, make a few copy of it, and paste them in the same report.

3. Change the type property of each chart to a type corresponding to a item in ChartType parameter.

4. Also change the visibility/Hidden property of each chart from False to expression: e.g. for Pie chart, =iif(Parameters!ChartType.Value="Pie",false,true)

Drawback: I guess the Reporting Server may need to create all the charts and Browser may need to load all the charts' images each time when user sees one chart, the other charts are hidden but has been generated/loaded.

Hope this will help before MS fixes the bug in its next release.

|||

I have just had a user ask for this feature, wondering if it is in RS 2005 or planned for the near future?

99

|||

I have the same problem.

I created 5 charts on one report. but i dont want to execute the report for every graph change.

all the charts are using the same dataset.

Can i show /Hide all the charts except the choosen one by clicking on a textbox?

thanks

|||

I have the same problem too,

I wonder how did you solve problem lastly?

And ...

In last 3 months microsoft deliver SP2 of SQL Server 2005. Does it bring any new property to solve this problem?

I will be glad taking your answers about problem...

|||

Hi,

I didnt find a way to choose the graph type by clicking a text box.

i created all the graphs in the report, all connected to the same dataset.

i also created a list control and the user can choose which type he wants.

and by the graphs visibilty propery, i show only the wanted one.

regarding the sp2, i dont familar with it yet. soory.