> I have reviewed the various threads related to seconday y-axis in the
current
> version of Microsoft Reporting Services. One thread in particular with a
> reply as follows from Robert Bruckner had me interested in a the work
around
> mentioned... but the link is dead.
>
> ------------------------------------------
>
>
> Secondary Y-axis is not natively supported in RS 2000, but is on the list
> for inclusion in a future release. Some workarounds for RS 2000 are
> discussed here:
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=687c54df-a60c-4484-8d2b-3159cbc924d1&sloc=en-us
>
>
> ______________________________
>
>
> 1) Does anyone have any info on this link and what these workarounds are
>
> 2) I have read the thread on combinational charts at the below link as
well.
>
>
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us#0371987e-05b3-4fd5-a972-7734b717323f
>
> 3) Will a secondary Y axis be available in SQL Server 2005 as reported in
> another thread by an MSFT employee in the newsgroup through the use of
Dundas
> Enterprise.... as MS Certified Partner we use Reporting Services as a
> critical part of our solution and are having client requests on is there a
> workaround or when will secondary y axis be available through reporting
> services.
>
>

"Robert Bruckner [MSFT]" wrote:

> I can imagine four workarounds for RS 2000 (each of them has certain
> drawbacks). The first three will work on initial release, the last one will
> require SP1 for RS 2000.
>
> #1) Static background image
> Look at the "Backgroundimage" property of the chart. You could create a
> backgroundimage that "draws" the second Y-axis. Note: the backgroundimage is
> always put inside the chart plotarea (rather than the entire chart area).
> The benefit of this approach is that it will automatically rescale the
> backgroundimage if the size of the plotarea changes based the size of legend
> or labels based on the data at runtime. However, the drawback of this trick
> is that the image is drawn *inside* the plotarea (so it will appear
> differently than the x-axis). Most likely you will need to turn *on* margins
> for the x-axis to get reasonable results with this workaround. Note: this
> approach has several limitations (especially if you want to use
> "auto-scaling" of your data).
>
> #2) Dynamic background image
> Follow #1 above and generate a parameterized background image in a custom
> assembly. The background image element would then look something like this:
> <BackgroundImage>
> <MIMEType>image/bmp</MIMEType>
> <BackgroundRepeat>NoRepeat</BackgroundRepeat>
> <Source>Database</Source>
> <Value>=Code.MyImageClass.GenerateChartBG( ... )</Value>
> </BackgroundImage>
>
> #3) Overlaying
> Try to overlay charts, where the second chart uses an x-axis with "Reversed"
> turned on. Note: overlaying will *only* work in image-oriented renderers
> (Preview, PDF, TIFF). It will definitely not work in HTML, because it does
> not support overlapping items. In addition, overlaying charts has
> issues when you cannot exactly control your data or use auto-scaling
> (because the position of the plotarea inside the chartarea is automatically
> controlled by the chart control and depends on many factors, like label
> lengths, legend position, etc.)
>
> #4) External charting
> SP1 enables URL-based external image resources. You could create reports
> that fetch (chart) images from external web servers. The report would then
> just contain an image and the content of the
> image would come from another webserver.
>
> Regarding RS 2005: Secondary Y-axis will be supported through the Dundas
> Enterprise Edition and maybe other partners which integrate their charting
> solutions through the new CustomReportItem feature.
> Native support for secondary Y-axis is still under consideration.
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
> "Michael Ruminer" <Michael Ruminer@discussions.microsoft.com> wrote in
> message news:51EF2B49-EEBE-4663-88FB-A0EFCCD30FBD@microsoft.com...
> > I have reviewed the various threads related to seconday y-axis in the
> current
> > version of Microsoft Reporting Services. One thread in particular with a
> > reply as follows from Robert Bruckner had me interested in a the work
> around
> > mentioned... but the link is dead.
> >
> > ------------------------------------------
> >
> >
> > Secondary Y-axis is not natively supported in RS 2000, but is on the list
> > for inclusion in a future release. Some workarounds for RS 2000 are
> > discussed here:
> >
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=687c54df-a60c-4484-8d2b-3159cbc924d1&sloc=en-us
> >
> >
> > ______________________________
> >
> >
> > 1) Does anyone have any info on this link and what these workarounds are
> >
> > 2) I have read the thread on combinational charts at the below link as
> well.
> >
> >
> http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=f23bb56f-ba12-4890-b0f2-2288a8914d91&sloc=en-us#0371987e-05b3-4fd5-a972-7734b717323f
> >
> > 3) Will a secondary Y axis be available in SQL Server 2005 as reported in
> > another thread by an MSFT employee in the newsgroup through the use of
> Dundas
> > Enterprise.... as MS Certified Partner we use Reporting Services as a
> > critical part of our solution and are having client requests on is there a
> > workaround or when will secondary y axis be available through reporting
> > services.
> >
> >
>
>