ReportViewer (.NET 1.1) can't pass in the parameter...sometimes!

Here's my problem:
I have 4 web sites in 4 environments. Let's call them A, B, C, and D.
Reporting Server is installed on A, and on another server, let us
called it Z.
There are 4 website, also installed on A, B, C, and D.
When I run the website on my localhost machine, all my paramters are
passed fine and rendered.
When I access the web site in environment A, and it talks to the web
service of Reporting Server on A, everything is good.
However, B, C do not pass their parameters?! As for D, it has to talk
to another reporting server which is installed on Z. It also doesn't
render the parameters.
In all the cases where it doesn't work, the default values of the
parameters are always used. I found that in the MSSQL directories of
the Reporting Server on A, I replaced the ReportViewer.dll with the
same copy as the one in the website on A, and that got it working. The
DLLs had different version numbers, and one was in debug mode (in the
C:\program files\*) and the one in the website was in release mode.
It's got to to be something silly that I've missed here. Please help!!Ok, so I've found out some more information.
If I build my project and set debug="true" in web.config. It works in
any server. If I set debug="false", it doesn't work. The parameters
can be drop down lists or a custom user control. All are created
dynamically. The drop down lists work in any case (debug="true" or
debug="false") but my user control which is a date picker (really just
a textbox beside a link that pops up a calendar and writes it back into
the textbox) doesn't work?!?|||I found the solution. It has nothing to do with Reporting Services.
I posted it in the ASP.NET forum here:
http://groups.google.ca/group/microsoft.public.dotnet.framework.aspnet/browse_thread/thread/af07718b43e863da/d4f0d1789b895593?hl=en#d4f0d1789b895593
Depending on whether you set debug="true" or debug="false", the name of
a user control can have an underscore or not!

ReportServerDatabaseUnavailableException error, not using Report Service in current projec

I just installed Report Services, and now, in a project I've beenworking on for months, I'm getting the following exception, and I'm noteven using Report Services in the project, and don't have a referenceset to it or anything!?!?
Has anyone seen this behavior before? How do I stop it? I don't wantReport Services running all the time on my poor lil' laptop, given thatI don't need it right now.
Exception details:
An unhandled exception of type'Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException'occurred in microsoft.reportingservices.diagnostics.dll
Additional information: The report server cannot open a connection tothe report server database. A connection to the database is requiredfor all requests and processing.

Thanks,
Sam
Which version of .NET Framework, SQL Server and Reporting Services are you using?
Also, I'm not sure if this will fix your particular problem but since you haven't created any reports it is safe to do:
Open a command prompt at this location "C:\Program Files\Microsoft SQL Server\80\Tools\Binn" (replace 80 with 90 for SQL 2005)
run the following: RSKeyMgmt.exe -d

Reportserver virtual directory

On my web hosting server the inetpub/wwwroot folder is located on D: drive, and the web hosting company configured it that way.

When i have installed the sql server 2005 it created the virtual directory under c:\inetpub\wwwroot which is not a default website location on that server.

could you please tell me how to switch the virtual directory path from c:\inetpub\wwwroot

to

d:\inetpub\wwwroot

Please any help would be greatly appreciated.

Thank you very much.

I'm not quite sure how you mean. When RS installs it doesn't place any files in c:\inetpub\wwwroot. The standard location will be

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Note that the drive letter and the number after the MSSQL. part may vary depending on the choices made during setup and the SQL Server components selected.

The using the configuration tool, it creates 2 virtual directories beneath the default website i.e. the one on port 80 called "reportserver" and "reports" and these are just pointers to the physical directories located int he above install path.

Please can you clarify the issue you seem to be having?

reportserver url - get Directory Listing Denied

I have two servers, basically identical on which reporting services is installed.

On one when i go to the /reportserver url i get to a listing of report directories/reports o the server.

On the 2nd, I get the IIS error:

Directory Listing Denied

I've checked and all of the settings i can verify (in report server, Iis etc.) are identical on both.

What might cause this?

thx.

r-

The reportserver virtual root should be configured to map all extensions to aspnet_isapi.dll. It sounds like this is not the case. If you are using Report Server 2005, you might want to recreate the virtual root using the Report Server Config Tool.

ReportServer Site error

Hi, i installed SQL Server with Reporting Services... when i try to access the ReportServer website i get this error. Can someone help me?

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.

Source Error:

[No relevant source lines]

Source File: c:\inetpub\wwwroot\web.config Line: 0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

If you see, it says that the source file is "c:\inetpub\wwwroot\web.config" but my ReportServer document root is in other place, i've tried coping the web.config file to wwwroot, but nothing.

I guess you need to add permissions to your root folder which is wwwroot. Right click on the folder and in the Security tab, add MachineName\ASPNET user to the list and give all permission to that user.

Shyam

|||i've done what you sayed, but everything stayed the same... The report server service is runing under Local System account, also gave it permission but still nothing happend... i really need help since i've to install Microsoft CRM and it needs a running Report Server|||

I guess this link will be helpful for you:

http://blog.devstone.com/Aaron/archive/2004/12/03/359.aspx

Shyam

|||did that with some differences since i'm at a domain controller... nothing happened... thanks for the fast answer...|||So, is your problem solved? Can the post be marked as answer?|||i still have the same problem.... i followed the page you posted me but nothing happened...|||

Then try the last resort, which is to restart the machine. I'm sorry for this cliche in the Microsoft community.

Shyam

|||sorry, i've tried, and sorry if i wait 'till the mornings to answer, but the only time i've got to try to fix this problem is at nights when there aren't users, thanks for all your help but, the problem is still there sql

ReportServer Site error

Hi, i installed SQL Server with Reporting Services... when i try to access the ReportServer website i get this error. Can someone help me?

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.

Source Error:

[No relevant source lines]

Source File: c:\inetpub\wwwroot\web.config Line: 0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

If you see, it says that the source file is "c:\inetpub\wwwroot\web.config" but my ReportServer document root is in other place, i've tried coping the web.config file to wwwroot, but nothing.

I guess you need to add permissions to your root folder which is wwwroot. Right click on the folder and in the Security tab, add MachineName\ASPNET user to the list and give all permission to that user.

Shyam

|||i've done what you sayed, but everything stayed the same... The report server service is runing under Local System account, also gave it permission but still nothing happend... i really need help since i've to install Microsoft CRM and it needs a running Report Server|||

I guess this link will be helpful for you:

http://blog.devstone.com/Aaron/archive/2004/12/03/359.aspx

Shyam

|||did that with some differences since i'm at a domain controller... nothing happened... thanks for the fast answer...|||So, is your problem solved? Can the post be marked as answer?|||i still have the same problem.... i followed the page you posted me but nothing happened...|||

Then try the last resort, which is to restart the machine. I'm sorry for this cliche in the Microsoft community.

Shyam

|||sorry, i've tried, and sorry if i wait 'till the mornings to answer, but the only time i've got to try to fix this problem is at nights when there aren't users, thanks for all your help but, the problem is still there

ReportServer DB blocking !

Hi There

I have installed Reporting Services 2005 on a server, this uses a remote ReportServer Database on a Sql Server 2000 instance.

Everything has been working fine until a few days ago, i am picking up long blocking in the 2005 ReportServer database.

Up to 3-4 minutes.

The blocking is occuring on table locks on the "Keys" and "SnapshotData" tables in the report server database.

Now as a dba all i can see is the 2 spid's that are involved in the blocking, the spid that is blocking is at the time not doing anything, it is waititng while holding these locks.

I have a feeling this is due to long running reports, but iam not so sure because long running reports are a fact of life , i do not see how they should block other report user on ReportServer system tables ?

However how do i troubleshoot this? I dont know how to link these spids in sql server to reports being run , or to prove or disprove that his is due to long running reports ?

In other words how do i trouble shoot blocking in the reportserver database ?

Thanx

I've experienced the same problem. I contacted microsoft support regarding the issue, but they haven't found the solution.|||

Hi

Please keep me updated if you receive any feedback, i was going to open a case myself.

Thank You

ReportServer Configuration

We have report server installed for intranet use only. We are using actice directory users for role assignments.

New requirement is to allow access to reports via internet (www.xyz.com) and we are not going to use Microsoft Active Directory Users Account.

What would we need to do to accomplish the above? What additional steps would you recommend?

Thanks

Did you check Tudor's blog article (http://blogs.msdn.com/tudortr/archive/2005/11/03/488731.aspx) and its MSDN links?

-- Robert

|||

Is there any BLOG for SQL Server 2000? If we install Report Manager facing internet then should we must do forms authentication? or is there any alternative to this?

Thanks,

ReportServer as a separate component

Can the ReportServer web services application be installed without installing SQL Server?

Let me explain a little further what I'm trying to do and if I need to take a different path, I'm open to suggestions.

I am going to be using XML files for data input and RDL files to describe the reports themselves. That being said, I am not in need of a database of any kind (and don't want to be required to use one), but I want to take advantage of Microsoft's rendering capabilities. I have looked into the ReportViewer control, but that control doesn't support all of the rendering extensions that ReportServer does (mostly HTML). I know that ReportServer stores its metadata in a database on the local SQL Server, but I didn't know if there was maybe a standalone installation that I could get my hands on that exposed the SOAP API, but didn't require an SQL Server (or any other database for that matter) for it to exist.

Thanks,
Ken

In order to run the Report Server, you do need a SQL Server database engine to be deployed somewhere on your network - not strictly on the local computer.

To get all the rendering capabilities of the report server, you will need to deploy a report server.

If you don't want to use a report server at all, then the ReportViewer control that ships with Visual Studio 2005 is your best bet.

If you don't want to deploy a report server for every instance of your application, you might choose to use a remote report server. In SQL Server 2005, reporting services provides a method for loading a report on the server without saving it in the report server namespace. To do this you use the LoadReportDefinition SOAP API. You'll also need to add any users of your applications to the System User role on the report server, at the system scope (Site Settings in Report Manager, then edit site wide security settings). Your application would then use the LoadReportDefinition method and privision any information needed through the report server execution SOAP endpoint.

Otherwise, you're stuck iinstalling a report server and then choosing either to have a local sql server relational database or a remote one.

-Lukasz

Reports won't attach in subscription email after sp2 installation

Hello,
I installed SP2 on one of the 2 reporting servers we have in our
environment. Before the SP installation, Subscriptions were able to send the
attached reports. Now the job reports an error. I set up the same
subscription and reports to the server not running SP2 (with identical
settings) and the report worked fine.
If I choose to send only a link, then it works. However, any time I try to
add an attachement, I get errors. Any Ideas? There are no specific errors
in the reportserver logs...
Please help!Do you have some Date fields in report ?
Or do you have changed the Default language for report ?
"MustangDJB" <MustangDJB@.discussions.microsoft.com> a scris în mesajul de
ºtiri:51A3960E-4E6E-4FBE-870E-A59ADEBDE85C@.microsoft.com...
> Hello,
> I installed SP2 on one of the 2 reporting servers we have in our
> environment. Before the SP installation, Subscriptions were able to send
> the
> attached reports. Now the job reports an error. I set up the same
> subscription and reports to the server not running SP2 (with identical
> settings) and the report worked fine.
> If I choose to send only a link, then it works. However, any time I try
> to
> add an attachement, I get errors. Any Ideas? There are no specific
> errors
> in the reportserver logs...
> Please help!|||The language was not changed and there are no date fields in the report.
thanks!
"spp" wrote:
> Do you have some Date fields in report ?
> Or do you have changed the Default language for report ?
> "MustangDJB" <MustangDJB@.discussions.microsoft.com> a scris în mesajul de
> ºtiri:51A3960E-4E6E-4FBE-870E-A59ADEBDE85C@.microsoft.com...
> > Hello,
> > I installed SP2 on one of the 2 reporting servers we have in our
> > environment. Before the SP installation, Subscriptions were able to send
> > the
> > attached reports. Now the job reports an error. I set up the same
> > subscription and reports to the server not running SP2 (with identical
> > settings) and the report worked fine.
> >
> > If I choose to send only a link, then it works. However, any time I try
> > to
> > add an attachement, I get errors. Any Ideas? There are no specific
> > errors
> > in the reportserver logs...
> > Please help!
>
>|||The problem was resolved by installing the latest service pack for windows
2003. No changes were required to the report services server.
FYI
"MustangDJB" wrote:
> The language was not changed and there are no date fields in the report.
> thanks!
> "spp" wrote:
> > Do you have some Date fields in report ?
> > Or do you have changed the Default language for report ?
> > "MustangDJB" <MustangDJB@.discussions.microsoft.com> a scris în mesajul de
> > ºtiri:51A3960E-4E6E-4FBE-870E-A59ADEBDE85C@.microsoft.com...
> > > Hello,
> > > I installed SP2 on one of the 2 reporting servers we have in our
> > > environment. Before the SP installation, Subscriptions were able to send
> > > the
> > > attached reports. Now the job reports an error. I set up the same
> > > subscription and reports to the server not running SP2 (with identical
> > > settings) and the report worked fine.
> > >
> > > If I choose to send only a link, then it works. However, any time I try
> > > to
> > > add an attachement, I get errors. Any Ideas? There are no specific
> > > errors
> > > in the reportserver logs...
> > > Please help!
> >
> >
> >

Reports Services will not work with SharePoint 2003 and SQL Server 2005

We have installed SharePoint Portal Server 2003 (it is working correctly) and SQL Server 2005 (it is working correctly) on a single virtual machine.

If I enter "http://ComputerName/reports" to display the Report Manager we get the following error:

(yes, I did put in our computer name in the appropriate location)

Parser Error Message: An error occured loading a configuration file: Access to the path 'c:\inetpub\www\root\web.config' is denied.

Is this a permissions issue, a configuration issue, or something else?

Any suggestions for resolving this would be appreciated.

We have found the cause for this. It was a corrupted installation.

Reports Services will not work with SharePoint 2003 and SQL Server 2005

We have installed SharePoint Portal Server 2003 (it is working correctly) and SQL Server 2005 (it is working correctly) on a single virtual machine.

If I enter "http://ComputerName/reports" to display the Report Manager we get the following error:

(yes, I did put in our computer name in the appropriate location)

Parser Error Message: An error occured loading a configuration file: Access to the path 'c:\inetpub\www\root\web.config' is denied.

Is this a permissions issue, a configuration issue, or something else?

Any suggestions for resolving this would be appreciated.

We have found the cause for this. It was a corrupted installation.

Reports Manager does not list or manage reports...

I recently installed RS and have deployed several reports but none show up under the reports manager. Only the top toolbar folder shows home.
Setup:
ReportServer: local administrator
ReportServer Database: SQL User auth.
Windows 2003
SQL 2000
Any Ideas?Sounds like you are accessing the server with an account that does not have
permissions. Did you assign any security roles?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jhines" <jhines@.discussions.microsoft.com> wrote in message
news:991D3C55-3022-4F3C-B7A8-2395D243ADDC@.microsoft.com...
>I recently installed RS and have deployed several reports but none show up
>under the reports manager. Only the top toolbar folder shows home.
> Setup:
> ReportServer: local administrator
> ReportServer Database: SQL User auth.
> Windows 2003
> SQL 2000
> Any Ideas?|||Permissions?
"jhines" <jhines@.discussions.microsoft.com> wrote in message
news:991D3C55-3022-4F3C-B7A8-2395D243ADDC@.microsoft.com...
> I recently installed RS and have deployed several reports but none show up
under the reports manager. Only the top toolbar folder shows home.
> Setup:
> ReportServer: local administrator
> ReportServer Database: SQL User auth.
> Windows 2003
> SQL 2000
> Any Ideas?

Reports Manager 400 Bad Request

Here is the problem I am having. I have 2 instances of SQL Server setup on
one machine. Both with Reporting Services installed. I am running SQL
Server 2005 build 2153 for both, on Windows Server 2003 Enterprise. I have
IIS setup correctly. I went through and configured each so that everything
has a green checkmark next to it, with the exception of encryption. Now
everytime I try to bring up the reports either locally or remotely. It
brings up the page and with a 400 error. I have tried the following
server2/reports(instancename), server2.mastro.local/reports(instancename),
and 192.168.0.2/reports(instancename). Does anyone know how to get rid of
this 400 error?
Michael R. Mastro IIGot it fixed.
"Michael Mastro" <MikeRM2XXX@.worldnet.att.net> wrote in message
news:e9YR1RRUHHA.1364@.TK2MSFTNGP06.phx.gbl...
> Here is the problem I am having. I have 2 instances of SQL Server setup
> on one machine. Both with Reporting Services installed. I am running SQL
> Server 2005 build 2153 for both, on Windows Server 2003 Enterprise. I
> have IIS setup correctly. I went through and configured each so that
> everything has a green checkmark next to it, with the exception of
> encryption. Now everytime I try to bring up the reports either locally or
> remotely. It brings up the page and with a 400 error. I have tried the
> following server2/reports(instancename),
> server2.mastro.local/reports(instancename), and
> 192.168.0.2/reports(instancename). Does anyone know how to get rid of
> this 400 error?
> Michael R. Mastro II
>

Reports Depoyment Problem

I have a shared datasource already installed on the ReportServer.
Later I want to deploy reports that use that datasource.
The reports are created with a shared datasource which is not the same as
the one deployed.
How can I specify the datasource programatically when I am deploying the
reports?I think a better way is to have them use the same datasource name. When you
deploy the datasource it is not overwritten. So the datasource can point to
a development database or QA database or Production database (assuming you
have three different servers) and they can all be called the same thing. You
can modify the datasource after deployment to where you want it to go. From
then on it will not be overwritten during deployment unless you explicitly
tell it to be overwritten.
Bruce L-C
"CalinV" <CalinV@.discussions.microsoft.com> wrote in message
news:D912BB4E-C3D4-4A78-883C-06DAC33A8BD6@.microsoft.com...
> I have a shared datasource already installed on the ReportServer.
> Later I want to deploy reports that use that datasource.
> The reports are created with a shared datasource which is not the same as
> the one deployed.
> How can I specify the datasource programatically when I am deploying the
> reports?
>|||Take a look at the SetReportDataSources [1] SOAP API method.
[1]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_ref_soapapi_service_lz_3x88.asp
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"CalinV" <CalinV@.discussions.microsoft.com> wrote in message
news:D912BB4E-C3D4-4A78-883C-06DAC33A8BD6@.microsoft.com...
> I have a shared datasource already installed on the ReportServer.
> Later I want to deploy reports that use that datasource.
> The reports are created with a shared datasource which is not the same as
> the one deployed.
> How can I specify the datasource programatically when I am deploying the
> reports?
>

Reporting-Server URL

Hi,
Where do I find the Reporting-Server URL?
I installed SQL 2005 as a standard-instance. The only changes during
installation where: Database-File folder, Analysis-Services Database folder.
I didn't touched any settings of the reporting part.
Thanks for your answer.
regards
PatrickJust type http://localhost/Reports on your browser, it will show up if
everything was installed correctly.
Sum.
"Patrick D." wrote:
> Hi,
> Where do I find the Reporting-Server URL?
> I installed SQL 2005 as a standard-instance. The only changes during
> installation where: Database-File folder, Analysis-Services Database folder.
> I didn't touched any settings of the reporting part.
> Thanks for your answer.
> regards
> Patrick|||You could also just access the report by going to
http://localhost/ReportServer.
You also can check the URL from the IIS where the reporting server is
installed.
Lucas
"Sum12341" wrote:
> Just type http://localhost/Reports on your browser, it will show up if
> everything was installed correctly.
> Sum.
> "Patrick D." wrote:
> > Hi,
> >
> > Where do I find the Reporting-Server URL?
> >
> > I installed SQL 2005 as a standard-instance. The only changes during
> > installation where: Database-File folder, Analysis-Services Database folder.
> >
> > I didn't touched any settings of the reporting part.
> >
> > Thanks for your answer.
> >
> > regards
> > Patrick

Reporting SVCS Installed?

I have DevStudio 2003, SQL Server 2000 (developer edition). I'd like to
switch from Crystal Reports 8.5 to MS Reporting Services. How can I upgrade
my SQL Server 2000 with this new reporting service/module? NOTE: I
purchased my SQL license in 2002.
There are no downloads in MSDN (except for an evaluation install), and no
options to upgrade to the latest version that includes the reprting service.
Also, where (on the Net) do I go to install the .Net components for
integration with the reporting service?There is a how to get RS info up on the RS website. Normally, it depends on
how you bought SQL Server. Most likely, you'll need to call your reseller
and get the RS CD from them.
Tom
"Billg_sd" <Billgsd@.discussions.microsoft.com> wrote in message
news:85432424-5394-42BE-BC39-3071F0C951EB@.microsoft.com...
>I have DevStudio 2003, SQL Server 2000 (developer edition). I'd like to
> switch from Crystal Reports 8.5 to MS Reporting Services. How can I
> upgrade
> my SQL Server 2000 with this new reporting service/module? NOTE: I
> purchased my SQL license in 2002.
> There are no downloads in MSDN (except for an evaluation install), and no
> options to upgrade to the latest version that includes the reprting
> service.
> Also, where (on the Net) do I go to install the .Net components for
> integration with the reporting service?
>

Reporting Svcs 2000 and Visual Studio 2005?

Hi,
I'm a newbie to Reporting Svcs.
My PC has VStudio 2003 and VStudio 2005.
I installed Rep Svcs 2000 and created a report with it from VStudio 2003.
From VStudio 2005 there's no access to create projects of type Report.
The windows end-user application project that needs to display the reports
is in VStudio 2005, but from VStudio 2005 I don't see the option to create
reports with Rep Svcs 2000.
I need to be able to design reports in Rep Svcs 2000 and be able to access
them from this win application project that is in VStudio 2005. Is this
possible? How can I do that?
Thank you in advance,
RichardRS 2000 is a framework 1.1 asp.net application. RS 2005 is a 2.0 framework
asp.net application. There are two ways to integrate a 2.0 app with (whether
winforms or webforms) you can use web services (which requires a good bit of
work on your part for winforms) or you can use URL integration. Just embed
an IE control on your winform and use URL integration. Pretty straight
forward as long as you are doing an intranet app.
VS 2005 comes with new winform and webform controls. These can be used in
either local mode (all rendering is local, no server is involved) or server
mode. Either way, the new controls only work with RS 2005 reports.
Note that you can (if you have a license) install RS 2005 to use SQL Server
2000 as its metadata/object store.
I highly recommend going to RS 2005. It has a lot of new, really useful
features (better performance, multi-select parameters, end user sorting,
etc).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:FC440BC3-BF2F-430E-A5CB-9929322F7EE7@.microsoft.com...
> Hi,
> I'm a newbie to Reporting Svcs.
> My PC has VStudio 2003 and VStudio 2005.
> I installed Rep Svcs 2000 and created a report with it from VStudio 2003.
> From VStudio 2005 there's no access to create projects of type Report.
> The windows end-user application project that needs to display the reports
> is in VStudio 2005, but from VStudio 2005 I don't see the option to create
> reports with Rep Svcs 2000.
> I need to be able to design reports in Rep Svcs 2000 and be able to access
> them from this win application project that is in VStudio 2005. Is this
> possible? How can I do that?
> Thank you in advance,
> Richard|||Thank you, Bruce. Then is it possible to design the report using Rpt Scvs
2000, and have the WinForm application in .Net 2.0 invoke/render/display this
report? How would you suggest this could be done?
Thank you in advance,
Richard
===
"Bruce L-C [MVP]" wrote:
> RS 2000 is a framework 1.1 asp.net application. RS 2005 is a 2.0 framework
> asp.net application. There are two ways to integrate a 2.0 app with (whether
> winforms or webforms) you can use web services (which requires a good bit of
> work on your part for winforms) or you can use URL integration. Just embed
> an IE control on your winform and use URL integration. Pretty straight
> forward as long as you are doing an intranet app.
> VS 2005 comes with new winform and webform controls. These can be used in
> either local mode (all rendering is local, no server is involved) or server
> mode. Either way, the new controls only work with RS 2005 reports.
> Note that you can (if you have a license) install RS 2005 to use SQL Server
> 2000 as its metadata/object store.
> I highly recommend going to RS 2005. It has a lot of new, really useful
> features (better performance, multi-select parameters, end user sorting,
> etc).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:FC440BC3-BF2F-430E-A5CB-9929322F7EE7@.microsoft.com...
> > Hi,
> >
> > I'm a newbie to Reporting Svcs.
> > My PC has VStudio 2003 and VStudio 2005.
> > I installed Rep Svcs 2000 and created a report with it from VStudio 2003.
> > From VStudio 2005 there's no access to create projects of type Report.
> >
> > The windows end-user application project that needs to display the reports
> > is in VStudio 2005, but from VStudio 2005 I don't see the option to create
> > reports with Rep Svcs 2000.
> >
> > I need to be able to design reports in Rep Svcs 2000 and be able to access
> > them from this win application project that is in VStudio 2005. Is this
> > possible? How can I do that?
> >
> > Thank you in advance,
> >
> > Richard
>
>|||Webservices: render to PDF or HTML and give it to something to display.
URL integration. Assemble a string passing in parameters via URL. Use the IE
control in a Winform and set its URL to the string.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Richard" <Richard@.discussions.microsoft.com> wrote in message
news:E95F77EE-9D60-4863-8D68-E6B2CEEA79C6@.microsoft.com...
> Thank you, Bruce. Then is it possible to design the report using Rpt Scvs
> 2000, and have the WinForm application in .Net 2.0 invoke/render/display
> this
> report? How would you suggest this could be done?
> Thank you in advance,
> Richard
> ===> "Bruce L-C [MVP]" wrote:
>> RS 2000 is a framework 1.1 asp.net application. RS 2005 is a 2.0
>> framework
>> asp.net application. There are two ways to integrate a 2.0 app with
>> (whether
>> winforms or webforms) you can use web services (which requires a good bit
>> of
>> work on your part for winforms) or you can use URL integration. Just
>> embed
>> an IE control on your winform and use URL integration. Pretty straight
>> forward as long as you are doing an intranet app.
>> VS 2005 comes with new winform and webform controls. These can be used in
>> either local mode (all rendering is local, no server is involved) or
>> server
>> mode. Either way, the new controls only work with RS 2005 reports.
>> Note that you can (if you have a license) install RS 2005 to use SQL
>> Server
>> 2000 as its metadata/object store.
>> I highly recommend going to RS 2005. It has a lot of new, really useful
>> features (better performance, multi-select parameters, end user sorting,
>> etc).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Richard" <Richard@.discussions.microsoft.com> wrote in message
>> news:FC440BC3-BF2F-430E-A5CB-9929322F7EE7@.microsoft.com...
>> > Hi,
>> >
>> > I'm a newbie to Reporting Svcs.
>> > My PC has VStudio 2003 and VStudio 2005.
>> > I installed Rep Svcs 2000 and created a report with it from VStudio
>> > 2003.
>> > From VStudio 2005 there's no access to create projects of type Report.
>> >
>> > The windows end-user application project that needs to display the
>> > reports
>> > is in VStudio 2005, but from VStudio 2005 I don't see the option to
>> > create
>> > reports with Rep Svcs 2000.
>> >
>> > I need to be able to design reports in Rep Svcs 2000 and be able to
>> > access
>> > them from this win application project that is in VStudio 2005. Is this
>> > possible? How can I do that?
>> >
>> > Thank you in advance,
>> >
>> > Richard
>>|||Thank you. The current implementation uses Crystal Reports Viewer on a
WinForm, so the use of an IE control on a WinForm will be the easiest to
implement.
Sincerely,
Richard
==="Bruce L-C [MVP]" wrote:
> Webservices: render to PDF or HTML and give it to something to display.
> URL integration. Assemble a string passing in parameters via URL. Use the IE
> control in a Winform and set its URL to the string.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> news:E95F77EE-9D60-4863-8D68-E6B2CEEA79C6@.microsoft.com...
> > Thank you, Bruce. Then is it possible to design the report using Rpt Scvs
> > 2000, and have the WinForm application in .Net 2.0 invoke/render/display
> > this
> > report? How would you suggest this could be done?
> >
> > Thank you in advance,
> >
> > Richard
> > ===> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> RS 2000 is a framework 1.1 asp.net application. RS 2005 is a 2.0
> >> framework
> >> asp.net application. There are two ways to integrate a 2.0 app with
> >> (whether
> >> winforms or webforms) you can use web services (which requires a good bit
> >> of
> >> work on your part for winforms) or you can use URL integration. Just
> >> embed
> >> an IE control on your winform and use URL integration. Pretty straight
> >> forward as long as you are doing an intranet app.
> >>
> >> VS 2005 comes with new winform and webform controls. These can be used in
> >> either local mode (all rendering is local, no server is involved) or
> >> server
> >> mode. Either way, the new controls only work with RS 2005 reports.
> >>
> >> Note that you can (if you have a license) install RS 2005 to use SQL
> >> Server
> >> 2000 as its metadata/object store.
> >>
> >> I highly recommend going to RS 2005. It has a lot of new, really useful
> >> features (better performance, multi-select parameters, end user sorting,
> >> etc).
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Richard" <Richard@.discussions.microsoft.com> wrote in message
> >> news:FC440BC3-BF2F-430E-A5CB-9929322F7EE7@.microsoft.com...
> >> > Hi,
> >> >
> >> > I'm a newbie to Reporting Svcs.
> >> > My PC has VStudio 2003 and VStudio 2005.
> >> > I installed Rep Svcs 2000 and created a report with it from VStudio
> >> > 2003.
> >> > From VStudio 2005 there's no access to create projects of type Report.
> >> >
> >> > The windows end-user application project that needs to display the
> >> > reports
> >> > is in VStudio 2005, but from VStudio 2005 I don't see the option to
> >> > create
> >> > reports with Rep Svcs 2000.
> >> >
> >> > I need to be able to design reports in Rep Svcs 2000 and be able to
> >> > access
> >> > them from this win application project that is in VStudio 2005. Is this
> >> > possible? How can I do that?
> >> >
> >> > Thank you in advance,
> >> >
> >> > Richard
> >>
> >>
> >>
>
>

Reporting SVCS - Installing production over eval???

I am working on a reporting services development project. We installed the
evaluation copy of reporting services to support the project (we had to order
the standard production version). I now have the disc, and the development
project is about to end. I need to install the production version.
I installed using the disc that was sent. The install didn't take long. In
the event log, it says "The ReportServer service has been activated.".
Since we are about to finish the development project, I need to make sure we
are actually using the Production version.
How can I verify this?
If I need to do something else, what is it?
Thanks,
Andrew
> Since we are about to finish the development project, I need to make sure
we
> are actually using the Production version.
> How can I verify this?
Go to Contrl Panel, Add/Remove Programs; find MS SQL Server Reporting
Services and then click on the "Click here for support information link".
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||Thanks for the reply. It is showing the eval edition still installed.
What do I need to do in order to install the production version?
"Dejan Sarka" wrote:

> we
> Go to Contrl Panel, Add/Remove Programs; find MS SQL Server Reporting
> Services and then click on the "Click here for support information link".
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>
|||> What do I need to do in order to install the production version?
AFAIK you will have to use the same procedure as upgrading from Beta2 -
check http://support.microsoft.com/default...;en-us;836064.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Reporting SVCS - Installing production over eval???

I am working on a reporting services development project. We installed the
evaluation copy of reporting services to support the project (we had to orde
r
the standard production version). I now have the disc, and the development
project is about to end. I need to install the production version.
I installed using the disc that was sent. The install didn't take long. In
the event log, it says "The ReportServer service has been activated.".
Since we are about to finish the development project, I need to make sure we
are actually using the Production version.
How can I verify this?
If I need to do something else, what is it?
Thanks,
Andrew> Since we are about to finish the development project, I need to make sure
we
> are actually using the Production version.
> How can I verify this?
Go to Contrl Panel, Add/Remove Programs; find MS SQL Server Reporting
Services and then click on the "Click here for support information link".
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||Thanks for the reply. It is showing the eval edition still installed.
What do I need to do in order to install the production version?
"Dejan Sarka" wrote:

> we
> Go to Contrl Panel, Add/Remove Programs; find MS SQL Server Reporting
> Services and then click on the "Click here for support information link".
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
>|||> What do I need to do in order to install the production version?
AFAIK you will have to use the same procedure as upgrading from Beta2 -
check http://support.microsoft.com/defaul...b;en-us;836064.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com