Reporting Services 2005 in VS.2005?

We are on SQL server 2000 (sp4).
We have upgraded to Visual Studio 2005 (from .NET 2003)
We installed SQL server 2005 reporting services,
on a separate machine (separate from the machine that has
sql server 2000.
But when we open our Visual Studio 2005 IDE,
on a client machine, we can't find any template for creating a reporting
services project.
Microsoft's site has nothing but ads, I couldn't find
anything there on what to do
What do we do?
Thanks in Advance,
Laurence Nuttall
Programmer Analyst III
UCLA - Division of Continuing EducationHave you tried running the setup.exe in the tools directory of your SQL2005
CD? That should have all the desktop tools you need.
"Larry" wrote:
> We are on SQL server 2000 (sp4).
> We have upgraded to Visual Studio 2005 (from .NET 2003)
> We installed SQL server 2005 reporting services,
> on a separate machine (separate from the machine that has
> sql server 2000.
> But when we open our Visual Studio 2005 IDE,
> on a client machine, we can't find any template for creating a reporting
> services project.
> Microsoft's site has nothing but ads, I couldn't find
> anything there on what to do
> What do we do?
> Thanks in Advance,
> Laurence Nuttall
> Programmer Analyst III
> UCLA - Division of Continuing Education
>
>
>

REPORTING SERVICES 2005 AND VISUAL STUDIO 2003

Hi everyone
I would like to put the following question...
I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
MSQL2000 Database?
Do I need to Install Visual Studio 2005 ?
Thanks a lot
MiltosRS 2005 comes with a version of VS 2005. You do not have to purchase it.
Just install the BI tools from the SQL Server 2005 disk. RS 2005 can use SQL
Server 2000 db for its object/metadata (as long as you have the SQL Server
2005 license) the biggest issue is installing side by side on the database
with RS 2000. The other issue is IIS. One part of IIS (RS 2000) needs to
stay at 1.1, the other needs to be at 2.0. So you upgrade IIS with 2.0
framework and then you have to get the initial sites back to 1.1.
I believe all of this is possible but it is non-trivial.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<milmen@.tellas.gr> wrote in message
news:1155895924.922028.277620@.m79g2000cwm.googlegroups.com...
> Hi everyone
> I would like to put the following question...
> I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
> and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
> MSQL2000 Database?
> Do I need to Install Visual Studio 2005 ?
> Thanks a lot
> Miltos
>|||I have the same predicament.
I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
RS2000
The client wanted to upgrade SQL to 2005 but now I have difficulties
running my application which runs on Framework 1.1 to call RS2005 now
using Framework 2.
So to solve it, I downgraded RS back to 2000.|||There was no reason to downgrade RS. There are two ways to be integrating:
URL Integration and Web Services. Both are still available to you from your
application. The web server has to be told which sites are still running
1.1, then the sites used by RS 2005 use 2.0.
Also, his case was that he wanted to have RS 2000 and RS 2005 side by side.
That does not seem to be the case for you. Your situation seemed to be one
of integration which should not be a problem at all.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rGenius" <ruellacaste@.gmail.com> wrote in message
news:1156490695.127315.56360@.b28g2000cwb.googlegroups.com...
>I have the same predicament.
> I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
> RS2000
> The client wanted to upgrade SQL to 2005 but now I have difficulties
> running my application which runs on Framework 1.1 to call RS2005 now
> using Framework 2.
> So to solve it, I downgraded RS back to 2000.
>

Reporting Services 2000 with Visual Studio 2005

Does anybody know if there is way to use Reporting Services 2000 with
Visual Studio 2005 (design reports for Reporting Services 2000)?
Regards,
SumardiNo. You cannot do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sumardi" <sumardi.sm@.gmail.com> wrote in message
news:1144943881.019142.217550@.i39g2000cwa.googlegroups.com...
> Does anybody know if there is way to use Reporting Services 2000 with
> Visual Studio 2005 (design reports for Reporting Services 2000)?
> Regards,
> Sumardi
>|||Can't I have VS 2003 / VS 2005 Report Designers both side-by-side? I need
to design reports to target RS 2000 as well as RS 2005. I have both VS
products installed, but I need to somehow enable RS projects in my VS 2003
environment.. only my VS2005 environment has RS projects enabled.. aaah! I
have SQL 2005 on the box too..
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23O1a0$xXGHA.4988@.TK2MSFTNGP05.phx.gbl...
> No. You cannot do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Sumardi" <sumardi.sm@.gmail.com> wrote in message
> news:1144943881.019142.217550@.i39g2000cwa.googlegroups.com...
>> Does anybody know if there is way to use Reporting Services 2000 with
>> Visual Studio 2005 (design reports for Reporting Services 2000)?
>> Regards,
>> Sumardi
>

Reporting Services 2000 Requirement for Visual Studio

I have a client who already has SQL-2000 SP4 installed and now wishes
to have reporting services installed.
The installation indicates a pre-requisite of Visual Sudio .Net 2003.
Further investigation on Microsoft web site reveals that VS would have
to be version "Enterprise Developer" or "Enterprise Architect."
I know in SQL 2005 that VS is included. One option presented to the
client would be to upgrade.
My question is, was any form of visual studio included with SQL 2000
or will the client need to purchase a license for Visual Studio .Net
2003? Is VS .Net 2003 even still available?
Thanks in advance.
DanThat is some information which is not quite true...
> The installation indicates a pre-requisite of Visual Sudio .Net 2003.
> Further investigation on Microsoft web site reveals that VS would have
> to be version "Enterprise Developer" or "Enterprise Architect."
No, you will just need a one-language version of Visual Studio, thats
all, without nailing me down on the price, that should be around 100$.
> I know in SQL 2005 that VS is included. One option presented to the
> client would be to upgrade.
Sort of. You will be able to create Report / Analysis and SSIS
projects with the "small" edition of this studio.
> My question is, was any form of visual studio included with SQL 2000
> or will the client need to purchase a license for Visual Studio .Net
> 2003?
No, there was non included. Yes, he would have to buy a licencse for
that, see the above mentioned answer.
> Is VS .Net 2003 even still available?
-Yes, it is. I assume that not all vendors of your choice will still
have it, but it is available in some places. Perhaps you might find a
version on ebay which was exchanged by someone with the 2k5 version.
HTH, Jens K. Suessmeyer
--
http://www.sqlserver2005.de
--|||First off, you need any product that has VS 2003, it definitely does NOT
need to be Enterprise Developer or Enterprise Architect. Very definitely
not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
However, I don't know how you go about finding a copy to buy.
Now, if Enterprise Developer is the only one that you can find to purchase
it will work but any product that comes with VS 2003 will work.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<dan.dunkin@.at-net.net> wrote in message
news:dn34t25397nlkhi59fb3sgjn21qh8kdfan@.4ax.com...
>I have a client who already has SQL-2000 SP4 installed and now wishes
> to have reporting services installed.
> The installation indicates a pre-requisite of Visual Sudio .Net 2003.
> Further investigation on Microsoft web site reveals that VS would have
> to be version "Enterprise Developer" or "Enterprise Architect."
> I know in SQL 2005 that VS is included. One option presented to the
> client would be to upgrade.
> My question is, was any form of visual studio included with SQL 2000
> or will the client need to purchase a license for Visual Studio .Net
> 2003? Is VS .Net 2003 even still available?
> Thanks in advance.
> Dan|||The MS web site says enterprise developer or architect are the only
ones that talk to SQL Server as opposed to destop databases (Access,
SQL Desktop). Do they mean something else (like you only need
enterprise for applications that directly access the database not
reports that will be run through report writer)?
On a side note, will Visual Studio 2005 Express (the free one) work?
Will any version of Visual Studio 2005 work?
Thanks!
On Tue, 13 Feb 2007 13:40:52 -0600, "Bruce L-C [MVP]"
<bruce_lcNOSPAM@.hotmail.com> wrote:
>First off, you need any product that has VS 2003, it definitely does NOT
>need to be Enterprise Developer or Enterprise Architect. Very definitely
>not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
>However, I don't know how you go about finding a copy to buy.
>Now, if Enterprise Developer is the only one that you can find to purchase
>it will work but any product that comes with VS 2003 will work.|||Don=B4t know, but the information given by Bruce and me is valid. You
might want to share the link with us where this statement resides.
-Jens.
--
http://www.sqlserver2005.de
--|||In this case it is a little different. You are only using VS to have
something to install the report designer into. So in this case what you are
reading about is something else entirely.
RS 2000 requires some version of VS 2003. Neither of the two you mention
will work. They use a different version of the framework (2.0 instead of 1.1
that RS 2000 uses).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<dan.dunkin@.at-net.net> wrote in message
news:gu64t21phn1tcq8mga7kprscoii7u9jfm2@.4ax.com...
> The MS web site says enterprise developer or architect are the only
> ones that talk to SQL Server as opposed to destop databases (Access,
> SQL Desktop). Do they mean something else (like you only need
> enterprise for applications that directly access the database not
> reports that will be run through report writer)?
> On a side note, will Visual Studio 2005 Express (the free one) work?
> Will any version of Visual Studio 2005 work?
> Thanks!
> On Tue, 13 Feb 2007 13:40:52 -0600, "Bruce L-C [MVP]"
> <bruce_lcNOSPAM@.hotmail.com> wrote:
>>First off, you need any product that has VS 2003, it definitely does NOT
>>need to be Enterprise Developer or Enterprise Architect. Very definitely
>>not. The cheapest way is to get VB.Net 2003, it used to cost about $100.
>>However, I don't know how you go about finding a copy to buy.
>>Now, if Enterprise Developer is the only one that you can find to purchase
>>it will work but any product that comes with VS 2003 will work.|||THANK YOU! for everyone's help.
Dan

Reporting Services 2000 and Visual Studio 2005

I am new to Reporting Services. Is it true that you have to have Visual Studio 2003 installed in order to use the Report Designer to create reports to be published in Reporting Services 2000? Is there a way around this?

Thanks!

you need it. You really only need vb .net std 2003 ($100 retail if you can find it). I looked on ebay and found a couple copies for sale. You could probably get them for cheap.sql

Reporting Services (Page Issue)

I have created a report in visual studio 2005, using the reportserver. I am able to create the report as a pdf, but for somereason, data is begin shown on every other page.

Does anyone know what might cause this?

Before deploying the report have a look at it in preview mode sounds like you may have a margin applied that is increasing the overall width of your page and causing it to go onto the next page|||Thank you. That was the problem

Reporting Services -- Connection issues

RS Web Site and database on the same WIN 2003 Server. Visual Studio dev on
a XP Pro.
Installation was no problem ... installed the AdventureWorks sample reports
(via a Command script).
Able to open http://<servername>/reports however when running the sample
reports the following message is received "An error has occurred during
report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'AdventureWorks'.
(rsErrorOpeningConnection)"
I have unsuccessfully reset the "Data Source Properties" several ways
(credential are not required and Use Win credentals with Impersonate, and
etc)
Additionally when creating a report with VS all the dataset queries run fine
... the report "Preview" returns the report and no error when doing a
"Build". However when "Deploying" this error message is returned " The
report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing."
Some sort of successful connection has to exist to return the Web page with
the sample reports listed and the successful "Preview'. So what's the
problem.
Could this be an issue because the SQL Server installation is a 'Named
Instance' .. If so is there a work around?
Thanks in advance
GeneH
I miss posted this question ... I have move it to sqlserver.reportingsvcs
thanks
"GeneH" wrote:

> RS Web Site and database on the same WIN 2003 Server. Visual Studio dev on
> a XP Pro.
> Installation was no problem ... installed the AdventureWorks sample reports
> (via a Command script).
> Able to open http://<servername>/reports however when running the sample
> reports the following message is received "An error has occurred during
> report processing. (rsProcessingAborted) Get Online Help
> Cannot create a connection to data source 'AdventureWorks'.
> (rsErrorOpeningConnection)"
> I have unsuccessfully reset the "Data Source Properties" several ways
> (credential are not required and Use Win credentals with Impersonate, and
> etc)
> Additionally when creating a report with VS all the dataset queries run fine
> ... the report "Preview" returns the report and no error when doing a
> "Build". However when "Deploying" this error message is returned " The
> report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing."
>
> Some sort of successful connection has to exist to return the Web page with
> the sample reports listed and the successful "Preview'. So what's the
> problem.
> Could this be an issue because the SQL Server installation is a 'Named
> Instance' .. If so is there a work around?
> --
> Thanks in advance
> GeneH
sql

reporting services

I have a probleme with visual studio express edition 2005; I couldn't find the server report feature where can I put my reports.Also,many features dont work when I want create an application to access my reports creates whith reporting services.

what to do ?

I'm not sure whether the express edition comes with this, but you want to find a control in the toolbox called Report Viewer.|||Hi Fayoub

The first mistake I made when doing this was not having IIS installed on my local machine.
Have you got IIS installed?

Cheers
Mark
|||

hi,

first, thanks for your interest.

To answer your question I don't have installed IIS,but I have an Apache server

|||I'm afraid that reporting services needs IIS.
You should be able install this from your Win XP CD but based on my experiences you will then probably have to uninstall and reinstall SQl Server express (with advanced services to include reporting services)
|||ok,I heared about Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

do you think it could be helpful to deploy my reports.Otherwise,I will work on IIS

|||

I have a 64-bit server (Xeon Quad Core) running Windows Server 2003

Standard R2 64-bit. This server is setup as a domain controller, and I

also have Microsoft Exchange Server 2007 running on this same server.

I recently attempted to install SQL Server 2005 Standard on the server.

The disks I have for SQL Server do not specifically say they are the

64-bit version. However during setup, it did say that it was installing

the 64-bit version of the components, with the exception of the

Reporting Services.

I received 1 error during setup which basically said that there was a

problem with Reporting Services registration because I have a 64-bit

version of ASP.NET, and that Reporting Services 32-bit version requires

the 32-bit version of ASP.NET. I have both .NET version 2 and 3

installed, both of which are 64-bit versions.

My question is, how can I install the 64-bit version of Reporting

Services? I am pretty sure the SQL Server 2005 disks I own have both 32

and 64-bit versions on the same disk (because I clearly saw it was

installing 64-bit versions of SQL components, with the exception of the

Reporting Services), although the label on the disks do not specifically

say 64-bit version.

I also realize there is a command that will allow me to run IIS in

32-bit emulation mode and hence allow me to install the 32-bit version

of Reporting Services. However, this mode will not work with Exchange

2007, so using this mode is not an option for me. I must be missing

something here. Any suggestions would be greatly appreciated. Thanks!

|||

Fayoub

I am not sure if the express edition works with sharepoint.

By default reports are automatically deployed to

http://localhost/reportserver$SQLExpress

For full instructions about setting the deployment server see this article

http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx

Perhaps you should look through the following couple of articles to see what the express edition can and can;t do:

http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

http://msdn2.microsoft.com/en-us/library/ms365166.aspx

hearsaym I'm afraid I can't help. Perhaps you should post the question i na new topic

reporting services

I have a probleme with visual studio express edition 2005; I couldn't find the server report feature where can I put my reports.Also,many features dont work when I want create an application to access my reports creates whith reporting services.

what to do ?

I'm not sure whether the express edition comes with this, but you want to find a control in the toolbox called Report Viewer.|||Hi Fayoub

The first mistake I made when doing this was not having IIS installed on my local machine.
Have you got IIS installed?

Cheers
Mark
|||

hi,

first, thanks for your interest.

To answer your question I don't have installed IIS,but I have an Apache server

|||I'm afraid that reporting services needs IIS.
You should be able install this from your Win XP CD but based on my experiences you will then probably have to uninstall and reinstall SQl Server express (with advanced services to include reporting services)
|||ok,I heared about Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

do you think it could be helpful to deploy my reports.Otherwise,I will work on IIS

|||

I have a 64-bit server (Xeon Quad Core) running Windows Server 2003

Standard R2 64-bit. This server is setup as a domain controller, and I

also have Microsoft Exchange Server 2007 running on this same server.

I recently attempted to install SQL Server 2005 Standard on the server.

The disks I have for SQL Server do not specifically say they are the

64-bit version. However during setup, it did say that it was installing

the 64-bit version of the components, with the exception of the

Reporting Services.

I received 1 error during setup which basically said that there was a

problem with Reporting Services registration because I have a 64-bit

version of ASP.NET, and that Reporting Services 32-bit version requires

the 32-bit version of ASP.NET. I have both .NET version 2 and 3

installed, both of which are 64-bit versions.

My question is, how can I install the 64-bit version of Reporting

Services? I am pretty sure the SQL Server 2005 disks I own have both 32

and 64-bit versions on the same disk (because I clearly saw it was

installing 64-bit versions of SQL components, with the exception of the

Reporting Services), although the label on the disks do not specifically

say 64-bit version.

I also realize there is a command that will allow me to run IIS in

32-bit emulation mode and hence allow me to install the 32-bit version

of Reporting Services. However, this mode will not work with Exchange

2007, so using this mode is not an option for me. I must be missing

something here. Any suggestions would be greatly appreciated. Thanks!

|||

Fayoub

I am not sure if the express edition works with sharepoint.

By default reports are automatically deployed to

http://localhost/reportserver$SQLExpress

For full instructions about setting the deployment server see this article

http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx

Perhaps you should look through the following couple of articles to see what the express edition can and can;t do:

http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

http://msdn2.microsoft.com/en-us/library/ms365166.aspx

hearsaym I'm afraid I can't help. Perhaps you should post the question i na new topic

Reporting Services

I was trying to install Reporting Services on Windows Server 2003. but
it seems to need Visual Studio .Net 2003 installed.

I just can't download .Net 2003 anywhere.is it any different than
Visual Studio .net?

is there another way to install Reporting Services for SQL Server 2000.

we cannot get Sql Server 2005 coz we have Great Plains 7.0 running on
our server and that 2005 is not supported yet(I would think)

thank you.You can install it without Visual Studio, you only need Visual Studio
if you want to author reports.|||oh really?

I thought you need Visual Studio .Net 2003 for the Report Designer
feature.

thanks.

WS

reporting services

I have a probleme with visual studio express edition 2005; I couldn't find the server report feature where can I put my reports.Also,many features dont work when I want create an application to access my reports creates whith reporting services.

what to do ?

I'm not sure whether the express edition comes with this, but you want to find a control in the toolbox called Report Viewer.|||Hi Fayoub

The first mistake I made when doing this was not having IIS installed on my local machine.
Have you got IIS installed?

Cheers
Mark
|||

hi,

first, thanks for your interest.

To answer your question I don't have installed IIS,but I have an Apache server

|||I'm afraid that reporting services needs IIS.
You should be able install this from your Win XP CD but based on my experiences you will then probably have to uninstall and reinstall SQl Server express (with advanced services to include reporting services)
|||ok,I heared about Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

do you think it could be helpful to deploy my reports.Otherwise,I will work on IIS

|||

I have a 64-bit server (Xeon Quad Core) running Windows Server 2003

Standard R2 64-bit. This server is setup as a domain controller, and I

also have Microsoft Exchange Server 2007 running on this same server.

I recently attempted to install SQL Server 2005 Standard on the server.

The disks I have for SQL Server do not specifically say they are the

64-bit version. However during setup, it did say that it was installing

the 64-bit version of the components, with the exception of the

Reporting Services.

I received 1 error during setup which basically said that there was a

problem with Reporting Services registration because I have a 64-bit

version of ASP.NET, and that Reporting Services 32-bit version requires

the 32-bit version of ASP.NET. I have both .NET version 2 and 3

installed, both of which are 64-bit versions.

My question is, how can I install the 64-bit version of Reporting

Services? I am pretty sure the SQL Server 2005 disks I own have both 32

and 64-bit versions on the same disk (because I clearly saw it was

installing 64-bit versions of SQL components, with the exception of the

Reporting Services), although the label on the disks do not specifically

say 64-bit version.

I also realize there is a command that will allow me to run IIS in

32-bit emulation mode and hence allow me to install the 32-bit version

of Reporting Services. However, this mode will not work with Exchange

2007, so using this mode is not an option for me. I must be missing

something here. Any suggestions would be greatly appreciated. Thanks!

|||

Fayoub

I am not sure if the express edition works with sharepoint.

By default reports are automatically deployed to

http://localhost/reportserver$SQLExpress

For full instructions about setting the deployment server see this article

http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx

Perhaps you should look through the following couple of articles to see what the express edition can and can;t do:

http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

http://msdn2.microsoft.com/en-us/library/ms365166.aspx

hearsaym I'm afraid I can't help. Perhaps you should post the question i na new topic

reporting services

I have a probleme with visual studio express edition 2005; I couldn't find the server report feature where can I put my reports.Also,many features dont work when I want create an application to access my reports creates whith reporting services.

what to do ?

I'm not sure whether the express edition comes with this, but you want to find a control in the toolbox called Report Viewer.|||Hi Fayoub

The first mistake I made when doing this was not having IIS installed on my local machine.
Have you got IIS installed?

Cheers
Mark
|||

hi,

first, thanks for your interest.

To answer your question I don't have installed IIS,but I have an Apache server

|||I'm afraid that reporting services needs IIS.
You should be able install this from your Win XP CD but based on my experiences you will then probably have to uninstall and reinstall SQl Server express (with advanced services to include reporting services)
|||ok,I heared about Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies

do you think it could be helpful to deploy my reports.Otherwise,I will work on IIS

|||

I have a 64-bit server (Xeon Quad Core) running Windows Server 2003

Standard R2 64-bit. This server is setup as a domain controller, and I

also have Microsoft Exchange Server 2007 running on this same server.

I recently attempted to install SQL Server 2005 Standard on the server.

The disks I have for SQL Server do not specifically say they are the

64-bit version. However during setup, it did say that it was installing

the 64-bit version of the components, with the exception of the

Reporting Services.

I received 1 error during setup which basically said that there was a

problem with Reporting Services registration because I have a 64-bit

version of ASP.NET, and that Reporting Services 32-bit version requires

the 32-bit version of ASP.NET. I have both .NET version 2 and 3

installed, both of which are 64-bit versions.

My question is, how can I install the 64-bit version of Reporting

Services? I am pretty sure the SQL Server 2005 disks I own have both 32

and 64-bit versions on the same disk (because I clearly saw it was

installing 64-bit versions of SQL components, with the exception of the

Reporting Services), although the label on the disks do not specifically

say 64-bit version.

I also realize there is a command that will allow me to run IIS in

32-bit emulation mode and hence allow me to install the 32-bit version

of Reporting Services. However, this mode will not work with Exchange

2007, so using this mode is not an option for me. I must be missing

something here. Any suggestions would be greatly appreciated. Thanks!

|||

Fayoub

I am not sure if the express edition works with sharepoint.

By default reports are automatically deployed to

http://localhost/reportserver$SQLExpress

For full instructions about setting the deployment server see this article

http://www.microsoft.com/technet/prodtechnol/sql/2005/usingssrswithsqlexpress.mspx

Perhaps you should look through the following couple of articles to see what the express edition can and can;t do:

http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

http://msdn2.microsoft.com/en-us/library/ms365166.aspx

hearsaym I'm afraid I can't help. Perhaps you should post the question i na new topic

reporting services

hi,

i have to do some reports of a database sql server 2000 with visual studio 20003 reporting services,

The question is:

as the possible Query are a lot, what is the criterion to adopt to choose the Query for populate the Reports?

Hi,

could you explain that abit in detail ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Dear ,

What is ur question btw.Pls get in detail?

regards

sufian

|||my boss told my to do some reports, but don't told what to put in reports, so what usually is reported in a report: eg. the most selled items, the less .... what|||You are kidding right ? Ask you boss What does he need the reports for ? ASking him will help you to meet his expectations.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Reporting Service 2000 + Visual Studio 2005??

Hi all,
I need to create some reports in my company and I have SQL Server 2000 and
Visual Studio 2005.
Well, to create reports I will use the tool Report Server from the SQL
Server 2000. When I try install RS I can't because I don't have the Visual
Studio 2003.
Can someone help me?
--RS 2000 requires some version of VS. Used to be the cheapest way was to by
VB.Net 2003 (about $100). I don't really know if that is available anymore.
RS 2005 ships with its own version of VS 2005 (or integrates with VS 2005 if
you have it). RS 2000 cannot use VS 2005 (RS 2000 is a 1.1 framework app).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"João Correia" <JooCorreia@.discussions.microsoft.com> wrote in message
news:C000D777-CF77-4CB0-BCE6-A0E684CE1E7F@.microsoft.com...
> Hi all,
> I need to create some reports in my company and I have SQL Server 2000 and
> Visual Studio 2005.
> Well, to create reports I will use the tool Report Server from the SQL
> Server 2000. When I try install RS I can't because I don't have the Visual
> Studio 2003.
> Can someone help me?
>
> --
>

Reporting Service , VS Studio .NET 2003, and Business Intelligence

Hi,
I have a question regarding the business intelligence projects.
I have installed VS Studio .NEt 2003 and SQL Server 2000 as well as
the Reporting Service.
However I can't find "Business Intelligence Projects" when I want to
create a new project from Visual Studio.
1. How do I add the "Business Intelligence Projects" to the new project list
so I can create a new report?
2. Do I need SharePoint Portal Server because I didn't install it?
Thanks a lot for the reply.2) You don't need SharePoint to develop and view Reporting Services reports.
1) Run the Reporting Services installation on your development machine, but
only choose Client tools. Make sure you choose Report Designer when
installing. This will add the things you need to your VS.NET. You will find
Business Intelligence Projects at the top of the list of Project Types when
you start a New Project.
Kaisa M. Lindahl
"EAA" <EAA@.discussions.microsoft.com> wrote in message
news:FCBBCF65-2B0C-4448-8A3F-5B2E58CBB5B8@.microsoft.com...
> Hi,
> I have a question regarding the business intelligence projects.
> I have installed VS Studio .NEt 2003 and SQL Server 2000 as well as
> the Reporting Service.
> However I can't find "Business Intelligence Projects" when I want to
> create a new project from Visual Studio.
> 1. How do I add the "Business Intelligence Projects" to the new project
> list
> so I can create a new report?
> 2. Do I need SharePoint Portal Server because I didn't install it?
> Thanks a lot for the reply.

Reporting Items Toolbox

I am new to reporting services. Just installed the BI Dev Studio onto my SQL 05 machine. Everything is working fine. I can via the wizard create a basic report that connect to a SQL data store, runs a query, renders etc.

My problem - the BI Studio will not give me anything active in the toolbox. If I pull up the toolbox it shows me the general tab and that's it. If I do a 'show all' on the toolbox it will show me all available tabs in VS...including the one I want 'Report Items'. However all controls in the Report Items (pointer, textbox, line, table, matrix, etc.) are grayed out. As far as I can tell this means I would have to directly change the RDL in order to customize my report. I feel like I am missing something basic here.

Thanks in advanced for any insight.

Basic to say the least...Took me a couple hours for me to decide I might need to look around and install additional components from the install disc...which made me decide to close my BI Studio....which promptly asked me if I wanted to stop debugging...which prompted me to scream.

Not sure how debug started running in the first place I would have never thought to run debug on RDL. Anyway lame post. Sorry.