Deployment to IIS and SQL

I've written a number of reports that now need to be deployed to a production
environment. The reports will be sitting on one IIS server that is
completely hidden from SQL Server. The reports data is retrieved via a web
service.
Can the reports be deployed to IIS and SQL server independantly? If so how?Deployment is easy, you just say where it resides (the IIS portion of RS)
and RS design client within VS does the rest. The real issue for you is
installing RS in this configuration. RS is an asp.net application. Your IIS
has to be configured appropriately for this. Read up on installing where the
SQL Server is not on the same box. This is totally supported. Note that you
will still need a license for the IIS box. You have to have a license on
every box that has RS server software installed.
Bruce L-C
"Buzz" <Buzz@.discussions.microsoft.com> wrote in message
news:90E11231-A3AE-42CC-9CD3-A0F469A00AD4@.microsoft.com...
> I've written a number of reports that now need to be deployed to a
production
> environment. The reports will be sitting on one IIS server that is
> completely hidden from SQL Server. The reports data is retrieved via a
web
> service.
> Can the reports be deployed to IIS and SQL server independantly? If so
how?|||VS does not have to be installed on the Server. Only on the development
machine.
Bruce L-C
"Buzz" <Buzz@.discussions.microsoft.com> wrote in message
news:76C3CEA2-DD41-4F26-A197-8C7FA36D1F41@.microsoft.com...
> We cannot use Visual Studio to deploy in a production environment, its
just
> not installed. I am looking into using the .NET ReportingService() class
to
> deploy via a windows application or script.
> "Bruce Loehle-Conger" wrote:
> > Deployment is easy, you just say where it resides (the IIS portion of
RS)
> > and RS design client within VS does the rest. The real issue for you is
> > installing RS in this configuration. RS is an asp.net application. Your
IIS
> > has to be configured appropriately for this. Read up on installing where
the
> > SQL Server is not on the same box. This is totally supported. Note that
you
> > will still need a license for the IIS box. You have to have a license on
> > every box that has RS server software installed.
> >
> > Bruce L-C
> >
> > "Buzz" <Buzz@.discussions.microsoft.com> wrote in message
> > news:90E11231-A3AE-42CC-9CD3-A0F469A00AD4@.microsoft.com...
> > > I've written a number of reports that now need to be deployed to a
> > production
> > > environment. The reports will be sitting on one IIS server that is
> > > completely hidden from SQL Server. The reports data is retrieved via
a
> > web
> > > service.
> > >
> > > Can the reports be deployed to IIS and SQL server independantly? If
so
> > how?
> >
> >
> >

Deployment of Server Reports

HI,
We have Server Reports in our application deployed on the Report
Server(local host). What all steps need to be done when we make an MSI of the
project for deplying reports on the new server? Do we need to first deploy
the reports on new server and then make an MSI? Need help.
Thanks in Advance.
ParimalYou do not/cannot use MSI to deploy reports. There are three ways to deploy
reports.
1. Use the IDE to deploy reports to production server (that is what I do).
2. Copy reports to server and then use Report Manager to add reports
3. Write a script. Search Books Online under scripting, samples
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:FC5A0A06-B81B-4183-83F4-98C4414A1B0A@.microsoft.com...
> HI,
> We have Server Reports in our application deployed on the Report
> Server(local host). What all steps need to be done when we make an MSI of
> the
> project for deplying reports on the new server? Do we need to first
> deploy
> the reports on new server and then make an MSI? Need help.
> Thanks in Advance.
> Parimal

Deployment of Rdl files and datasource to Production Server

Hi All,
I have develoded the SRS report using vs.net , and deployed to my local
sever using vs.net all works fine.
No i need to deploy these reports to a production server where vs.net is
not present.
So can any one tell me how to automate this process of deployment to
production server insteed of mannualy uploading the rld files and creating
data source in report manager.
Can set up be made for this scenarion to my production server.
Please help me it's urgent,
Thanks in advanceYou can create a deployment script with the rss utility in RS. Please
refer to the two scripts that ship with the product and customize it to
deploy to your production server. Command line arguments can be
specified for the datasource, connection string , report server url
etc.|||You have here the code for deploy the report on any SQLRS server
http://www.rdlcomponents.com/ASPExamples/default.aspx
Jerry
"RN" wrote:
> You can create a deployment script with the rss utility in RS. Please
> refer to the two scripts that ship with the product and customize it to
> deploy to your production server. Command line arguments can be
> specified for the datasource, connection string , report server url
> etc.
>

deployment of applications

Hi,

I have developed several PPC apps in VS2003, which i have deployed to other PPCs using sqlce.wce4.armv4.CAB for the database runtime.

Now I developed a new app. version in Visual Studio 2005, using the free SQL server express database that came with it.

