Can I use Reporting Services within a C# windows application

Can I use sql Server 2000 Reporting Services within a C# windows application
--
Thanks!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
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> Can I use sql Server 2000 Reporting Services within a C# windows
> application
> --
> Thanks!|||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
"Bruce L-C [MVP]" wrote:
> 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
> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> > Can I use sql Server 2000 Reporting Services within a C# windows
> > application
> > --
> > Thanks!
>
>|||I'm sorry I forgot to ask previously when I use an IE control and url
integration can I also print the report?
--
Thanks!
"Bruce L-C [MVP]" wrote:
> 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
> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> > Can I use sql Server 2000 Reporting Services within a C# windows
> > application
> > --
> > Thanks!
>
>|||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
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
> 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
> "Bruce L-C [MVP]" wrote:
>> 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
>> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
>> > Can I use sql Server 2000 Reporting Services within a C# windows
>> > application
>> > --
>> > Thanks!
>>|||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
Bruce L-C [MVP] wrote:
>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.
>> Can I use sql Server 2000 Reporting Services within a C# windows
>> application
Message posted via http://www.sqlmonster.com|||Nope, I use Report Manager. I would post a specific question about web
services separately.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dennis P via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:54B323D205480@.SQLMonster.com...
> 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
> Bruce L-C [MVP] wrote:
>>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.
>> Can I use sql Server 2000 Reporting Services within a C# windows
>> application
>
> --
> Message posted via http://www.sqlmonster.com|||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
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:FC09F199-6153-48D9-856B-745121561E47@.microsoft.com...
> I'm sorry I forgot to ask previously when I use an IE control and url
> integration can I also print the report?
> --
> Thanks!
>
> "Bruce L-C [MVP]" wrote:
>> 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
>> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
>> > Can I use sql Server 2000 Reporting Services within a C# windows
>> > application
>> > --
>> > Thanks!
>>|||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
"Bruce L-C [MVP]" wrote:
> 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
> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
> > 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
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> 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
> >>
> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> >> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> >> > Can I use sql Server 2000 Reporting Services within a C# windows
> >> > application
> >> > --
> >> > Thanks!
> >>
> >>
> >>
>
>|||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
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:0C763DA5-23A1-4A1B-AAFA-7FEABC2018EA@.microsoft.com...
> 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
>
> "Bruce L-C [MVP]" wrote:
>> 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
>> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
>> > 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
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> 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
>> >>
>> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> >> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
>> >> > Can I use sql Server 2000 Reporting Services within a C# windows
>> >> > application
>> >> > --
>> >> > Thanks!
>> >>
>> >>
>> >>
>>|||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!
"Bruce L-C [MVP]" wrote:
> 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
> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> news:0C763DA5-23A1-4A1B-AAFA-7FEABC2018EA@.microsoft.com...
> > 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
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> 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
> >>
> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> >> news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
> >> > 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
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> 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
> >> >>
> >> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
> >> >> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
> >> >> > Can I use sql Server 2000 Reporting Services within a C# windows
> >> >> > application
> >> >> > --
> >> >> > Thanks!
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||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
"rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
news:83791D24-0A7E-4A73-856C-5C7FEEFDD8E2@.microsoft.com...
>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!
>
> "Bruce L-C [MVP]" wrote:
>> 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
>> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> news:0C763DA5-23A1-4A1B-AAFA-7FEABC2018EA@.microsoft.com...
>> > 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
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> 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
>> >>
>> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> >> news:DF5F50C0-3B16-46A9-A185-F47816681206@.microsoft.com...
>> >> > 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
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> 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
>> >> >>
>> >> >> "rmstaylor" <rmstaylor@.discussions.microsoft.com> wrote in message
>> >> >> news:C5313E1D-EA29-457B-88B6-3CD0EB622788@.microsoft.com...
>> >> >> > Can I use sql Server 2000 Reporting Services within a C# windows
>> >> >> > application
>> >> >> > --
>> >> >> > Thanks!
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>