Reporting service with sql server 2005

I am developing an application using Visual C# 2005 and SQL Server 2005. I would like to make report services from feature of SQL Server 2005. Can I make report from reporting service with SQL Server 2005? How to make the report service?

Best regards,
Simba

Hello,

You have to develop a report with the Bi dev Studio and deploy the report in your report server. After you can call Reporting Services web services inside your managed PS in SQL Server.

Best regards,

Alexis Molteni

|||

Thank you Alexis,

We are using Visual C# Express 2005 and MS SQL Server Express 2005. We are developing window based application and totally deploy the application on client machine. We would like to use SQL Reporting Service 2005 in the window application rather crystal report. At the moment we have SQL Server Express 2005 installed but there no way to get Reporting Service Designer.

Could you please let us know how to get the reporting service designer installed and how to deploy it with my window based application to client machine?

Best regards,
Simba

|||

We're working right now to release a new edition of SQL Server Express that includes Reporting Services. The version of SQL Server Express that is included with Visual Studio 2005 does not include the Reporting Services functionality. Expect the new edition to be available as a web download. Unfortunately, I don't know what the official timeline is for the new edition. I can tell you we're actively working on it :-). When it is available, it will have the capabilities mentioned here:

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

In the mean time - you can get a running start by using the dev edition of SQL Server 2005 and constraining yourself to use only the functionality that will be supported by the new edition.

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Then can I use crystal report to make a report and view it inside the visual C#? How to embed the crystal report to report viewer control in C# toolbox?

I am now design a report in crystal report XI and I don't how to intergrate the crystal report to work with visual C# express.

Or would you please recommend me whether there are any free report designer control or visual C# express extension to make report work the same crystal report...

Best regards,

|||

In Visual Studio 2005, Microsoft provides ReportViewer controls where you can embed a report in your managed application. The control is free of charge, distributable and has an integrated report designer. This control does not use Crystal. Rather it is built on SQL Server Reporting Services technology.

Note, you can embed a report in your application or show a report hosted on a Report Server in your application with these controls.

If you really want to use Crystal, you'll need to ask how to do that in the Crystal forum - this forum is all about SQL Server Reporting Services :-).

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

But I don't have visual studio 2005. I just have only Visual C# express 2005 stand alone and SQL Server express 2005. could you tell me more or point me to the right place where I can learn how to use Report viewer and report designer to manage my report on my window based application using Visual C# express 2005.

Thank you very much for your consideration

Best regards,

|||

The controls themselves are freely redistributable. You can download the controls here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=8a166cac-758d-45c8-b637-dd7726e61367&DisplayLang=en

But if I remember right, this package does not provide you the design surface. To get the design surface you will need to grab Visual Web Developer Express from the Microsoft download center and follow this link to get the add-in for the design surface:

http://download.microsoft.com/download/4/4/D/44DBDE61-B385-4FC2-A67D-48053B8F9FAD/SQLServer2005_ReportAddin.msi

Ok, this isn't an easy process, but it should get you up and running. You'll then be able to design reports and preview them in Visual Web Developer Express, and use those RDLC files (you'll know what I mean once you start playing with it) in the controls you instantiate programmatically in your C# express. For productivity's sake, you might want to invest in a full copy of C# standard edition if you can - it includes the design surface right there for you to use.

Also, you can find tons of information about the ReportViewer controls here:

http://www.gotreportviewer.com/

-Lukasz

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello,

I use Visual Studio 2005 and SQL Reporting Service 2005. My computer is windows 2003 Server. I have created one reporting service project.

In my project, I have two parameters namely @.startdate and @.enddate. I have one matrix. I want to format background row of the matrix to have different colors. I use the expression like IIF(RowNumber(Nothing) Mod 2,"Grey","White"), but when i view it shows errors like:

the backgroundcolor expression for the textbox 'Revenue' has a scope parameter that is not valid for RunningValue, RowNumber or Previous. The scope parameter must be set to a string constant that is equal to the name of a containing group within the matrix. The textbox 'Revenue' is the results from data set when i specify @.startdate and @.enddate when i preview the report.

Thanks in advance for your help

Best Regard,

Chear