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 WHERE for columns

Hi everybody,
Is there a way to filter columns at runtime based on their name?

I create SELECT statement which includes all columns, then, if I get some parameter I leave some columns out and don't select data from them.

Is it possible?

I'm working with MS SQL 2000.You can't omit columns. The closest thing you can do is use CASE expressions to hide the data you don't want to show, such as:

SELECT Col1, Col2, CASE WHEN Col1 = 'someValue' THEN Col3 ELSE NULL END AS Col3
FROM YourTable|||Is this possible:

SELECT Col1, Col2, CASE WHEN SomethingOutsideThisSelectCommand = 'someValue' THEN Col3 ELSE NULL END AS Col3
FROM YourTable|||As long as it's a valid SQL expression, it shouldn't be a problem.

Is there any way to access report objects at runtime

Hi all,

In my report, I have an image object that I want it to load dynamically at runtime. How can I access it from code.

Many thanks,

Huy Le

You can reference the image as a url, or from the database (I think). I'd probably go the url route, if you can either reference the image file itself via url, or else have a .net web page that displays the image based on query string parameters.

Steve