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

Is there equivalent to Sybase Dynamic Archiving for SQL Server

Sybase has a product called Dynamic Archiving which will automatically move
old records to a archive database, but all applications will see the two
database as one (no changes to source code etc.)
Is there an equivalent for SQL Server (either now, or part of 2005, or third
party) ?
Any help would be appreciated...
Regards,
Mark Donoghue
MDonoghue@.refco.comI'm not aware of anything identical.
In SQL2K... you might be able to achieve a similiar effect by looking at
Partioned Views. Not real archiving, but you might get some of the benefits
you're looking for. Stricktly a roll your own solution.
SQL2005 adds support for partioned ranges (using multiple tables) that will
make it much easier to manage this. But still roll your own.
--
"Mark Donoghue" <MarkDonoghue@.discussions.microsoft.com> wrote in message
news:A27078A5-CD17-46C1-8DD1-AA9DA6002730@.microsoft.com...
> Sybase has a product called Dynamic Archiving which will automatically
move
> old records to a archive database, but all applications will see the two
> database as one (no changes to source code etc.)
> Is there an equivalent for SQL Server (either now, or part of 2005, or
third
> party) ?
> Any help would be appreciated...
> Regards,
> Mark Donoghue
> MDonoghue@.refco.com

Is there equivalent to Sybase Dynamic Archiving for SQL Server

Sybase has a product called Dynamic Archiving which will automatically move
old records to a archive database, but all applications will see the two
database as one (no changes to source code etc.)
Is there an equivalent for SQL Server (either now, or part of 2005, or third
party) ?
Any help would be appreciated...
Regards,
Mark Donoghue
MDonoghue@.refco.com
I'm not aware of anything identical.
In SQL2K... you might be able to achieve a similiar effect by looking at
Partioned Views. Not real archiving, but you might get some of the benefits
you're looking for. Stricktly a roll your own solution.
SQL2005 adds support for partioned ranges (using multiple tables) that will
make it much easier to manage this. But still roll your own.
"Mark Donoghue" <MarkDonoghue@.discussions.microsoft.com> wrote in message
news:A27078A5-CD17-46C1-8DD1-AA9DA6002730@.microsoft.com...
> Sybase has a product called Dynamic Archiving which will automatically
move
> old records to a archive database, but all applications will see the two
> database as one (no changes to source code etc.)
> Is there an equivalent for SQL Server (either now, or part of 2005, or
third
> party) ?
> Any help would be appreciated...
> Regards,
> Mark Donoghue
> MDonoghue@.refco.com

Is there equivalent to Sybase Dynamic Archiving for SQL Server

Sybase has a product called Dynamic Archiving which will automatically move
old records to a archive database, but all applications will see the two
database as one (no changes to source code etc.)
Is there an equivalent for SQL Server (either now, or part of 2005, or third
party) ?
Any help would be appreciated...
Regards,
Mark Donoghue
MDonoghue@.refco.comI'm not aware of anything identical.
In SQL2K... you might be able to achieve a similiar effect by looking at
Partioned Views. Not real archiving, but you might get some of the benefits
you're looking for. Stricktly a roll your own solution.
SQL2005 adds support for partioned ranges (using multiple tables) that will
make it much easier to manage this. But still roll your own.
"Mark Donoghue" <MarkDonoghue@.discussions.microsoft.com> wrote in message
news:A27078A5-CD17-46C1-8DD1-AA9DA6002730@.microsoft.com...
> Sybase has a product called Dynamic Archiving which will automatically
move
> old records to a archive database, but all applications will see the two
> database as one (no changes to source code etc.)
> Is there an equivalent for SQL Server (either now, or part of 2005, or
third
> party) ?
> Any help would be appreciated...
> Regards,
> Mark Donoghue
> MDonoghue@.refco.com