Is this possible?

Hi,
I have a request for dynamic creation of the chart axis scale at runtime
from some users, based on the displayed results. Is this possible?
ThanksNot with this version (unfortunately, I too wanted to do this). It should be
possible with the next version.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:DA499EA5-FBBE-4B0F-967E-BD7C5E369744@.microsoft.com...
> Hi,
> I have a request for dynamic creation of the chart axis scale at runtime
> from some users, based on the displayed results. Is this possible?
> Thanks|||If you don't specify any values for min/max (leave it empty), the axis will
scale automatically based on the data values.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
news:DA499EA5-FBBE-4B0F-967E-BD7C5E369744@.microsoft.com...
> Hi,
> I have a request for dynamic creation of the chart axis scale at runtime
> from some users, based on the displayed results. Is this possible?
> Thanks|||I'm afraid that when you do this however it makes its decision is, shall we
say, less than perfect in real life. I found it useless and decided to only
create graphs where I manually set the axis. This causes me to limit the
amount of graphing I do.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uDqnVzbHFHA.1476@.TK2MSFTNGP09.phx.gbl...
> If you don't specify any values for min/max (leave it empty), the axis
will
> scale automatically based on the data values.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
> news:DA499EA5-FBBE-4B0F-967E-BD7C5E369744@.microsoft.com...
> > Hi,
> >
> > I have a request for dynamic creation of the chart axis scale at runtime
> > from some users, based on the displayed results. Is this possible?
> >
> > Thanks
>|||Are you using auto-scaling on the X or Y axis?
The results of axis auto-scaling are not always perfect - that's why
expression-based min/max/etc. will be available in the SQL 2005 release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OIA6GOcHFHA.4032@.TK2MSFTNGP12.phx.gbl...
> I'm afraid that when you do this however it makes its decision is, shall
> we
> say, less than perfect in real life. I found it useless and decided to
> only
> create graphs where I manually set the axis. This causes me to limit the
> amount of graphing I do.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:uDqnVzbHFHA.1476@.TK2MSFTNGP09.phx.gbl...
>> If you don't specify any values for min/max (leave it empty), the axis
> will
>> scale automatically based on the data values.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
>> news:DA499EA5-FBBE-4B0F-967E-BD7C5E369744@.microsoft.com...
>> > Hi,
>> >
>> > I have a request for dynamic creation of the chart axis scale at
>> > runtime
>> > from some users, based on the displayed results. Is this possible?
>> >
>> > Thanks
>>
>|||The issue for me is Y axis.
Allowing expression based scaling will solve the problem for me.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:%23rnxXWcHFHA.2156@.TK2MSFTNGP09.phx.gbl...
> Are you using auto-scaling on the X or Y axis?
> The results of axis auto-scaling are not always perfect - that's why
> expression-based min/max/etc. will be available in the SQL 2005 release.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OIA6GOcHFHA.4032@.TK2MSFTNGP12.phx.gbl...
> > I'm afraid that when you do this however it makes its decision is, shall
> > we
> > say, less than perfect in real life. I found it useless and decided to
> > only
> > create graphs where I manually set the axis. This causes me to limit the
> > amount of graphing I do.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> > news:uDqnVzbHFHA.1476@.TK2MSFTNGP09.phx.gbl...
> >> If you don't specify any values for min/max (leave it empty), the axis
> > will
> >> scale automatically based on the data values.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >> "Spencer23" <Spencer23@.discussions.microsoft.com> wrote in message
> >> news:DA499EA5-FBBE-4B0F-967E-BD7C5E369744@.microsoft.com...
> >> > Hi,
> >> >
> >> > I have a request for dynamic creation of the chart axis scale at
> >> > runtime
> >> > from some users, based on the displayed results. Is this possible?
> >> >
> >> > Thanks
> >>
> >>
> >
> >
>|||Spencer23,
I have a similar problem, and use a fairly clumsy work-round. I have an area
graph where the Y values are in the tens of thousands, but the Y-value
changes across the graph can be quite small - normally less than 100.
Ideally I would like to use a formula to calculate the value where the Y
axis crosses the X axis, but that is not possible yet.
Instead I reduce all Y values by an amount calculated at run time, and
indicate the adjustment in the axis title. So instead of "Count" the Y axis
title says "Count - nnnn" where nnn is the calculated amount.
The formula for the Y axis title is similar to this:
=IIF( 0 = (Min(Fields!Count.Value) \ 100),"","Count - " & 100 *
(Min(Fields!Count.Value) \ 100))
The formula for the first series (with the highest values) is similar to this:
=Fields!NewTotal.Value - (Min(Fields!Count.Value, "dsForTheChart") \ 100) *
100
The formluas for the other series use different fields from the dataset, but
all are reduced by tehe same amount
HTH
"Spencer23" wrote:
> Hi,
> I have a request for dynamic creation of the chart axis scale at runtime
> from some users, based on the displayed results. Is this possible?
> Thanks