Obtaining SSRS 2000

What is a way of obtaining and licensing SQL 200 Reporting Services? Is it
available for a download?
ThanksOn Apr 10, 8:53 am, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> What is a way of obtaining and licensing SQL 200 Reporting Services? Is it
> available for a download?
> Thanks
I don't believe that SSRS 2000 is still available; however, the only
way to license it is to have a license for SQL Server 2000. Depending
on your needs, you could either obtain SQL Srever 2005 Express Edition
w/Advanced Services(incl.
http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en)
w/the SSRS Toolkit for the BIDS environment:
http://www.microsoft.com/downloads/details.aspx?familyid=E8AD606A-0960-4EFD-8BD7-B21370C7BE2B&displaylang=en
-or- you can purchase SQL Server 2005 (which will incl. SSRS). Hope
this is helpful.
Regards,
Enrique Martinez
Sr. Software Consultant|||What I have found is:
"SQL Server 2000 Reporting Services Evaluation Edition" download.
Can that be licensed with a license from SQL 2000 server?
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1176222887.227623.238510@.w1g2000hsg.googlegroups.com...
> On Apr 10, 8:53 am, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> What is a way of obtaining and licensing SQL 200 Reporting Services? Is
>> it
>> available for a download?
>> Thanks
> I don't believe that SSRS 2000 is still available; however, the only
> way to license it is to have a license for SQL Server 2000. Depending
> on your needs, you could either obtain SQL Srever 2005 Express Edition
> w/Advanced Services(incl.
> http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en)
> w/the SSRS Toolkit for the BIDS environment:
> http://www.microsoft.com/downloads/details.aspx?familyid=E8AD606A-0960-4EFD-8BD7-B21370C7BE2B&displaylang=en
> -or- you can purchase SQL Server 2005 (which will incl. SSRS). Hope
> this is helpful.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||The problem is, that is a 90 day evaluation edition that will time out.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:enB%23cL5eHHA.5052@.TK2MSFTNGP06.phx.gbl...
> What I have found is:
> "SQL Server 2000 Reporting Services Evaluation Edition" download.
> Can that be licensed with a license from SQL 2000 server?
> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
> news:1176222887.227623.238510@.w1g2000hsg.googlegroups.com...
>> On Apr 10, 8:53 am, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> What is a way of obtaining and licensing SQL 200 Reporting Services? Is
>> it
>> available for a download?
>> Thanks
>> I don't believe that SSRS 2000 is still available; however, the only
>> way to license it is to have a license for SQL Server 2000. Depending
>> on your needs, you could either obtain SQL Srever 2005 Express Edition
>> w/Advanced Services(incl.
>> http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en)
>> w/the SSRS Toolkit for the BIDS environment:
>> http://www.microsoft.com/downloads/details.aspx?familyid=E8AD606A-0960-4EFD-8BD7-B21370C7BE2B&displaylang=en
>> -or- you can purchase SQL Server 2005 (which will incl. SSRS). Hope
>> this is helpful.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>|||But I thought it can be registered within 90 days to avoid expiration.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e7dpNP5eHHA.4868@.TK2MSFTNGP06.phx.gbl...
> The problem is, that is a 90 day evaluation edition that will time out.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
> news:enB%23cL5eHHA.5052@.TK2MSFTNGP06.phx.gbl...
>> What I have found is:
>> "SQL Server 2000 Reporting Services Evaluation Edition" download.
>> Can that be licensed with a license from SQL 2000 server?
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1176222887.227623.238510@.w1g2000hsg.googlegroups.com...
>> On Apr 10, 8:53 am, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> What is a way of obtaining and licensing SQL 200 Reporting Services? Is
>> it
>> available for a download?
>> Thanks
>> I don't believe that SSRS 2000 is still available; however, the only
>> way to license it is to have a license for SQL Server 2000. Depending
>> on your needs, you could either obtain SQL Srever 2005 Express Edition
>> w/Advanced Services(incl.
>> http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en)
>> w/the SSRS Toolkit for the BIDS environment:
>> http://www.microsoft.com/downloads/details.aspx?familyid=E8AD606A-0960-4EFD-8BD7-B21370C7BE2B&displaylang=en
>> -or- you can purchase SQL Server 2005 (which will incl. SSRS). Hope
>> this is helpful.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>
>|||I'm not sure. I had to install RS 2000 to get this to occur. One point, the
evaluation edition is the equivalent of Enterprise Edition so if you just
activated it but all you want was Standard edition you would have a problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:OSF3$l5eHHA.1240@.TK2MSFTNGP04.phx.gbl...
> But I thought it can be registered within 90 days to avoid expiration.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e7dpNP5eHHA.4868@.TK2MSFTNGP06.phx.gbl...
>> The problem is, that is a 90 day evaluation edition that will time out.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Mark Goldin" <mgoldin@.ufandd.com> wrote in message
>> news:enB%23cL5eHHA.5052@.TK2MSFTNGP06.phx.gbl...
>> What I have found is:
>> "SQL Server 2000 Reporting Services Evaluation Edition" download.
>> Can that be licensed with a license from SQL 2000 server?
>> "EMartinez" <emartinez.pr1@.gmail.com> wrote in message
>> news:1176222887.227623.238510@.w1g2000hsg.googlegroups.com...
>> On Apr 10, 8:53 am, "Mark Goldin" <mgol...@.ufandd.com> wrote:
>> What is a way of obtaining and licensing SQL 200 Reporting Services?
>> Is it
>> available for a download?
>> Thanks
>> I don't believe that SSRS 2000 is still available; however, the only
>> way to license it is to have a license for SQL Server 2000. Depending
>> on your needs, you could either obtain SQL Srever 2005 Express Edition
>> w/Advanced Services(incl.
>> http://www.microsoft.com/downloads/details.aspx?familyid=5B5528B9-13E1-4DB9-A3FC-82116D598C3D&displaylang=en)
>> w/the SSRS Toolkit for the BIDS environment:
>> http://www.microsoft.com/downloads/details.aspx?familyid=E8AD606A-0960-4EFD-8BD7-B21370C7BE2B&displaylang=en
>> -or- you can purchase SQL Server 2005 (which will incl. SSRS). Hope
>> this is helpful.
>> Regards,
>> Enrique Martinez
>> Sr. Software Consultant
>>
>>
>|||If you have licensed SQL Server2000, you do not need to license RS2000, it
came free.
Your problem is that it may be too late to get it from MS, which does not
provide RS2000 download any more. If you cannot upgrade to SQL Server2005 at
this time, your best bet might be to contact the reseller where you bought
your SQL Server2000 from to see what they can do (it may be as simple as
giving you the CD, once they verified you have licensed SQL Server2000?).
There is no technical issue, just availability problem for an old software
(not old enough, though, especially for an expensive server software. MS
should make it available for longer, instead of implicitly enforcing upgrade
to SQL Server2005).
"Mark Goldin" <mgoldin@.ufandd.com> wrote in message
news:uORHbe3eHHA.3932@.TK2MSFTNGP02.phx.gbl...
> What is a way of obtaining and licensing SQL 200 Reporting Services? Is it
> available for a download?
> Thanks
>

Obtaining SQL RSS Developer Addition

I want to install SQL Reporting Services on my laptop which has Windows XP
Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
Where can I download or obtain the install file for SQL Reporting Services
Developer Edition?
- MaxI tried the same question a while ago with no reply out here.
No I bought msdn pro subscription to get visual studio and here I can
download rep s dev. edition as well.
You should think that you could get it for free if you have sql 2000 dev
edition, though...
"Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
> I want to install SQL Reporting Services on my laptop which has Windows XP
> Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> Where can I download or obtain the install file for SQL Reporting Services
> Developer Edition?
> - Max|||What are you trying to achieve Max?, the Reporting Services server-part does
not run on MSDE you can't install the reports-database on MSDE and it also
needs IIS to host the reports website.
Ed
"Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
>I want to install SQL Reporting Services on my laptop which has Windows XP
> Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> Where can I download or obtain the install file for SQL Reporting Services
> Developer Edition?
> - Max|||But you have different versions of rep s as welle as different versions of
sql server:
developers ediition
standard edition
entreprise edition
dev ed is much cheaper and can be used for dev purposes.
"Ed Richard" <Ed_XXX_@.wss-ed_REMOVE_.nl> wrote in message
news:%23mIKQ8tgFHA.3788@.tk2msftngp13.phx.gbl...
> What are you trying to achieve Max?, the Reporting Services server-part
does
> not run on MSDE you can't install the reports-database on MSDE and it also
> needs IIS to host the reports website.
> Ed
> "Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
> news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
> >I want to install SQL Reporting Services on my laptop which has Windows
XP
> > Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> >
> > Where can I download or obtain the install file for SQL Reporting
Services
> > Developer Edition?
> >
> > - Max
>|||I got lucky and found someone who had the setup file for SQL RSS Dev.
Edition. I am using it on SQL Dev Edition, not SQL MSDE (Desktop Edition).
And running iis on WinXP as well. All are working fine on my XP machine now.
"Michael Vardinghus" wrote:
> But you have different versions of rep s as welle as different versions of
> sql server:
> developers ediition
> standard edition
> entreprise edition
> dev ed is much cheaper and can be used for dev purposes.
> "Ed Richard" <Ed_XXX_@.wss-ed_REMOVE_.nl> wrote in message
> news:%23mIKQ8tgFHA.3788@.tk2msftngp13.phx.gbl...
> > What are you trying to achieve Max?, the Reporting Services server-part
> does
> > not run on MSDE you can't install the reports-database on MSDE and it also
> > needs IIS to host the reports website.
> >
> > Ed
> >
> > "Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
> > news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
> > >I want to install SQL Reporting Services on my laptop which has Windows
> XP
> > > Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> > >
> > > Where can I download or obtain the install file for SQL Reporting
> Services
> > > Developer Edition?
> > >
> > > - Max
> >
> >
>
>|||You can order a CD here:
http://www.microsoft.com/sql/reporting/howtobuy/retailfulfillment.mspx
Ed
"Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
>I want to install SQL Reporting Services on my laptop which has Windows XP
> Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> Where can I download or obtain the install file for SQL Reporting Services
> Developer Edition?
> - Max|||Hi,
This discussion is probably closed, but maybe you can still help me.
Could anyone ever find a link to download the Reporting Services Developer
Edition?
I have Reporting Services Evaluation Edition on my XP machine, but I wonder
what will happen when the 120 day trial duration expires and therefore wanna
install the developer edition.
Thanks,
Gul
"Ed Richard" wrote:
> You can order a CD here:
> http://www.microsoft.com/sql/reporting/howtobuy/retailfulfillment.mspx
> Ed
> "Max Tyack" <MaxTyack@.discussions.microsoft.com> wrote in message
> news:89C903A1-E927-4F26-93B0-6D8C63CEFDF5@.microsoft.com...
> >I want to install SQL Reporting Services on my laptop which has Windows XP
> > Pro, SQL 2000 Dev. Edition, and Visual Studio .NET 2003.
> >
> > Where can I download or obtain the install file for SQL Reporting Services
> > Developer Edition?
> >
> > - Max
>
>

Obtaining RS developer edition?

We just purchased the Visual Studio .NET Special Edition, which includes the
Developer Edition of SQL Server. However, there was no CD of Reporting
Services contained in the box, and I can't find it anywhere for download.
Where can I get it?
Thanks.
Jon Pearce
jonp at the domain below
dgapartners.dropthispart.comJon Pearce wrote:
> We just purchased the Visual Studio .NET Special Edition, which includes the
> Developer Edition of SQL Server. However, there was no CD of Reporting
> Services contained in the box, and I can't find it anywhere for download.
> Where can I get it?
http://www.microsoft.com/sql/reporting/howtobuy/default.asp
U.S. and Canadian retail customers can order the CD directly via the
website. ($5 U.S.)
-BA|||UK customers can get it from a MS reseller (e.g.
http://www.greymatter.co.uk)
Note that it is more expensive to order the media kit outside of North
Amaerica - though still not a bad price (Sterling £ 27). I see no reason
for the huge discrepancy though, especially as it's just a CD, not even
boxed!
"Jon Pearce" <jpearce@.noemail.com> wrote in message
news:eTv%23guJsEHA.3048@.tk2msftngp13.phx.gbl...
> We just purchased the Visual Studio .NET Special Edition, which includes
> the
> Developer Edition of SQL Server. However, there was no CD of Reporting
> Services contained in the box, and I can't find it anywhere for download.
> Where can I get it?
> Thanks.
> Jon Pearce
> jonp at the domain below
> dgapartners.dropthispart.com
>

Obtaining Reporting Services CD.

Hi,
I have been using the evaluation edition of RS but it has expired. I have
ordered the CD from MS but it shows as backordered. I'm not sure how long it
take to receive and I couldn't find any option to download from MS web site.
Does anyone know if there is a download available? I'm in a bind as we are
using some of the RS reports and cannot currently access them.
Thanks in advance, Neal...You can download RS if you have a MSDN subscription.
>--Original Message--
>Hi,
>I have been using the evaluation edition of RS but it has
expired. I have
>ordered the CD from MS but it shows as backordered. I'm
not sure how long it
>take to receive and I couldn't find any option to
download from MS web site.
>Does anyone know if there is a download available? I'm in
a bind as we are
>using some of the RS reports and cannot currently access
them.
>Thanks in advance, Neal...
>
>.
>|||That's what I thought, don't have MSDN subscription.
Thanks for the info...
"Dave Foderick" <anonymous@.discussions.microsoft.com> wrote in message
news:0d0901c47b18$9965be70$a501280a@.phx.gbl...
> You can download RS if you have a MSDN subscription.
>
> >--Original Message--
> >Hi,
> >I have been using the evaluation edition of RS but it has
> expired. I have
> >ordered the CD from MS but it shows as backordered. I'm
> not sure how long it
> >take to receive and I couldn't find any option to
> download from MS web site.
> >Does anyone know if there is a download available? I'm in
> a bind as we are
> >using some of the RS reports and cannot currently access
> them.
> >Thanks in advance, Neal...
> >
> >
> >.
> >|||If you're an EA customer, you should have received a CD in your May
distribution.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Neal" <neal@.hastingspark.com> wrote in message
news:%23gjcPYxeEHA.644@.tk2msftngp13.phx.gbl...
> Hi,
> I have been using the evaluation edition of RS but it has expired. I have
> ordered the CD from MS but it shows as backordered. I'm not sure how long
> it
> take to receive and I couldn't find any option to download from MS web
> site.
> Does anyone know if there is a download available? I'm in a bind as we are
> using some of the RS reports and cannot currently access them.
> Thanks in advance, Neal...
>

Object variable or With block variable not set

I was wondering if you have any knowledge of what I can be doing wrong.
Basically, here is what I want to do in SQL Reporting Services:
If field: Fields!Opportunity_Won_Loss_Open.Value = "Open" then SUM the
value for this field: Fields!Opportunity_EstRev
Here is the syntax I am using:
=SUM(Fields!Opportunity_EstRev.Value
(iif(Fields!Opportunity_Won_Loss_Open.Value = "Open",
Fields!Opportunity_Won_Loss_Open.Value, Nothing)))
When I run it, it returns an error: "Object variable or With block
variable not set."
I know independently that each separate syntax works because I have
them working in the same report:
=SUM(Fields!Opportunity_EstRev.Value)
=COUNT(iif(Fields!Opportunity_Won_Loss_Open.Value = "Open",
Fields!Opportunity_Won_Loss_Open.Value, Nothing))
When I try to combine them, they don't work. Logically, they make
sense to me combined, but I am sure I am messing up the syntax
somewhere. Would you have an idea? Any help would be greatly
appreciated
try:
=SUM(iif(Fields!Opportunity_Won_Loss_Open.Value = "Open",
Fields!Opportunity_EstRev.Value, 0))
=COUNT(iif(Fields!Opportunity_Won_Loss_Open.Value = "Open",1, Nothing))
=SUM(iif(Fields!Opportunity_Won_Loss_Open.Value = "Open", 1, 0))
-oj
<hendrix.craig@.gmail.com> wrote in message
news:1144162065.659636.72790@.j33g2000cwa.googlegro ups.com...
>I was wondering if you have any knowledge of what I can be doing wrong.
> Basically, here is what I want to do in SQL Reporting Services:
> If field: Fields!Opportunity_Won_Loss_Open.Value = "Open" then SUM the
> value for this field: Fields!Opportunity_EstRev
> Here is the syntax I am using:
> =SUM(Fields!Opportunity_EstRev.Value
> (iif(Fields!Opportunity_Won_Loss_Open.Value = "Open",
> Fields!Opportunity_Won_Loss_Open.Value, Nothing)))
> When I run it, it returns an error: "Object variable or With block
> variable not set."
> I know independently that each separate syntax works because I have
> them working in the same report:
> =SUM(Fields!Opportunity_EstRev.Value)
> =COUNT(iif(Fields!Opportunity_Won_Loss_Open.Value = "Open",
> Fields!Opportunity_Won_Loss_Open.Value, Nothing))
> When I try to combine them, they don't work. Logically, they make
> sense to me combined, but I am sure I am messing up the syntax
> somewhere. Would you have an idea? Any help would be greatly
> appreciated
>

Object variable or With block variable not set

I was wondering if you have any knowledge of what I can be doing wrong.
Basically, here is what I want to do in SQL Reporting Services:
If field: Fields!Opportunity_Won_Loss_Open.Value = "Open" then SUM the
value for this field: Fields!Opportunity_EstRev
Here is the syntax I am using:
=SUM(Fields!Opportunity_EstRev.Value
(iif(Fields!Opportunity_Won_Loss_Open.Value = "Open",
Fields!Opportunity_Won_Loss_Open.Value, Nothing)))
When I run it, it returns an error: "Object variable or With block
variable not set."
I know independently that each separate syntax works because I have
them working in the same report:
=SUM(Fields!Opportunity_EstRev.Value)
=COUNT(iif(Fields!Opportunity_Won_Loss_O
pen.Value = "Open",
Fields!Opportunity_Won_Loss_Open.Value, Nothing))
When I try to combine them, they don't work. Logically, they make
sense to me combined, but I am sure I am messing up the syntax
somewhere. Would you have an idea? Any help would be greatly
appreciatedtry:
=SUM(iif(Fields!Opportunity_Won_Loss_Ope
n.Value = "Open",
Fields!Opportunity_EstRev.Value, 0))
=COUNT(iif(Fields!Opportunity_Won_Loss_O
pen.Value = "Open",1, Nothing))
=SUM(iif(Fields!Opportunity_Won_Loss_Ope
n.Value = "Open", 1, 0))
-oj
<hendrix.craig@.gmail.com> wrote in message
news:1144162065.659636.72790@.j33g2000cwa.googlegroups.com...
>I was wondering if you have any knowledge of what I can be doing wrong.
> Basically, here is what I want to do in SQL Reporting Services:
> If field: Fields!Opportunity_Won_Loss_Open.Value = "Open" then SUM the
> value for this field: Fields!Opportunity_EstRev
> Here is the syntax I am using:
> =SUM(Fields!Opportunity_EstRev.Value
> (iif(Fields!Opportunity_Won_Loss_Open.Value = "Open",
> Fields!Opportunity_Won_Loss_Open.Value, Nothing)))
> When I run it, it returns an error: "Object variable or With block
> variable not set."
> I know independently that each separate syntax works because I have
> them working in the same report:
> =SUM(Fields!Opportunity_EstRev.Value)
> =COUNT(iif(Fields!Opportunity_Won_Loss_O
pen.Value = "Open",
> Fields!Opportunity_Won_Loss_Open.Value, Nothing))
> When I try to combine them, they don't work. Logically, they make
> sense to me combined, but I am sure I am messing up the syntax
> somewhere. Would you have an idea? Any help would be greatly
> appreciated
>