I can create a .cab file for the app using a setup project, but it eludes me what to install on the PPC of the customer, database wise.

Is there some kind of installable runtime for sql server express ?

(Or what is it called today ?)

thx in advance,

Paul.

Hi Paul,

SQL Express edition is only available for desktop and server versions of Windows, not for Windows Mobile. You must use SQL CE version 3.1 cab files, ie: sqlce30.ppc.wce4.armv4.CAB and sqlce30.repl.ppc.wce4.armv4.CAB (for Windows Mobile 2003 devices)

Deployment issue - users cannot view reports

Hi All,
I am having some difficulty allowing users to view reports. I have
developed a series of reports on RS and deployed them to Report Manager.
However It is only myself that can view the reports on report mnanager -
whenever anyone else tries to log on and view them they get a blank page -
what am i doing wrong?
Thanks and HAPPY XMAS!!
GregGreg wrote:
> Hi All,
> I am having some difficulty allowing users to view reports. I have
> developed a series of reports on RS and deployed them to Report
> Manager. However It is only myself that can view the reports on
> report mnanager - whenever anyone else tries to log on and view them
> they get a blank page - what am i doing wrong?
>
> Thanks and HAPPY XMAS!!
> Greg
It may sound like a stupid question but ... have you checked their
permissions!
If they can see the Report Manager, but not see any reports, then the
security on the reports is too tight.
As administrator you will be able to click on properties and security
of the various folders and reports and add the appropriate users or
groups.
After that you will need to make sure the Datasources have suitable
logon credentials set too.
Regards (and merry christmas!)
Chris|||Hi chris - thanks for the pointer - ill check it out and get back!
"Chris McGuigan" wrote:
> Greg wrote:
> > Hi All,
> >
> > I am having some difficulty allowing users to view reports. I have
> > developed a series of reports on RS and deployed them to Report
> > Manager. However It is only myself that can view the reports on
> > report mnanager - whenever anyone else tries to log on and view them
> > they get a blank page - what am i doing wrong?
> >
> >
> > Thanks and HAPPY XMAS!!
> >
> > Greg
> It may sound like a stupid question but ... have you checked their
> permissions!
> If they can see the Report Manager, but not see any reports, then the
> security on the reports is too tight.
> As administrator you will be able to click on properties and security
> of the various folders and reports and add the appropriate users or
> groups.
> After that you will need to make sure the Datasources have suitable
> logon credentials set too.
> Regards (and merry christmas!)
> Chris
>|||I have what may be a similar issue. All users on our local intreanet can
view the reports, but people from the outside cannot. They can browse to
the page, and see the list of reports, but when they try to view a report,
they get "The Page cannot be Displayed".
Could this be the same as Greg's problem?
Thanks,
Daniel Williams
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
> Hi All,
> I am having some difficulty allowing users to view reports. I have
> developed a series of reports on RS and deployed them to Report Manager.
> However It is only myself that can view the reports on report mnanager -
> whenever anyone else tries to log on and view them they get a blank page -
> what am i doing wrong?
>
> Thanks and HAPPY XMAS!!
> Greg
>|||This is different. In the current version, Report Manager uses a frame to
access the reports. You probably need to set the ReportServerExternalURL
property. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"Daniel Williams" <daniel@.aniworld.com> wrote in message
news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
> I have what may be a similar issue. All users on our local intreanet can
> view the reports, but people from the outside cannot. They can browse to
> the page, and see the list of reports, but when they try to view a report,
> they get "The Page cannot be Displayed".
> Could this be the same as Greg's problem?
> Thanks,
> Daniel Williams
> "Greg" <Greg@.discussions.microsoft.com> wrote in message
> news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
>> Hi All,
>> I am having some difficulty allowing users to view reports. I have
>> developed a series of reports on RS and deployed them to Report Manager.
>> However It is only myself that can view the reports on report mnanager -
>> whenever anyone else tries to log on and view them they get a blank
>> page -
>> what am i doing wrong?
>>
>> Thanks and HAPPY XMAS!!
>> Greg
>|||Hi Daniel
Yes i think Brian is right - What Chris said helped me out - I had not
previously defined the permissions for my user group. Think yours may be a
separate issue.
Thanks Chris!
Greg
"Brian Welcker [MS]" wrote:
> This is different. In the current version, Report Manager uses a frame to
> access the reports. You probably need to set the ReportServerExternalURL
> property. See
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Daniel Williams" <daniel@.aniworld.com> wrote in message
> news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
> >
> > I have what may be a similar issue. All users on our local intreanet can
> > view the reports, but people from the outside cannot. They can browse to
> > the page, and see the list of reports, but when they try to view a report,
> > they get "The Page cannot be Displayed".
> >
> > Could this be the same as Greg's problem?
> >
> > Thanks,
> > Daniel Williams
> >
> > "Greg" <Greg@.discussions.microsoft.com> wrote in message
> > news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
> >> Hi All,
> >>
> >> I am having some difficulty allowing users to view reports. I have
> >> developed a series of reports on RS and deployed them to Report Manager.
> >> However It is only myself that can view the reports on report mnanager -
> >> whenever anyone else tries to log on and view them they get a blank
> >> page -
> >> what am i doing wrong?
> >>
> >>
> >> Thanks and HAPPY XMAS!!
> >>
> >> Greg
> >>
> >
> >
>
>|||You're right. Our problem was that we did not have a
<ReportServerExternalURL> value, so it was trying to use the internal
address when rendering the report. Completely different issue.
Cheers,
Daniel Williams
"Greg" <Greg@.discussions.microsoft.com> wrote in message
news:70AA6573-50BB-4D9F-BBE3-13E599B6673F@.microsoft.com...
> Hi Daniel
> Yes i think Brian is right - What Chris said helped me out - I had not
> previously defined the permissions for my user group. Think yours may be
> a
> separate issue.
> Thanks Chris!
> Greg
> "Brian Welcker [MS]" wrote:
>> This is different. In the current version, Report Manager uses a frame to
>> access the reports. You probably need to set the ReportServerExternalURL
>> property. See
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/drp_deploying_v1_0h9e.asp.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "Daniel Williams" <daniel@.aniworld.com> wrote in message
>> news:eabjGuP7EHA.2568@.TK2MSFTNGP10.phx.gbl...
>> >
>> > I have what may be a similar issue. All users on our local intreanet
>> > can
>> > view the reports, but people from the outside cannot. They can browse
>> > to
>> > the page, and see the list of reports, but when they try to view a
>> > report,
>> > they get "The Page cannot be Displayed".
>> >
>> > Could this be the same as Greg's problem?
>> >
>> > Thanks,
>> > Daniel Williams
>> >
>> > "Greg" <Greg@.discussions.microsoft.com> wrote in message
>> > news:48094DE4-52C0-4522-A822-352BADD676E4@.microsoft.com...
>> >> Hi All,
>> >>
>> >> I am having some difficulty allowing users to view reports. I have
>> >> developed a series of reports on RS and deployed them to Report
>> >> Manager.
>> >> However It is only myself that can view the reports on report
>> >> mnanager -
>> >> whenever anyone else tries to log on and view them they get a blank
>> >> page -
>> >> what am i doing wrong?
>> >>
>> >>
>> >> Thanks and HAPPY XMAS!!
>> >>
>> >> Greg
>> >>
>> >
>> >
>>sql

Deployment Issue

Hi,
I had a few sets of Reports, who were working fine. today I added a report
to my solution file at my dev machine and deployed it on the reportserver.
The Report got deployed successfully but when I browse the Report from the
browser before opening it shows the windows dialog box for "File Download"
and with the message "some files can harm your computer...." with the name
of the file as <reportfilename>.html. After clicking cancel the browser does
not shows the report. On clicking Save/Open the browser tries to download
some file which never ends.
Ironically it can preview my report from the dev machine.
My dev machine is Win XP and the Report server is Win 2000. I m using
Enterprise SQL Server MS Reports.
Is there any setting in reports/IE for this sudden behaviour
any idea will be highly appreciated..
siajHi,
I found the solution to my problem ...
There appears to be a bug in the MS RS version 8.00.743.00. If we name the
rdl file with a keyword containing "Attachmnet" Then we can deploy the file
but cant view the file..
I had named the file as "Look for Attachment.rdl" It did not work. I changed
the name it worked.
Would appreciate if some MS guy woule comment on this.
Cheers,
Jai
"siaj" wrote:
> Hi,
> I had a few sets of Reports, who were working fine. today I added a report
> to my solution file at my dev machine and deployed it on the reportserver.
> The Report got deployed successfully but when I browse the Report from the
> browser before opening it shows the windows dialog box for "File Download"
> and with the message "some files can harm your computer...." with the name
> of the file as <reportfilename>.html. After clicking cancel the browser does
> not shows the report. On clicking Save/Open the browser tries to download
> some file which never ends.
> Ironically it can preview my report from the dev machine.
> My dev machine is Win XP and the Report server is Win 2000. I m using
> Enterprise SQL Server MS Reports.
> Is there any setting in reports/IE for this sudden behaviour
> any idea will be highly appreciated..
> siaj

deployment failure

I am getting following deployment fail error when I try to deploy the
cube on the server:
"Error 1 The project could not be deployed to the 'myserver_2005'
server because of the following connectivity problems : A connection
cannot be made to redirector. Ensure that 'SQL Browser' service is
running. To verify or update the name of the target server, right-
click on the project in Solution Explorer, select Project Properties,
click on the Deployment tab, and then enter the name of the server. 0
0 "
How do I start the analysis server so that I can deploy the cube? I
have already manually started the analysis server and browser is
running. How do I connect to the analysis server using SSMS? I am
getting an error when I use SSMS to connect to analysis server 'a
connection can not be made to the redirector. Make sure that 'sql
browser service' is running' I made sure. I am guessing that this
error message is misleading and points to some other error. Thanks.What's with all these new threads?
See my reply to your original post.
ML
--
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Deployment Errors

Hi, I'm new to Reporting Services. However, I am sa on the reporting
services database server and also admin rights on the server. I deployed my
report to the reporting services server without errors, however someone else
(not sa equivalent on the database, and not admin equivalent) cannot deploy
because they get permission errors.
Any ideas? Thanks in advance.Read up on roles. Security works in RS via assigning user or groups to
roles. By default the administrators group of the server is in a role which
is why everything works for you. What I do is create local groups and to
that group I add domain users/groups. Then I assign that local group to a
role (this is done in Report Manager).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
> Hi, I'm new to Reporting Services. However, I am sa on the reporting
> services database server and also admin rights on the server. I deployed
> my
> report to the reporting services server without errors, however someone
> else
> (not sa equivalent on the database, and not admin equivalent) cannot
> deploy
> because they get permission errors.
> Any ideas? Thanks in advance.|||Thanks. I'll try it. I completed the MS Course 2030A Creating Reporting
Solutions, but can you recommend any other courses?
Thanks.
"Bruce L-C [MVP]" wrote:
> Read up on roles. Security works in RS via assigning user or groups to
> roles. By default the administrators group of the server is in a role which
> is why everything works for you. What I do is create local groups and to
> that group I add domain users/groups. Then I assign that local group to a
> role (this is done in Report Manager).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
> news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
> > Hi, I'm new to Reporting Services. However, I am sa on the reporting
> > services database server and also admin rights on the server. I deployed
> > my
> > report to the reporting services server without errors, however someone
> > else
> > (not sa equivalent on the database, and not admin equivalent) cannot
> > deploy
> > because they get permission errors.
> >
> > Any ideas? Thanks in advance.
>
>|||Sorry. Not familiar with the course. I would recommend buying some books.
There are several good ones. Two I have are Hitchhiker's Guide to SQL Server
2000 Reporting Services and Microsoft Reporting Services In Action.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
news:058E276C-0DE6-4667-8D98-8B1226CA224D@.microsoft.com...
> Thanks. I'll try it. I completed the MS Course 2030A Creating Reporting
> Solutions, but can you recommend any other courses?
> Thanks.
> "Bruce L-C [MVP]" wrote:
>> Read up on roles. Security works in RS via assigning user or groups to
>> roles. By default the administrators group of the server is in a role
>> which
>> is why everything works for you. What I do is create local groups and to
>> that group I add domain users/groups. Then I assign that local group to a
>> role (this is done in Report Manager).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "RichieRich" <RichieRich@.discussions.microsoft.com> wrote in message
>> news:221820BB-1DF3-4C08-8E73-2F0B6F4DC2A2@.microsoft.com...
>> > Hi, I'm new to Reporting Services. However, I am sa on the reporting
>> > services database server and also admin rights on the server. I
>> > deployed
>> > my
>> > report to the reporting services server without errors, however someone
>> > else
>> > (not sa equivalent on the database, and not admin equivalent) cannot
>> > deploy
>> > because they get permission errors.
>> >
>> > Any ideas? Thanks in advance.
>>

deployment error

A report runs well in Visual Studio environment. Once it is deployed to the local report server, got an #Error indication without an actual message. The report has an embedded code with a database connection in it. Any idea what the problem is?

Thank you very much!

Could be a security issue regarding the database connection. If i understand you correctly, you connect to a database in custom code? If you have trusted connection in your custom code, maybe it is not the same user that makes the database call when the report runs in ReportServer as in Visual Studio and you get an exception?|||

Thanks for your response. I thought it could be a security issue too. So I enabled trusted connection and tried using specific uid and pwd too. Neither of them worked.

|||What dp you get if you do a try/catch and return the exception text to a textbox in the report?

What does this custom code do? What does it do with the report? The reason i am asking is that there might be some other way to solve it.|||

The custom code retrieves and outputs another set of data based on the dynamic id outputted from the first set of data.

I'll see what text message I'll get if I use try/catch and let you know.

Thanks for your help.

|||I found out it has something to do with the Code Access Security in .NET. I did some research and found this article was very helpful: http://www.devx.com/codemag/Article/33656/1954?pf=true. Once I followed it step by step, the problem was resolved. Just wanted to share with the community, in case if there is anybody encountered the same problem as I did.

deployment error

A report runs well in Visual Studio environment. Once it is deployed to the local report server, got an #Error indication without an actual message. The report has an embedded code with a database connection in it. Any idea what the problem is?

Thank you very much!

Could be a security issue regarding the database connection. If i understand you correctly, you connect to a database in custom code? If you have trusted connection in your custom code, maybe it is not the same user that makes the database call when the report runs in ReportServer as in Visual Studio and you get an exception?|||

Thanks for your response. I thought it could be a security issue too. So I enabled trusted connection and tried using specific uid and pwd too. Neither of them worked.

|||What dp you get if you do a try/catch and return the exception text to a textbox in the report?

What does this custom code do? What does it do with the report? The reason i am asking is that there might be some other way to solve it.|||

The custom code retrieves and outputs another set of data based on the dynamic id outputted from the first set of data.

I'll see what text message I'll get if I use try/catch and let you know.

Thanks for your help.

|||I found out it has something to do with the Code Access Security in .NET. I did some research and found this article was very helpful: http://www.devx.com/codemag/Article/33656/1954?pf=true. Once I followed it step by step, the problem was resolved. Just wanted to share with the community, in case if there is anybody encountered the same problem as I did.sql

deployment and reports

Hi,

When I deploy a report i am assuming the report is deployed to the reporting service DB (ReportServer). Then when i try to view report in a browser I presume the following happens:

Navigate to http://localhost/Reports and click report you want to view

A web service call is made to retrieve report data from a DB eg Northwind

The data is the rendered based on the defined formatting in the RDL file and displayed in browser.

If this is correct does anyone known where the report is deployed to (DB or Web service) I cannot see the rdl files in any of these places and if I delete my project report viewing still works.

I know you can view all reports if you are in SQL management studio and go connect->reporting services but this is not a DB. Is this the web service and if so why cant i see files in IIS?

Thanks for replies

It's because they're not stored as files. When you deploy any files to the report server, they are stored in a table called Catalog and are serialized into an image column called Content.

Report Manager, Management Studio or whatever just connect to the web service and query it about which reports are stored in the database. The web service is basically the interface into the database.

Deployment Acritecture of SRS 2005

Hi,
I want to know how the .rdl files are deployed in the IIS Server and what is
the path where there are deplyed. Also how the UI identifes from where to
access the .rdl file attached to the perticular record.THe reports are stored in a table named Content(s?) if I remember
correctly...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Parimal" <Parimal@.discussions.microsoft.com> wrote in message
news:6BE09721-2DF8-4681-BFEB-FEF790CC9B5D@.microsoft.com...
> Hi,
> I want to know how the .rdl files are deployed in the IIS Server and what
is
> the path where there are deplyed. Also how the UI identifes from where to
> access the .rdl file attached to the perticular record.

Deploying updated report but still seeing old version

Hi,
I have looked up information about my problem in this group but couldn't
find any fitting solution.
I have deployed a report to the report server. I've added a textbox to the
report and delpoyed it again. When openening the report in the reportserver i
still get to see the old report (the one without the textbox). I have tried
the clearsession argument but did not work. I have cleared my IE cache,
restarted IIS, Deleted the whole map in the reports manager and deplyed the
report again, I don't cache any reports, but still i get to see the old
report. What could be the problem? I don't know where to look any more.
Thnx in advance.
StanleyAre you deploying from Visual Studio? I question whether it has been
deployed. The most I have ever had to do if this happens to me is to clost
IE and re-open IE. I have never had to do anything with IIS.
1. Do the following. Open up a new IE. Go to where the reports are and click
on the show details and look at the Modified Date.
2. Deploy
3. Redo #1 (new IE). Is the Modified Date column being updated?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stanley" <Stanley@.discussions.microsoft.com> wrote in message
news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> Hi,
> I have looked up information about my problem in this group but couldn't
> find any fitting solution.
> I have deployed a report to the report server. I've added a textbox to the
> report and delpoyed it again. When openening the report in the
reportserver i
> still get to see the old report (the one without the textbox). I have
tried
> the clearsession argument but did not work. I have cleared my IE cache,
> restarted IIS, Deleted the whole map in the reports manager and deplyed
the
> report again, I don't cache any reports, but still i get to see the old
> report. What could be the problem? I don't know where to look any more.
> Thnx in advance.
> Stanley|||I just deployed an update of 2 reports and a new report and all I did when
viewing the details list was to hit the refresh button in IE and it showed
the modified date and it showed the new report both.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> Are you deploying from Visual Studio? I question whether it has been
> deployed. The most I have ever had to do if this happens to me is to clost
> IE and re-open IE. I have never had to do anything with IIS.
>
> 1. Do the following. Open up a new IE. Go to where the reports are and
click
> on the show details and look at the Modified Date.
> 2. Deploy
> 3. Redo #1 (new IE). Is the Modified Date column being updated?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > Hi,
> >
> > I have looked up information about my problem in this group but couldn't
> > find any fitting solution.
> >
> > I have deployed a report to the report server. I've added a textbox to
the
> > report and delpoyed it again. When openening the report in the
> reportserver i
> > still get to see the old report (the one without the textbox). I have
> tried
> > the clearsession argument but did not work. I have cleared my IE cache,
> > restarted IIS, Deleted the whole map in the reports manager and deplyed
> the
> > report again, I don't cache any reports, but still i get to see the old
> > report. What could be the problem? I don't know where to look any
more.
> >
> > Thnx in advance.
> >
> > Stanley
>|||Hi Bruce,
I have deployed the reports and saw that the modified date indeed changed.
And i just noticed that the textbox was not showing on the same place as
where i had put it in desgin mode. The textbox was showing a the bottom of
the chart instead of on the chart where i had put it. That's why i assumed
that it was showing the old report. But than i have another problem which
also made me assume that is was showing the old report. I have some custom VB
code which select a default value for the month parameter. It selects the
current month and pre-sets that month as the default value when openening the
report. In preview mode it works fine, but when i deploy it, it doesn't wor.
I still have to select the value manually.
This is the VB code:
public function GetMonth() as string
GetMonth = Format(Now(),"MMMM")
end function
The parameter in the MDX query accepts the whole month name like:
[Period].[All Period].[2005].[January]
The report contains also a Year parameter which works just fine with VB Code
(to get this year value). Only the month parameter doens't work.
You know why?
Thanks for your help.
Stanley
"Bruce L-C [MVP]" wrote:
> I just deployed an update of 2 reports and a new report and all I did when
> viewing the details list was to hit the refresh button in IE and it showed
> the modified date and it showed the new report both.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > Are you deploying from Visual Studio? I question whether it has been
> > deployed. The most I have ever had to do if this happens to me is to clost
> > IE and re-open IE. I have never had to do anything with IIS.
> >
> >
> > 1. Do the following. Open up a new IE. Go to where the reports are and
> click
> > on the show details and look at the Modified Date.
> > 2. Deploy
> > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > Hi,
> > >
> > > I have looked up information about my problem in this group but couldn't
> > > find any fitting solution.
> > >
> > > I have deployed a report to the report server. I've added a textbox to
> the
> > > report and delpoyed it again. When openening the report in the
> > reportserver i
> > > still get to see the old report (the one without the textbox). I have
> > tried
> > > the clearsession argument but did not work. I have cleared my IE cache,
> > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > the
> > > report again, I don't cache any reports, but still i get to see the old
> > > report. What could be the problem? I don't know where to look any
> more.
> > >
> > > Thnx in advance.
> > >
> > > Stanley
> >
> >
>
>|||I thin k it's better if i create a new thread for this.
"Stanley" wrote:
> Hi Bruce,
> I have deployed the reports and saw that the modified date indeed changed.
> And i just noticed that the textbox was not showing on the same place as
> where i had put it in desgin mode. The textbox was showing a the bottom of
> the chart instead of on the chart where i had put it. That's why i assumed
> that it was showing the old report. But than i have another problem which
> also made me assume that is was showing the old report. I have some custom VB
> code which select a default value for the month parameter. It selects the
> current month and pre-sets that month as the default value when openening the
> report. In preview mode it works fine, but when i deploy it, it doesn't wor.
> I still have to select the value manually.
> This is the VB code:
> public function GetMonth() as string
> GetMonth = Format(Now(),"MMMM")
> end function
> The parameter in the MDX query accepts the whole month name like:
> [Period].[All Period].[2005].[January]
>
> The report contains also a Year parameter which works just fine with VB Code
> (to get this year value). Only the month parameter doens't work.
> You know why?
> Thanks for your help.
> Stanley
> "Bruce L-C [MVP]" wrote:
> > I just deployed an update of 2 reports and a new report and all I did when
> > viewing the details list was to hit the refresh button in IE and it showed
> > the modified date and it showed the new report both.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> > news:%23duxcCx$EHA.3836@.tk2msftngp13.phx.gbl...
> > > Are you deploying from Visual Studio? I question whether it has been
> > > deployed. The most I have ever had to do if this happens to me is to clost
> > > IE and re-open IE. I have never had to do anything with IIS.
> > >
> > >
> > > 1. Do the following. Open up a new IE. Go to where the reports are and
> > click
> > > on the show details and look at the Modified Date.
> > > 2. Deploy
> > > 3. Redo #1 (new IE). Is the Modified Date column being updated?
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Stanley" <Stanley@.discussions.microsoft.com> wrote in message
> > > news:955191A6-7FA6-4538-8422-29A746690707@.microsoft.com...
> > > > Hi,
> > > >
> > > > I have looked up information about my problem in this group but couldn't
> > > > find any fitting solution.
> > > >
> > > > I have deployed a report to the report server. I've added a textbox to
> > the
> > > > report and delpoyed it again. When openening the report in the
> > > reportserver i
> > > > still get to see the old report (the one without the textbox). I have
> > > tried
> > > > the clearsession argument but did not work. I have cleared my IE cache,
> > > > restarted IIS, Deleted the whole map in the reports manager and deplyed
> > > the
> > > > report again, I don't cache any reports, but still i get to see the old
> > > > report. What could be the problem? I don't know where to look any
> > more.
> > > >
> > > > Thnx in advance.
> > > >
> > > > Stanley
> > >
> > >
> >
> >
> >

Deploying reports to remote location

i am new in report service development.
currently I deployed reports on development server by vs.net.
I also aware about how to use report manager to deploy reports on server.
but both approaches need access to report server.
But now i have to deploy them on production server where i am not having
access.
Client ask us for some sort of setup program so that they can deploy them.
How can i do this.These is reporting webservice available at
http://<machine_name>/reportserver/reportservice.asmx
There are some functions provided by this webservice like CreateReport(),
which can be used for publishing reports. You will be required to write a
custom DLL to accomplish this and call the DLL from a setup program
Let me know if you have further queries
Bye
Sumit Pilankar
"vibha" <vibha@.discussions.microsoft.com> wrote in message
news:BD205062-FD5E-4C71-AAD4-D966428D668A@.microsoft.com...
>i am new in report service development.
> currently I deployed reports on development server by vs.net.
> I also aware about how to use report manager to deploy reports on server.
> but both approaches need access to report server.
> But now i have to deploy them on production server where i am not having
> access.
> Client ask us for some sort of setup program so that they can deploy them.
> How can i do this.

Deploying Reporting Servoces Reports to the Production Server

Hi,
I am new to Reporting Services. I have installed RS and SQL Server200 on my dev machine. I have created a few .rdl files and deployed them. The TargetServerURL property of my project is set tohttp://localhost/ReportServer. and TargetFolder is "ScoreCardReports".
I have used the reports in my Asp.net app by the RS Webservice (Web Reference URL is :http://localhost/ReportServer/ReportService.asmx.). I used the Render mehtod the get the images from the reports.
Now I will deploy my Asp.net app by creating the msi installer created by the setup & deployment project.
But how to package the .rdl and .rds files so that the app works on the production server ? That will be a windows2003 server.
Please help.The way we deploy to prod is to have the change control person log ontothe prod reporting services, and use the "upload file" option,selecting the .rdl file to import.
|||

I have solved the problem by executing the rs.exe in a bat file. I have created the .rss file containing all the commands to create the reports folder and deploying the reports to the target server. The path of the file has been passed as a parameter to the RS command.

The person to setup the whole application should now only run the .bat file and all the reports will be deployed to the server at one click.

|||

Hi Boss Th Question what u asked is little bit complex.

What u need to generate an .rss file by writing code in VB.Net

use this .rss file with a small command & create a batch file

So whenever u run that batch on a particular server the Reports what u have developed will be deployted on tto the Particular Production Server

Deploying folders to the reportmanager from VS

How to create folders in VS to be deployed to the reportmanager.
--
Regards
Henrik JuelRight now the best thing to do is to have a project and the project is
deployed to the appropriate folder in RS. Note that you can not today deploy
from VS to different folders from the same project. It is a one to one
relationship of project to folder.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Henrik Juel" <HenrikJuel@.discussions.microsoft.com> wrote in message
news:A8E733CE-6762-4B4E-9F85-A54D5D6EDC7A@.microsoft.com...
> How to create folders in VS to be deployed to the reportmanager.
> --
> Regards
> Henrik Juel

Deployed reports not being overwriting existing reports

Hi,
I am trying to deploy a new set of report to the Reporting server, but these
new versions of the reports do not seem to appear in the Report Manager.
There is no errors reported within VS.Net when deploying. Will it help to
either restart the web server or restart the database server in order to get
the new versions available in the manager.Make sure you are not getting errors from the deployment in VS.NET...
Ensure the deployment target location is correct.
Refresh the IE page, and ensure no page caching is occuring
Try to deploy from the Reporting Services Manager, and see if that is
working for you...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MicroMoth" <stephen.adams@.forvus.co.uk> wrote in message
news:0F7B9869-E10F-4C10-86A3-343EFDFA38A5@.microsoft.com...
> Hi,
> I am trying to deploy a new set of report to the Reporting server, but
these
> new versions of the reports do not seem to appear in the Report Manager.
> There is no errors reported within VS.Net when deploying. Will it help to
> either restart the web server or restart the database server in order to
get
> the new versions available in the manager.|||You can delete the reports in the Report Manager manually.
If you have the reports moved to subfolders in the report manager. They will
not be replaced. Instead they modified reports are published in the root
folder and the previous versions are remaining in the subfolder.
"Wayne Snyder" wrote:
> Make sure you are not getting errors from the deployment in VS.NET...
> Ensure the deployment target location is correct.
> Refresh the IE page, and ensure no page caching is occuring
> Try to deploy from the Reporting Services Manager, and see if that is
> working for you...
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "MicroMoth" <stephen.adams@.forvus.co.uk> wrote in message
> news:0F7B9869-E10F-4C10-86A3-343EFDFA38A5@.microsoft.com...
> > Hi,
> > I am trying to deploy a new set of report to the Reporting server, but
> these
> > new versions of the reports do not seem to appear in the Report Manager.
> > There is no errors reported within VS.Net when deploying. Will it help to
> > either restart the web server or restart the database server in order to
> get
> > the new versions available in the manager.
>
>|||On Wed, 2 Feb 2005 02:41:03 -0800, MicroMoth
<stephen.adams@.forvus.co.uk> wrote:
>Hi,
>I am trying to deploy a new set of report to the Reporting server, but these
>new versions of the reports do not seem to appear in the Report Manager.
>There is no errors reported within VS.Net when deploying. Will it help to
>either restart the web server or restart the database server in order to get
>the new versions available in the manager.
I had this problem, too, when deploying from within VS.NET. Drove me
nuts, until I simply restarted VS.NET IDE.|||Be sure to close IE and reopen it. That has always resolved seeing the most
recent version of a report.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Usenet User" < @. . > wrote in message
news:bfo401tgdsaiobnseo7qt0mpuf4n24bade@.4ax.com...
> On Wed, 2 Feb 2005 02:41:03 -0800, MicroMoth
> <stephen.adams@.forvus.co.uk> wrote:
> >Hi,
> >I am trying to deploy a new set of report to the Reporting server, but
these
> >new versions of the reports do not seem to appear in the Report Manager.
> >There is no errors reported within VS.Net when deploying. Will it help to
> >either restart the web server or restart the database server in order to
get
> >the new versions available in the manager.
>
> I had this problem, too, when deploying from within VS.NET. Drove me
> nuts, until I simply restarted VS.NET IDE.

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.
Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.
|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>

Deployed reports have javascript errors?

Hello-

I have developed a number of reports on Win XP with VS2005. They run on our development server, which is running Windows Server 2003 32-bit. I then deploy these reports on our production server, which is running Windows Server 2003 64-bit edition.

Accessing any of the reports from Report Manager results in javascript errors, such as 'Line 41 Error: 'RSClientController' is undefined'

I get these errors also when invoking these reports through a form post.

It appears that some javascript code generated by the report server is missing. Could this be a 32-bit vs 64-bit issue? Report Manager seems to work fine; it is only when I run a report that I have this problem. This is the first time I've tried to deploy reports to this server.

Thanks.
Solution!

The problem is the .axd file extention which is generated by the sql server on the fly when one tries to run a report.

There is an IIS setting that needs to be changed. Open IIS and go to the properties of the Reports website. Under the directory tab, click on the Configuration button. Find the .axd extension in the Mappings tab and double-click to get to its properties. Uncheck the 'Check that file exists' option, save, and that is it.

This is a known issue and MS hasn't yet written a KB article for it.
|||Excellent analysis. This solved my problem with reports and the WebResource.axd file.|||

What if I'm having the same "'RSClientController' is undefined" issue, but when I go to the .axd extension properties, "verify that file exists" is already unchecked?

This is on a clean install of SQL 2k5 on Server 2k3 SP1.

Thanks.

|||

On IIS v 6.0, on the Virtual Directory tab of the ReportServer, I chose configuration, then on the mappings tab I needed to edit the Wildcard application to uncheck the box to "verify file exists"

Thanks again;)

|||Anyone found a solution for this ?|||

If you website is using forms authentication, you have to grant access to authenticated users to Reserved.ReportViewerWebControl.axd.

After I added the following location entry in my web.config file I no longer received "RSClient Controller is not defined messages".

<location path="Reserved.ReportViewerWebControl.axd">

<system.web>

<authorization>

<allow roles="RoleA, RoleB">

</allow>

</authorization>

</system.web>

</location>