Groups | Blog | Home
all groups > sql server reporting services > september 2005 >

sql server reporting services : Can I use Reporting Services within a C# windows application


rmstaylor
9/19/2005 3:29:03 PM
Can I use sql Server 2000 Reporting Services within a C# windows application
--
Bruce L-C [MVP]
9/19/2005 9:45:40 PM
You can either use webservices or you can embed an IE control and use URL
integration. With Visual Studio 2005 (released in November I believe) there
is both a winform and webform controls. They work with RS 2005 (released in
November). My suggestion is learn how to create the reports and get the
reports working and then use the new controls. Much easier than any other
way that is possible today.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Dennis P via SQLMonster.com
9/21/2005 12:00:00 AM
Hi Bruce,

Have you done anything with using the webservices to create a menu control to
display the reports and folders that the user has access to? I was building
several user controls for each group of users, but was wondering if I could
build one generic menu type control that would read the webservices results
and populate the control with the reports that the user has access to. One
control for all the users.
Do you have any thoughts on this? Can you point me in the right direction?

I appreciate any help or insight you can provide.
Dennis
dennisp@mayschem.com

[quoted text, click to view]


--
rmstaylor
9/21/2005 7:06:01 AM
Thanks Bruce,

But I'm not sure how to proceed. First of all I have a C# .net 2003 windows
application where I need to embed the report.

I have the report built in a separate project. I can preview the report
just fine. But when I want to Debug the report I get the following error
message:

No Report Server was found at http://mshqsql/reports

Can you explain why this occurs and what I need to do to get the report to
display?

I have never embedded an IE control or used URL integration. Can I do this
within a windows application and if so, how do I proceed or can you direct me
to a website so I can learn how to do this?
--
Thanks!
rmstaylor

[quoted text, click to view]
rmstaylor
9/21/2005 7:10:04 AM
I'm sorry I forgot to ask previously when I use an IE control and url
integration can I also print the report?
--
Thanks!


[quoted text, click to view]
Bruce L-C [MVP]
9/21/2005 9:18:14 AM
First off, RS 2000 requires a server. Reports have to be deployed to a
server. Until you get reports working it is a moot point to worry about
integrating it. You can build a report and preview it without the server.
You must have the server for anything to work in production. Do you have a
server installed? Have you deployed.

IE is componentized. There is a component for rendering, it has a property
where you set the URL. So, this is embedding an ocx in your C# application.
I have done this years ago with VB6 but not with dotnet. I suggest asking in
a dotnet newsgroup. First step would be to embed the control and then set
the URL to some website. Next you need to make sure you understand how to
create the URL. Test this outside your app by creating the url and just
pasting it into IE.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

rmstaylor
9/21/2005 9:37:04 AM
Yes RS has been load to a server. I can type
http://mshqsql/reports/Pages/Folder.aspx into a browser and view the Report
Manager. However, when I type this address into the projects
TargetServerURL, then run the application in Debug mode I get the following
error:

No Report Server was found at http://mshqsql/reports

I'm not the one who loaded RS onto the server, but since we can see it in a
browser I am making an assumption that it is loaded corrected. And that
possibly I am not doing something in the application to point to the server.

I do appreciate any help you can give.
--
Thanks!
rmstaylor


[quoted text, click to view]
Bruce L-C [MVP]
9/21/2005 9:46:43 AM
Nope, I use Report Manager. I would post a specific question about web
services separately.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce L-C [MVP]
9/21/2005 9:49:26 AM
The print icon on the toolbar of Report Manager is an ActiveX control. The
toolbar will not show only the report so you would have to have your own
print button, I believe it is possible to use the ActiveX control but I have
not done it.

Again, if you can get the OK to use VS 2005 (they have go-live licenses)
then this would be slam dunk easy with the new controls.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

Bruce L-C [MVP]
9/21/2005 12:25:11 PM
There are two websites. One is report manager (reports) and one is
reportserver. Report Manager is a portal into reportserver and uses
reportserver. Change your URL to:

http://mshqsql/ReportServer


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

rmstaylor
9/21/2005 1:49:01 PM
I changed the URL to the ReportServer however, I got the following error:

The permissions granted to user 'MSHQ\staylor' are insufficient for
performing this operation.

If I have permission to use mshq, then why am I gettng the error.
--
Thanks!


[quoted text, click to view]
Bruce L-C [MVP]
9/21/2005 8:17:08 PM
Report Server is an asp.net application. If you are in the local admin group
on the server then you will have the rights you need. Otherwise you need to
be added to the appropriate role. Read up on roles in the books on line.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button