external link table

Does SQL server support external link database like DB2 or Oracle through
ODBC?
Any information is appreciated.
See the topic, "Configuring Linked Servers" in SQL Server Books
Online. It describes how to set up and configure a linked server to
access OLE DB data sources.
--Mary
On Sat, 8 Jan 2005 19:42:31 -0500, "souris" <inungh@.videotron.ca>
wrote:

>Does SQL server support external link database like DB2 or Oracle through
>ODBC?
>Any information is appreciated.
>
|||Thanks millions,
Souris
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:s4b3u0hai65rjbo35v78m3a1gc0gc44i8g@.4ax.com...
> See the topic, "Configuring Linked Servers" in SQL Server Books
> Online. It describes how to set up and configure a linked server to
> access OLE DB data sources.
> --Mary
> On Sat, 8 Jan 2005 19:42:31 -0500, "souris" <inungh@.videotron.ca>
> wrote:
>

external link table

Does SQL server support external link database like DB2 or Oracle through
ODBC?
Any information is appreciated.See the topic, "Configuring Linked Servers" in SQL Server Books
Online. It describes how to set up and configure a linked server to
access OLE DB data sources.
--Mary
On Sat, 8 Jan 2005 19:42:31 -0500, "souris" <inungh@.videotron.ca>
wrote:

>Does SQL server support external link database like DB2 or Oracle through
>ODBC?
>Any information is appreciated.
>|||Thanks millions,
Souris
"Mary Chipman" <mchip@.online.microsoft.com> wrote in message
news:s4b3u0hai65rjbo35v78m3a1gc0gc44i8g@.
4ax.com...
> See the topic, "Configuring Linked Servers" in SQL Server Books
> Online. It describes how to set up and configure a linked server to
> access OLE DB data sources.
> --Mary
> On Sat, 8 Jan 2005 19:42:31 -0500, "souris" <inungh@.videotron.ca>
> wrote:
>
>

expressions linked to parameters

Is it possible to link expressions to report parameters
for instance i have WTD, MTD and YTD sales targets in my DB and have
WTD, MTD and YTD as report Parameters can i do this?
If i select MTD link the Expression to say if MTD then Show MTD sales
target etc etcOn Jun 8, 10:23 am, blueboy <matt_me...@.hotmail.com> wrote:
> Is it possible to link expressions to report parameters
> for instance i have WTD, MTD and YTD sales targets in my DB and have
> WTD, MTD and YTD as report Parameters can i do this?
> If i select MTD link the Expression to say if MTD then Show MTD sales
> target etc etc
If I'm understanding you correctly, you will want to access the values
of a parameter as opposed to if a parameter value has been selected or
not. Something like this should work:
=iif(Parameters!SalesTargetParam.Value = "MTD", Fields!
MTDSalesTarget.Value, Nothing)
Of course, this should also work:
=switch(Parameters!SalesTargetParam.Value = "WTD", Fields!
WTDSalesTarget.Value, Parameters!SalesTargetParam.Value = "MTD",
Fields!MTDSalesTarget.Value, Parameters!SalesTargetParam.Value ="YTD", Fields!YTDSalesTarget.Value, true, nothing)
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant