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 2000, VS2005 and SQL Server 2000

I am running MS SQL 2000 and VS .Net 2005.

Is it possible to run Microsoft Reporting Services 2000 with VS2005 or am I required to upgrade the SQL server and reporting services to 2005 just to produce a few WEB reports ? This would be too costly both in money and time.

I have just finished developing a solution using the version of Crystal Reports which is built into VS 2005. However I now believe that I require costly licenses to deploy the solution on the live WEB server. Can anyone confirm this assumption (in simple terms).

There really does to be a lack of a descent, reasonable cost, solution for generating WEB reports against an MS SQL 2000 database whilst using the VS 2005 development environment. Maybe I am wrong ?

Any suggestions would be appreciated.

Cheers

George

Please help ...

In simple terms, I have VS2005 and am limited to MSSQL 2000 and want to generate some WEB reports. Can I use Reporting Services 2000 services to do this ?

Upgrading to SQL 2005 is NOT an option and I have a large WEB project built using VS2005 (VB).

This now all seems to be so difficult. Any help would be appreciated.

Cheers

George

Reporting Service 2000 and VS2005

Dear all:

Can I design report using VS2005 and deploy them on Reporting service 2000?

Thanks.

Reports designed with BI Development Studio (Report Designer integrated into VS 2005), can only be directly published to a RS 2005 report server because RS 2005 has additional features (e.g. interactive sort) which required incremental changes and an update in the Report Definition Language (RDL) schema namespace.

However, in many cases you can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

-- Robert

|||Thank you very much Robert! This is just what I needed.|||

I have several RS 2005 reports that I've converted as you suggested to use on SQL Server 2000. Everything was working fine, until now. I am having trouble printing reports. I don't know if this has to do with the conversion. I have the same report on my localhost but I'm running SQL 2005 and I have no problem printing this report. When I convert it and run it on SQL 2000 on another machine the empty reports print, but the ones with data get locked up and I can't even view the print preview. Any suggestions would be most appreciated.

Thanks, Janey

Reporting Service 2000 and VS2005

Dear all:

Can I design report using VS2005 and deploy them on Reporting service 2000?

Thanks.

Reports designed with BI Development Studio (Report Designer integrated into VS 2005), can only be directly published to a RS 2005 report server because RS 2005 has additional features (e.g. interactive sort) which required incremental changes and an update in the Report Definition Language (RDL) schema namespace.

However, in many cases you can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

-- Robert

|||Thank you very much Robert! This is just what I needed.|||

I have several RS 2005 reports that I've converted as you suggested to use on SQL Server 2000. Everything was working fine, until now. I am having trouble printing reports. I don't know if this has to do with the conversion. I have the same report on my localhost but I'm running SQL 2005 and I have no problem printing this report. When I convert it and run it on SQL 2000 on another machine the empty reports print, but the ones with data get locked up and I can't even view the print preview. Any suggestions would be most appreciated.

Thanks, Janey

Reporting Server Project 2005 - xml datasource - Querying the data

The way I create the report is I use VS2005 to create the RDL programmatically on the fly. The problem is querying the data when I use XML as a data source (changing the data source is not an option).

I can connect to the XML data source, I enter a basic query in the data tab in VS 2005 and what happens is for some reason or another the above element in XML gets concatenated onto the column name in the result set.

So what I have to do is manually modify the RDL file to accept the new names and then the report works. There has to be a way to not have this happens. Any advice on where I can find information on how to do this would be greatly appreciated. Examples are always welcome.

See below for an example of what I did and an example of the XML data.

XML File Example:
<data>
<Table>
<iss_id>Test Data1</issu_id>
<issue_nm>Test Data1</issue_nm>
</Table>
<Table>
<iss_id>Test Data2</issu_id>
<issue_nm>Test Data2</issue_nm>
</Table>
<data>

XML Query: (I enter this in the data tab in VS 2005)
data/Table

Result:

Table_iss_id Table_issue_nm <--Column Headers
Test Data1 Test Data1
Test Data2 Test Data2

I think it has to do with the webservice web method, and how it needs to be set-up for serializing the parameters correctly to work with the XML data Source. I am having a similar problem which I am documenting here

http://forums.microsoft.com/MSDN/User/MyForums.aspx?SiteID=1

J. C.