| Groups | Blog | Home |
sql server reporting services : Size Chart Dynamically in RS2005
rows in the data set it is rendering from (it's a bar chart) so that the graphic will render appropriatley. Is there any way to do this? Thank you,
Sorry, dynamically growing charts is not supported right now. One workaround
that comes in mind is to duplicate your chart with various width/height settings, overlay them and use the Visibility.Hidden property on the charts with expressions to conditionally show only one of them for a particular range of bars e.g. display a small chart if the total number of bars is lower than 10, etc. Another option is to use Drillthrough on the datapoints. The top-level chart would probably only show the TOP 10 items/categories. The drillthrough report could then show the details for a particular category. -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Jason L Lind" <JasonLLind@discussions.microsoft.com> wrote in message news:0B50D06B-F79F-4F90-9A89-ACC73619337E@microsoft.com... > Hi, I am trying to size a chart dynamically with respect to the number of > rows in the data set it is rendering from (it's a bar chart) so that the > graphic will render appropriatley. > > Is there any way to do this? > > Thank you, > Jason Lind
I found a solution:
http://www.livejournal.com/users/jlind0/ [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Sorry, dynamically growing charts is not supported right now. One workaround > that comes in mind is to duplicate your chart with various width/height > settings, overlay them and use the Visibility.Hidden property on the charts > with expressions to conditionally show only one of them for a particular > range of bars e.g. display a small chart if the total number of bars is > lower than 10, etc. > Another option is to use Drillthrough on the datapoints. The top-level chart > would probably only show the TOP 10 items/categories. The drillthrough > report could then show the details for a particular category. > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Jason L Lind" <JasonLLind@discussions.microsoft.com> wrote in message > news:0B50D06B-F79F-4F90-9A89-ACC73619337E@microsoft.com... > > Hi, I am trying to size a chart dynamically with respect to the number of > > rows in the data set it is rendering from (it's a bar chart) so that the > > graphic will render appropriatley. > > > > Is there any way to do this? > > > > Thank you, > > Jason Lind > >
Thanks for sharing your solution! This is certainly an elegant solution,
however with the minor drawback that it is not generally applicable (e.g. cannot be used for execution snapshots). But it may be the perfect or good-enough solution for several scenarios. :) -- Robert This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Jason L Lind" <JasonLLind@discussions.microsoft.com> wrote in message news:8DC4C664-43EB-4F88-8A22-FC0FD72F8058@microsoft.com... >I found a solution: > http://www.livejournal.com/users/jlind0/ > > "Robert Bruckner [MSFT]" wrote: > >> Sorry, dynamically growing charts is not supported right now. One >> workaround >> that comes in mind is to duplicate your chart with various width/height >> settings, overlay them and use the Visibility.Hidden property on the >> charts >> with expressions to conditionally show only one of them for a particular >> range of bars e.g. display a small chart if the total number of bars is >> lower than 10, etc. >> Another option is to use Drillthrough on the datapoints. The top-level >> chart >> would probably only show the TOP 10 items/categories. The drillthrough >> report could then show the details for a particular category. >> >> -- Robert >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "Jason L Lind" <JasonLLind@discussions.microsoft.com> wrote in message >> news:0B50D06B-F79F-4F90-9A89-ACC73619337E@microsoft.com... >> > Hi, I am trying to size a chart dynamically with respect to the number >> > of >> > rows in the data set it is rendering from (it's a bar chart) so that >> > the >> > graphic will render appropriatley. >> > >> > Is there any way to do this? >> > >> > Thank you, >> > Jason Lind >> >> >>
Sorry i maybe being stupid but i can't see a solution on this link? This is
something that may realy help me so if somecould point me towards the solution on the link that Jason provided that would be great [quoted text, click to view] "Robert Bruckner [MSFT]" wrote:
> Thanks for sharing your solution! This is certainly an elegant solution, > however with the minor drawback that it is not generally applicable (e.g. > cannot be used for execution snapshots). But it may be the perfect or > good-enough solution for several scenarios. :) > > -- Robert > This posting is provided "AS IS" with no warranties, and confers no rights. > > "Jason L Lind" <JasonLLind@discussions.microsoft.com> wrote in message > news:8DC4C664-43EB-4F88-8A22-FC0FD72F8058@microsoft.com... > >I found a solution: > > http://www.livejournal.com/users/jlind0/ > > > > "Robert Bruckner [MSFT]" wrote: > > > >> Sorry, dynamically growing charts is not supported right now. One > >> workaround > >> that comes in mind is to duplicate your chart with various width/height > >> settings, overlay them and use the Visibility.Hidden property on the > >> charts > >> with expressions to conditionally show only one of them for a particular > >> range of bars e.g. display a small chart if the total number of bars is > >> lower than 10, etc. > >> Another option is to use Drillthrough on the datapoints. The top-level > >> chart > >> would probably only show the TOP 10 items/categories. The drillthrough > >> report could then show the details for a particular category. > >> > >> -- Robert > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> > >> "Jason L Lind" <JasonLLind@discussions.microsoft.com> wrote in message > >> news:0B50D06B-F79F-4F90-9A89-ACC73619337E@microsoft.com... > >> > Hi, I am trying to size a chart dynamically with respect to the number > >> > of > >> > rows in the data set it is rendering from (it's a bar chart) so that > >> > the > >> > graphic will render appropriatley. > >> > > >> > Is there any way to do this? > >> > > >> > Thank you, > >> > Jason Lind > >> > >> > >> > >
I would really love to know how you worked this out, but I don't see anything
relevant at this link. I'm facing a sizing issue wih a chart that has to handle a great variety of rows under different conditions. Can you please share your discovery? [quoted text, click to view] "Jason L Lind" wrote:
> I found a solution: > http://www.livejournal.com/users/jlind0/ > > "Robert Bruckner [MSFT]" wrote: > > > Sorry, dynamically growing charts is not supported right now. One workaround > > that comes in mind is to duplicate your chart with various width/height > > settings, overlay them and use the Visibility.Hidden property on the charts > > with expressions to conditionally show only one of them for a particular > > range of bars e.g. display a small chart if the total number of bars is > > lower than 10, etc. > > Another option is to use Drillthrough on the datapoints. The top-level chart > > would probably only show the TOP 10 items/categories. The drillthrough > > report could then show the details for a particular category. > > > > -- Robert > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > > > "Jason L Lind" <JasonLLind@discussions.microsoft.com> wrote in message > > news:0B50D06B-F79F-4F90-9A89-ACC73619337E@microsoft.com... > > > Hi, I am trying to size a chart dynamically with respect to the number of > > > rows in the data set it is rendering from (it's a bar chart) so that the > > > graphic will render appropriatley. > > > > > > Is there any way to do this? > > > > > > Thank you, > > > Jason Lind > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |