How to develop a report to use a global datasource?

Hi all..
By using report manager, I can configure a datasource that can be global for
all reports (stored in "/" path).
When I develop the report in VS.NET, I can set the report to use a shared
datasource or a private datasource. When I use a shared datasource, a new
datasource is created under the report path when I deploy it. That way I
always have to manually change connection information of the report using
report manager.
Is there a way to point to the global datasource at design time?
thanks
JaimeHi,
use <DataSourceReference>DSN path</DataSourceReference>
inside the <DataSource> tag for each report, to use a gloal datasource.
Thanks
Bava
"Jaime Stuardo" wrote:
> Hi all..
> By using report manager, I can configure a datasource that can be global for
> all reports (stored in "/" path).
> When I develop the report in VS.NET, I can set the report to use a shared
> datasource or a private datasource. When I use a shared datasource, a new
> datasource is created under the report path when I deploy it. That way I
> always have to manually change connection information of the report using
> report manager.
> Is there a way to point to the global datasource at design time?
> thanks
> Jaime

How To Determine Total Page Count For Report From VS.NET

I've got Reporting Services 2005. And I need to show reports in Delphi
(one page at a time).
I use web service written on VS.NET 2005 which calls
ReportingServices.Render(...), where
v_Format = "HTML4.0";
v_DeviceInfo = "<DeviceInfo><Toolbar>true</Toolbar><JavaScript>true</
JavaScript><LinkTarget>_top</LinkTarget><Section>" +
ReportRequest.RequestPage + "</Section></DeviceInfo>";
How can I determine total page count for report?On May 21, 8:33 am, Mary <mnem...@.gmail.com> wrote:
> I've got Reporting Services 2005. And I need to show reports in Delphi
> (one page at a time).
> I use web service written on VS.NET 2005 which calls
> ReportingServices.Render(...), where
> v_Format = "HTML4.0";
> v_DeviceInfo = "<DeviceInfo><Toolbar>true</Toolbar><JavaScript>true</
> JavaScript><LinkTarget>_top</LinkTarget><Section>" +
> ReportRequest.RequestPage + "</Section></DeviceInfo>";
> How can I determine total page count for report?
=Globals.TotalPages

How to design SQL Server 2005 Reporting Services Reports in VS.NET 2005 web applications

Hi,

Can we design SQL Server 2005 Reporting Services Reports in VS.NET 2005 web applications. If so how they can be designed. Plz help me if any one know the solution.

Thanx in advance,

Vidya

Are you asking if you can use VS.Net 2005 to design reports, yes, both client and server reports are built using VS.Net.

If you are asking if you can use a web application to build a report, well yes you could, but you would have you design it. All sql server reports are is an xml file, so if you can build a front end that will generate the xml in the proper format then you are good to go! I even believe there is a .Net Class that would assist you in this...

Josh

|||

u can design RS2005 in 2 ways:

1.u can open Business Intelligence Projects->Report Server Project,but than u will have to use Report Server.to design open a report file(rdl)

2.u can use ReportViewer within the Web application.to design open a report file(rdlc)

how to design dynamic reports based on user's choice

Hi all,

I'm a beginner to Report Services, and have tons of questions.

Here's the first one:

if the reports are created based on the condition that the user selects, how can I create the reports with Report Services?

For example,

the user can select the fields that will be shown on the reports, as well as the group fields, the sort fields and restrict fields. So I would not be able to pre-create all possible reports and deploy them to the report server, and I think I should create the reports dynamicly based on what the user select.

Could someone tell me how to do it (create and deploy the reports)?

Thanks a million!

Jonee

I think this it's possible to certain extend, but not sure if 100% percent. It would take some research and see how far can you get on this one.

how to deploy the reports to their own folders?

here is what i did, from either Report Manager or SQL Server Management
Studio i created a folder, then i move the reports to this folder, but
from Microsoft Visual Studio, as long as i deploy the project, it still
save my moved reports outside of the folder i created. i wonder how do
i let the system deploy the projects and still save inside the folder i
created. thanks.Use the project properties of the report project to specify the folder you
want the reports and data sources to go to. If you created it in "/My
Reports That Are Cool" then you specify the same folder name in the report
project properties.
-Tim
"Wang Xiaoning" <wang_xiaoning@.hotmail.com> wrote in message
news:1148590710.476371.266730@.g10g2000cwb.googlegroups.com...
> here is what i did, from either Report Manager or SQL Server Management
> Studio i created a folder, then i move the reports to this folder, but
> from Microsoft Visual Studio, as long as i deploy the project, it still
> save my moved reports outside of the folder i created. i wonder how do
> i let the system deploy the projects and still save inside the folder i
> created. thanks.
>|||Tim, i want to group the reports, saying, sales report go to sales
folder, finance report got o finance, then for end user, as long as
they see local/reports, they will know how to navigate to his own
folders and reports.|||do you mean i have to create tow projects(one for sales, one for
fiance)?

How to Deploy the reports automatically in SSRS?

Hi,

I am creating a application to show reports for daily based information.

I have created the reports and i am changing the data source at run time.In order to view the updated reports, i have to deploy.

So i need to deploy the reports automatically.

can any one gave a idea to do this.

thanks

Hi,

You can do this via the RS command.

What you need to do is write a script (.rss) that would serve as an input file to the rs command.

this script should loop through a folder and upload all extension with .rdl

Create a folder in your D: drive for example called RS within that have your script and have a sub folder called reports which were you will have all your reports.

once this has been done go to cmd and do the following

1. Map to your folder ie cd: D:\RS

2. type in the following command

rs -i PublishReports.rss -s http://localhost/reportserver

PublishReports.rss is your script and http://localhost/reportserver is where you want to deploy the reports.

Hope this helps.

|||

Hi,

Thanks for your solution.

It's work fine.

How to Deploy the reports automatically in SSRS?

Hi,

I am creating a application to show reports for daily based information.

I have created the reports and i am changing the data source at run time.In order to view the updated reports, i have to deploy.

So i need to deploy the reports automatically.

can any one gave a idea to do this.

thanks

Hi,

You can do this via the RS command.

What you need to do is write a script (.rss) that would serve as an input file to the rs command.

this script should loop through a folder and upload all extension with .rdl

Create a folder in your D: drive for example called RS within that have your script and have a sub folder called reports which were you will have all your reports.

once this has been done go to cmd and do the following

1. Map to your folder ie cd: D:\RS

2. type in the following command

rs -i PublishReports.rss -s http://localhost/reportserver

PublishReports.rss is your script and http://localhost/reportserver is where you want to deploy the reports.

Hope this helps.

|||

Hi,

Thanks for your solution.

It's work fine.

How to deploy the report on customer side

Hi there,
I am making some reports for some customers, I just wonder how they
deploy the reports - I don't know what their servers' name. Do they
need .NET on their server side so they can open my solution to change
deploy path and deploy method?
Thanks in advance.
HenryHenry,
See my reply to this thread:
http://groups.google.com/groups?hl=en&lr=&threadm=eQ4wHCDwEHA.2316%40TK2MSFTNGP15.phx.gbl&rnum=1&prev=/groups%3Fq%3D%2522Delivering%2BRS%2BReports%2Bto%2Ba%2Bcustomer%2522%26hl%3Den%26lr%3D%26selm%3DeQ4wHCDwEHA.2316%2540TK2MSFTNGP15.phx.gbl%26rnum%3D1
Basically, the easiest way to do this is to write a rss script which will be
executed on your client's Report Server box. Your script can take input
variables which you can use to pass settings, e.g. the computer name, etc.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Henry" <fanh@.tycoelectronics.com> wrote in message
news:d2a411ae.0411020706.535ffafe@.posting.google.com...
> Hi there,
> I am making some reports for some customers, I just wonder how they
> deploy the reports - I don't know what their servers' name. Do they
> need .NET on their server side so they can open my solution to change
> deploy path and deploy method?
> Thanks in advance.
> Henry

How To Deploy SSRS To Production Server ?

Hi All

I am having a problem with SSRS reports which I hope you can help with.

We have a web application which contains a couple dozen reports built using SSRS. In order to do a new release I first deploy the web application and the SSRS reports to our pre-production server for testing.

Whilst testing is going on, developers are making further changes to some of the reports and also the the database structure.

My problem is that when I want to move the new release from the pre-production server to the production server, I can copy the application but not the SSRS reports. So my only choice appears to be to deploy the SSRS reports from a devlopment machien directly to the production server.

This is clearly going to cause me problems as those reports may have been further developed and the database structure may have changed sine deploying the application to the pre-production server so I am effectly releasing untested reports directly to the production srever.

So my quesiton is:

How can I copy my SSRS reports from the pre-production server to the production server? Is there another way of dong this?

Regards

Smeat

yes.....

can we just get a link to this tool pinned?

www.sqldbatips.com

has a tool called Reporting Services Scripter 2.0.0.8

1.you point it at RS, set the options, it creates the script + files
2.global find replace in the files i.e. change servernames
3.run script

I suggest you try this in some kind of development environment first to understand all the different options this tool has|||

Thanks for the info.

One of our developers is checking this out.

Smeat

|||

One way of accompishing your goal will be using a version control software like Visual Source Safe. Here's the scenario.

1. Developer develops version 1 of report and check in Visual Source Safe.

2. Designated person (configuration administrator) pushes version 1 of report to pre-production environment.

3. Report is tested by QA group & users in the pre-production environment.

4. QA group and/or users discover errors and/or updates to be done by developers on version 1 of the report.

5. Developer implements updates and fix errors found on version 1 of the report & check in new version into Visual Source Safe (version 2).

6. Repeat step 2 but this time will be version 2 of the report.

7. Repeat step 3. Move to next step (step 8) if QA group & users are OK with updates; otherwise, repeat step 5 - 7

8. Designated person (configuration administrator) pushes final version of report to production.

I hope this helps.

How to deploy Reports.

Hi,

I have a web project and created a setup project for it. And I have to create reports using sql server reporting services. For this I have created an reportserver project and created two reports.

I have to create a setup file to install these reports in a remote machine.

How to do this?

where this .rdl and .rds files will be stored in the reportserver.

Regards,

Murali

You're in the wrong forum. Moving to SQL Server Reporting Services.|||

Russell Christopher has a blog post in which he gives a sample and outlines the process of using his sample to deploy RDLs via an MSI: http://blogs.msdn.com/bimusings/archive/2006/03/01/541599.aspx

I believe, however, that you may be better served embedding the ReportViewer control and building the reports into your web project. Here are a couple of resources for the ReportViewer control:

Report Authoring Tips and Tricks

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20050609SQLServerBW/manifest.xml

Getting started with SQL Server 2005 Reporting Services or the new report controls in Visual Studio 2005? Brian Welcker demonstrates some tips and tricks that you can use to add interactive features to your own reports. MSDN Webcast: Intelligent Reporting: Using the Visual Studio 2005 Report Viewer Controls (Level 200)

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032284444&EventCategory=5&culture=en-US&CountryCode=US

This explains integrating the ReportViewer control into your 2005 Web or Windows applications.

Larry|||

I left out a great resource:

http://www.gotreportviewer.com/

Larry

|||

Thanks for your help.

It helps me to find the solution.

Murali.

How to deploy reports using only report manager?

Hello!
I'm having problems deploying reports...
I have a development environment where I use Visual Studio to deploy reports
- All reports deployed have been manually assigned to shared data sources
instead of the one attached to the project. This works great.
However, when I need to deploy data sources and reports to a new instance of
reporting services in a production environment - I only want to use report
manager for this. I know I can't upload data sources, so I have manually
created those I have. The problem is that the reports I upload have a data
source attached in the XML that has a different ID than the one I just
created - So report manager complaint about the data sources being missing.
Now I want to access the reports and manually point them to the new shared
data sources, but the Browse button for data sources doesn't work - Nothing
happens when pushed.
So how am I supposed to assign the reports to the new data sources? - I have
manually tried to change the XML without luck, but I don't want to do this
every time I have to update a report.
HELP!
--
Cheers,
Daniel AHi Daniel:
Instead of using the report manager, you might consider a small .RSS
script.
In the ReportingServices/Samples/Scripts directory is a file called
PublishSampleReports.rss that programatically creates a datasource and
uploads rdl files using the source. Copying this file and building on
it gives you a base to build on.
This approach will also give you something you can test out in
development and then take to production with confidence it will work.
I always try to script as much as I can because I forget steps as soon
as I step in front of a prod machine and try to do stuff by hand.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Wed, 27 Oct 2004 06:59:08 -0700, "Daniel A"
<DanielA@.discussions.microsoft.com> wrote:
>Hello!
>I'm having problems deploying reports...
>I have a development environment where I use Visual Studio to deploy reports
>- All reports deployed have been manually assigned to shared data sources
>instead of the one attached to the project. This works great.
>However, when I need to deploy data sources and reports to a new instance of
>reporting services in a production environment - I only want to use report
>manager for this. I know I can't upload data sources, so I have manually
>created those I have. The problem is that the reports I upload have a data
>source attached in the XML that has a different ID than the one I just
>created - So report manager complaint about the data sources being missing.
>Now I want to access the reports and manually point them to the new shared
>data sources, but the Browse button for data sources doesn't work - Nothing
>happens when pushed.
>So how am I supposed to assign the reports to the new data sources? - I have
>manually tried to change the XML without luck, but I don't want to do this
>every time I have to update a report.
>HELP!|||Thanks Scott
I will investigate this method closer...
Daniel
"Scott Allen" wrote:
> Hi Daniel:
> Instead of using the report manager, you might consider a small .RSS
> script.
> In the ReportingServices/Samples/Scripts directory is a file called
> PublishSampleReports.rss that programatically creates a datasource and
> uploads rdl files using the source. Copying this file and building on
> it gives you a base to build on.
> This approach will also give you something you can test out in
> development and then take to production with confidence it will work.
> I always try to script as much as I can because I forget steps as soon
> as I step in front of a prod machine and try to do stuff by hand.
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Wed, 27 Oct 2004 06:59:08 -0700, "Daniel A"
> <DanielA@.discussions.microsoft.com> wrote:
> >Hello!
> >
> >I'm having problems deploying reports...
> >
> >I have a development environment where I use Visual Studio to deploy reports
> >- All reports deployed have been manually assigned to shared data sources
> >instead of the one attached to the project. This works great.
> >
> >However, when I need to deploy data sources and reports to a new instance of
> >reporting services in a production environment - I only want to use report
> >manager for this. I know I can't upload data sources, so I have manually
> >created those I have. The problem is that the reports I upload have a data
> >source attached in the XML that has a different ID than the one I just
> >created - So report manager complaint about the data sources being missing.
> >Now I want to access the reports and manually point them to the new shared
> >data sources, but the Browse button for data sources doesn't work - Nothing
> >happens when pushed.
> >
> >So how am I supposed to assign the reports to the new data sources? - I have
> >manually tried to change the XML without luck, but I don't want to do this
> >every time I have to update a report.
> >
> >HELP!
>|||Hi Scott
It's pretty easy to script the deployment, but the report is still pointing
to a data source that doesn't exist and for some reason the browse button to
point to another data source doesn't work - So it didn't really solve my
problem :o(
Daniel
"Scott Allen" wrote:
> Hi Daniel:
> Instead of using the report manager, you might consider a small .RSS
> script.
> In the ReportingServices/Samples/Scripts directory is a file called
> PublishSampleReports.rss that programatically creates a datasource and
> uploads rdl files using the source. Copying this file and building on
> it gives you a base to build on.
> This approach will also give you something you can test out in
> development and then take to production with confidence it will work.
> I always try to script as much as I can because I forget steps as soon
> as I step in front of a prod machine and try to do stuff by hand.
> --
> Scott
> http://www.OdeToCode.com/blogs/scott/
> On Wed, 27 Oct 2004 06:59:08 -0700, "Daniel A"
> <DanielA@.discussions.microsoft.com> wrote:
> >Hello!
> >
> >I'm having problems deploying reports...
> >
> >I have a development environment where I use Visual Studio to deploy reports
> >- All reports deployed have been manually assigned to shared data sources
> >instead of the one attached to the project. This works great.
> >
> >However, when I need to deploy data sources and reports to a new instance of
> >reporting services in a production environment - I only want to use report
> >manager for this. I know I can't upload data sources, so I have manually
> >created those I have. The problem is that the reports I upload have a data
> >source attached in the XML that has a different ID than the one I just
> >created - So report manager complaint about the data sources being missing.
> >Now I want to access the reports and manually point them to the new shared
> >data sources, but the Browse button for data sources doesn't work - Nothing
> >happens when pushed.
> >
> >So how am I supposed to assign the reports to the new data sources? - I have
> >manually tried to change the XML without luck, but I don't want to do this
> >every time I have to update a report.
> >
> >HELP!
>|||Well I solved it - As a part of the scripted deployment I used the
SetReportDataSources method to update the data source of the report once
uploaded - This works great...
Required a bit of work, but it's totally easy to deploy the reports now -
Just execute a batch file :o)
Daniel
"Daniel A" wrote:
> Hi Scott
> It's pretty easy to script the deployment, but the report is still pointing
> to a data source that doesn't exist and for some reason the browse button to
> point to another data source doesn't work - So it didn't really solve my
> problem :o(
>
> Daniel
>
> "Scott Allen" wrote:
> > Hi Daniel:
> >
> > Instead of using the report manager, you might consider a small .RSS
> > script.
> >
> > In the ReportingServices/Samples/Scripts directory is a file called
> > PublishSampleReports.rss that programatically creates a datasource and
> > uploads rdl files using the source. Copying this file and building on
> > it gives you a base to build on.
> >
> > This approach will also give you something you can test out in
> > development and then take to production with confidence it will work.
> > I always try to script as much as I can because I forget steps as soon
> > as I step in front of a prod machine and try to do stuff by hand.
> >
> > --
> > Scott
> > http://www.OdeToCode.com/blogs/scott/
> >
> > On Wed, 27 Oct 2004 06:59:08 -0700, "Daniel A"
> > <DanielA@.discussions.microsoft.com> wrote:
> >
> > >Hello!
> > >
> > >I'm having problems deploying reports...
> > >
> > >I have a development environment where I use Visual Studio to deploy reports
> > >- All reports deployed have been manually assigned to shared data sources
> > >instead of the one attached to the project. This works great.
> > >
> > >However, when I need to deploy data sources and reports to a new instance of
> > >reporting services in a production environment - I only want to use report
> > >manager for this. I know I can't upload data sources, so I have manually
> > >created those I have. The problem is that the reports I upload have a data
> > >source attached in the XML that has a different ID than the one I just
> > >created - So report manager complaint about the data sources being missing.
> > >Now I want to access the reports and manually point them to the new shared
> > >data sources, but the Browse button for data sources doesn't work - Nothing
> > >happens when pushed.
> > >
> > >So how am I supposed to assign the reports to the new data sources? - I have
> > >manually tried to change the XML without luck, but I don't want to do this
> > >every time I have to update a report.
> > >
> > >HELP!
> >
> >|||Cool!
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Fri, 29 Oct 2004 02:03:02 -0700, "Daniel A"
<DanielA@.discussions.microsoft.com> wrote:
>Well I solved it - As a part of the scripted deployment I used the
>SetReportDataSources method to update the data source of the report once
>uploaded - This works great...
>Required a bit of work, but it's totally easy to deploy the reports now -
>Just execute a batch file :o)
>
>Daniel
>
>"Daniel A" wrote:
>> Hi Scott
>> It's pretty easy to script the deployment, but the report is still pointing
>> to a data source that doesn't exist and for some reason the browse button to
>> point to another data source doesn't work - So it didn't really solve my
>> problem :o(
>>
>> Daniel
>>
>> "Scott Allen" wrote:
>> > Hi Daniel:
>> >
>> > Instead of using the report manager, you might consider a small .RSS
>> > script.
>> >
>> > In the ReportingServices/Samples/Scripts directory is a file called
>> > PublishSampleReports.rss that programatically creates a datasource and
>> > uploads rdl files using the source. Copying this file and building on
>> > it gives you a base to build on.
>> >
>> > This approach will also give you something you can test out in
>> > development and then take to production with confidence it will work.
>> > I always try to script as much as I can because I forget steps as soon
>> > as I step in front of a prod machine and try to do stuff by hand.
>> >
>> > --
>> > Scott
>> > http://www.OdeToCode.com/blogs/scott/
>> >
>> > On Wed, 27 Oct 2004 06:59:08 -0700, "Daniel A"
>> > <DanielA@.discussions.microsoft.com> wrote:
>> >
>> > >Hello!
>> > >
>> > >I'm having problems deploying reports...
>> > >
>> > >I have a development environment where I use Visual Studio to deploy reports
>> > >- All reports deployed have been manually assigned to shared data sources
>> > >instead of the one attached to the project. This works great.
>> > >
>> > >However, when I need to deploy data sources and reports to a new instance of
>> > >reporting services in a production environment - I only want to use report
>> > >manager for this. I know I can't upload data sources, so I have manually
>> > >created those I have. The problem is that the reports I upload have a data
>> > >source attached in the XML that has a different ID than the one I just
>> > >created - So report manager complaint about the data sources being missing.
>> > >Now I want to access the reports and manually point them to the new shared
>> > >data sources, but the Browse button for data sources doesn't work - Nothing
>> > >happens when pushed.
>> > >
>> > >So how am I supposed to assign the reports to the new data sources? - I have
>> > >manually tried to change the XML without luck, but I don't want to do this
>> > >every time I have to update a report.
>> > >
>> > >HELP!
>> >
>> >|||> In the ReportingServices/Samples/Scripts directory is a file called
> PublishSampleReports.rss
I don't see any such directory or file on my machine - where exactly is it located'|||> In the ReportingServices/Samples/Scripts directory is a file called
> PublishSampleReports.rss
Ewwww - never mind my other post, I found the file

How to Deploy Reports to a Production Environment

Our situation is that we are developing a set of "master" reports locally
using Visual Studio .NET 2003 (and, of course, the Reporting Services
designer). Once the master reports are finished, we will need to install
these reports to our customers' computers (their computers are not a part of
our network, we don't have access to them to deploy from our computers and
the Visual Studio .NET 2003 solution/project). And then we will need to
deploy to the ReportServer on their server.
Additionally, the customers' server will have VB .NET installed (the basic
edition to allow RDL development).
So, should we simply copy the solution, project, RDS, and RDL files to the
customers' server, then open the solution in VB .NET, and deploy? Or is
there a better way?
Also, since we are developing the master reports in a solution/project in
Visual Studio .NET on our local development servers, is there any
compatibility issues in trying to open that same solution in VB .NET on the
customers' server?
Thanks.I would think the easiest way would be to build a quick app to do this using
the CreateReport SOAP Api. You could then make this app as simple or
complex as you need it and not need to worry about your customers having any
VS components. We shipped a sample app (RSExplorer I believe) that does
allow you to deploy but it would have to be modified if you wanted to easily
upload a directory of rdls.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Belak" <nospam@.nospam.com> wrote in message
news:OrhITzzmEHA.3264@.TK2MSFTNGP12.phx.gbl...
> Our situation is that we are developing a set of "master" reports locally
> using Visual Studio .NET 2003 (and, of course, the Reporting Services
> designer). Once the master reports are finished, we will need to install
> these reports to our customers' computers (their computers are not a part
of
> our network, we don't have access to them to deploy from our computers and
> the Visual Studio .NET 2003 solution/project). And then we will need to
> deploy to the ReportServer on their server.
> Additionally, the customers' server will have VB .NET installed (the basic
> edition to allow RDL development).
> So, should we simply copy the solution, project, RDS, and RDL files to the
> customers' server, then open the solution in VB .NET, and deploy? Or is
> there a better way?
> Also, since we are developing the master reports in a solution/project in
> Visual Studio .NET on our local development servers, is there any
> compatibility issues in trying to open that same solution in VB .NET on
the
> customers' server?
> Thanks.
>

how to deploy reports on report server other then using rerport mg

hey, Is there any way to making a setup of report project, to deploy reports
on server.
I have used both vs.net and report manager, but in both ways i have to has
access to report server.
I want to deply reports on the server on which i am not having access.
How to make a setup.
thanksSee if Reporting Services Scripter helps.
http://www.sqldbatips.com/showarticle.asp?ID=62
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"vibha" <vibha@.discussions.microsoft.com> wrote in message
news:89560410-2E89-469D-85DF-695657E57E8F@.microsoft.com...
> hey, Is there any way to making a setup of report project, to deploy
> reports
> on server.
> I have used both vs.net and report manager, but in both ways i have to has
> access to report server.
> I want to deply reports on the server on which i am not having access.
> How to make a setup.
> thanks|||Even with the scripter you will have to have some sort of Access. VS.net is
using web services to deploy. As long as your account has the rights in RS
to deploy you will be able to do this. Your account does not have to be
admin on the server (if it is then it automatically has deploy rights).
I suggest you look at how RS implement roles.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vibha" <vibha@.discussions.microsoft.com> wrote in message
news:89560410-2E89-469D-85DF-695657E57E8F@.microsoft.com...
> hey, Is there any way to making a setup of report project, to deploy
> reports
> on server.
> I have used both vs.net and report manager, but in both ways i have to has
> access to report server.
> I want to deply reports on the server on which i am not having access.
> How to make a setup.
> thanks

How to deploy reports from my pc to my client's server?

Hi Guys,

I am using MS Visual Studio .Net 2003 to design reports from the data in MS SQL Server.

I have no problem to deploy, view or run the reports in my pc with MS SQL Reporting Services installed.

Now, my client's server with MS SQL Reporting Services only installed, but no MS Visual Studio installed.

How to deploy all my reports in my pc into my client's server so that user can view the reports in the server thru IE?

Thanks.

Yes, you can upload the .RDL file into Server.

You need to open http://<servername>/Reports page and press Upload File Button on the command bar. Then you can browse for your .RDL files (files that are copied from your home computer) and after you upload these reports to your server you may consider to change the Data Source.

For changing the Data Source you must open the report and go to the Properties Tab, than select Data Sources. You can choose from Shared Data source or Custom Data source, after you make your selection you need to press Apply button (on the bottom of the page).

Good luck.

|||

Thanks for your reply.

Just manage to get the server up.

But when I open http://<servername>/Reports I can't see any Upload File Button. I got only "Home | My Subscriptions | Help" on right top corner.

|||

Hi,

#1. go to Control Panel->Administrative Tools -> IIS , open Internet Information Services.

#2. Double click your server name-> goto web sites-> Default WebSite

#3. right click on report server goto directory security tab click edit button and deselect the anonymous acces check box.

do the step 3 for "Reports" also,.

and go to http://<servername>/Reports ull be able to see the upload button now.

Hope this solves your problem.

|||Yupe.. I see it now.. Thanks to both PFerns and Pavel Cristian Gabriel!

How to deploy my Reports to the Internet? Anonymous access

How can I achive this. I need some reports to be on my page; I already know
to use reportviewer. So I will show it inside my page. But I want to
configure some of the reports that the user dont be asked for a DOMAIN user
name.*
What should I do?
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
http://spaces.msn.com/members/extremed/What kind of Authentication you are using for website? Form based?
HTH,
ALi-R
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:Ob62InICFHA.3504@.TK2MSFTNGP12.phx.gbl...
> How can I achive this. I need some reports to be on my page; I already
know
> to use reportviewer. So I will show it inside my page. But I want to
> configure some of the reports that the user dont be asked for a DOMAIN
user
> name.*
> What should I do?
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 3.
> MIEMBRO ACTIVO DE ALIANZADEV
> http://spaces.msn.com/members/extremed/
>|||It is not often good to enable anonymous access to the report server - this
hinders your ability to manage the system (everyone is the same user). You
can use a custom security extension to govern this w/o needing to create
DOMIAN accounts. You'd need to author and deploy the custom security
extension.
If this is not viable, an alternative is to deploy two report servers in a
web farm. Make on internet facing and allow anonymous access on it's
virtual directory. Make the other internal facing and require
authentication on it. This allows you to both give anonymous users rights
while ensuring fine grained security control over who can do report server
operations.
You will also want to customize the roles on your report server to limit
what anonymous users can do - anonymous shouldn't be able to subscribe for
example, this might bring your report server to its knees in the hands of an
attacker :-).
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:Ob62InICFHA.3504@.TK2MSFTNGP12.phx.gbl...
> How can I achive this. I need some reports to be on my page; I already
> know
> to use reportviewer. So I will show it inside my page. But I want to
> configure some of the reports that the user dont be asked for a DOMAIN
> user
> name.*
> What should I do?
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 3.
> MIEMBRO ACTIVO DE ALIANZADEV
> http://spaces.msn.com/members/extremed/
>|||Hi Lukasz,
I know that you always monitor the threads you answer so I'd like to use
this thread to let you know that ,the thread I initiated with the subject of
"Sharepoint and Reporting Services" has been left unanswered for that last
post I did.I would appreciate if you could take a quick look at it too.
Thanks
"Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in message
news:eNaNyMfDFHA.2824@.tk2msftngp13.phx.gbl...
> It is not often good to enable anonymous access to the report server -
this
> hinders your ability to manage the system (everyone is the same user).
You
> can use a custom security extension to govern this w/o needing to create
> DOMIAN accounts. You'd need to author and deploy the custom security
> extension.
> If this is not viable, an alternative is to deploy two report servers in a
> web farm. Make on internet facing and allow anonymous access on it's
> virtual directory. Make the other internal facing and require
> authentication on it. This allows you to both give anonymous users rights
> while ensuring fine grained security control over who can do report server
> operations.
> You will also want to customize the roles on your report server to limit
> what anonymous users can do - anonymous shouldn't be able to subscribe for
> example, this might bring your report server to its knees in the hands of
an
> attacker :-).
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> news:Ob62InICFHA.3504@.TK2MSFTNGP12.phx.gbl...
> > How can I achive this. I need some reports to be on my page; I already
> > know
> > to use reportviewer. So I will show it inside my page. But I want to
> > configure some of the reports that the user dont be asked for a DOMAIN
> > user
> > name.*
> > What should I do?
> >
> > --
> > LUIS ESTEBAN VALENCIA
> > MICROSOFT DCE 3.
> > MIEMBRO ACTIVO DE ALIANZADEV
> > http://spaces.msn.com/members/extremed/
> >
> >
>|||Sorry, I don't have that thread anymore. What is the issue?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"ALI-R" <newbie@.microsoft.com> wrote in message
news:OanIKNhDFHA.2508@.TK2MSFTNGP09.phx.gbl...
> Hi Lukasz,
> I know that you always monitor the threads you answer so I'd like to use
> this thread to let you know that ,the thread I initiated with the subject
> of
> "Sharepoint and Reporting Services" has been left unanswered for that last
> post I did.I would appreciate if you could take a quick look at it too.
> Thanks
> "Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in message
> news:eNaNyMfDFHA.2824@.tk2msftngp13.phx.gbl...
>> It is not often good to enable anonymous access to the report server -
> this
>> hinders your ability to manage the system (everyone is the same user).
> You
>> can use a custom security extension to govern this w/o needing to create
>> DOMIAN accounts. You'd need to author and deploy the custom security
>> extension.
>> If this is not viable, an alternative is to deploy two report servers in
>> a
>> web farm. Make on internet facing and allow anonymous access on it's
>> virtual directory. Make the other internal facing and require
>> authentication on it. This allows you to both give anonymous users
>> rights
>> while ensuring fine grained security control over who can do report
>> server
>> operations.
>> You will also want to customize the roles on your report server to limit
>> what anonymous users can do - anonymous shouldn't be able to subscribe
>> for
>> example, this might bring your report server to its knees in the hands of
> an
>> attacker :-).
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
>> news:Ob62InICFHA.3504@.TK2MSFTNGP12.phx.gbl...
>> > How can I achive this. I need some reports to be on my page; I already
>> > know
>> > to use reportviewer. So I will show it inside my page. But I want to
>> > configure some of the reports that the user dont be asked for a DOMAIN
>> > user
>> > name.*
>> > What should I do?
>> >
>> > --
>> > LUIS ESTEBAN VALENCIA
>> > MICROSOFT DCE 3.
>> > MIEMBRO ACTIVO DE ALIANZADEV
>> > http://spaces.msn.com/members/extremed/
>> >
>> >
>>
>|||The thread subject is "Sharepiont and Reporting services" and from "ALI-R"
,it was about using kerbers for having sps and rs on different computers,I
asked the last question and unfortunately I didn't get any answer from you.
"Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in message
news:%23rB5wTvDFHA.2568@.TK2MSFTNGP10.phx.gbl...
> Sorry, I don't have that thread anymore. What is the issue?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "ALI-R" <newbie@.microsoft.com> wrote in message
> news:OanIKNhDFHA.2508@.TK2MSFTNGP09.phx.gbl...
> > Hi Lukasz,
> >
> > I know that you always monitor the threads you answer so I'd like to use
> > this thread to let you know that ,the thread I initiated with the
subject
> > of
> > "Sharepoint and Reporting Services" has been left unanswered for that
last
> > post I did.I would appreciate if you could take a quick look at it too.
> > Thanks
> > "Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in
message
> > news:eNaNyMfDFHA.2824@.tk2msftngp13.phx.gbl...
> >> It is not often good to enable anonymous access to the report server -
> > this
> >> hinders your ability to manage the system (everyone is the same user).
> > You
> >> can use a custom security extension to govern this w/o needing to
create
> >> DOMIAN accounts. You'd need to author and deploy the custom security
> >> extension.
> >>
> >> If this is not viable, an alternative is to deploy two report servers
in
> >> a
> >> web farm. Make on internet facing and allow anonymous access on it's
> >> virtual directory. Make the other internal facing and require
> >> authentication on it. This allows you to both give anonymous users
> >> rights
> >> while ensuring fine grained security control over who can do report
> >> server
> >> operations.
> >>
> >> You will also want to customize the roles on your report server to
limit
> >> what anonymous users can do - anonymous shouldn't be able to subscribe
> >> for
> >> example, this might bring your report server to its knees in the hands
of
> > an
> >> attacker :-).
> >>
> >> -Lukasz
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> >>
> >>
> >>
> >> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
> >> news:Ob62InICFHA.3504@.TK2MSFTNGP12.phx.gbl...
> >> > How can I achive this. I need some reports to be on my page; I
already
> >> > know
> >> > to use reportviewer. So I will show it inside my page. But I want
to
> >> > configure some of the reports that the user dont be asked for a
DOMAIN
> >> > user
> >> > name.*
> >> > What should I do?
> >> >
> >> > --
> >> > LUIS ESTEBAN VALENCIA
> >> > MICROSOFT DCE 3.
> >> > MIEMBRO ACTIVO DE ALIANZADEV
> >> > http://spaces.msn.com/members/extremed/
> >> >
> >> >
> >>
> >>
> >
> >
>|||I'm sorry, could you restate your question? I don't have the other thread
and I don't know which question you're referring to when you say, "the last
question.".
Are you asking how to deploy Kerberos? I couldn't really find a link that
explained how to do this. I know there are books written on this topic.
You can start here:
http://toolbar.search.msn.com/results.aspx?q=kerberos+how+to+site%3Amsdn.microsoft.com&FORM=QBRE
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"ALI-R" <newbie@.microsoft.com> wrote in message
news:OD9%23NqwDFHA.2232@.TK2MSFTNGP14.phx.gbl...
> The thread subject is "Sharepiont and Reporting services" and from "ALI-R"
> ,it was about using kerbers for having sps and rs on different computers,I
> asked the last question and unfortunately I didn't get any answer from
> you.
> "Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in message
> news:%23rB5wTvDFHA.2568@.TK2MSFTNGP10.phx.gbl...
>> Sorry, I don't have that thread anymore. What is the issue?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>>
>> "ALI-R" <newbie@.microsoft.com> wrote in message
>> news:OanIKNhDFHA.2508@.TK2MSFTNGP09.phx.gbl...
>> > Hi Lukasz,
>> >
>> > I know that you always monitor the threads you answer so I'd like to
>> > use
>> > this thread to let you know that ,the thread I initiated with the
> subject
>> > of
>> > "Sharepoint and Reporting Services" has been left unanswered for that
> last
>> > post I did.I would appreciate if you could take a quick look at it too.
>> > Thanks
>> > "Lukasz Pawlowski [MSFT]" <lukaszp@.online.microsoft.com> wrote in
> message
>> > news:eNaNyMfDFHA.2824@.tk2msftngp13.phx.gbl...
>> >> It is not often good to enable anonymous access to the report server -
>> > this
>> >> hinders your ability to manage the system (everyone is the same user).
>> > You
>> >> can use a custom security extension to govern this w/o needing to
> create
>> >> DOMIAN accounts. You'd need to author and deploy the custom security
>> >> extension.
>> >>
>> >> If this is not viable, an alternative is to deploy two report servers
> in
>> >> a
>> >> web farm. Make on internet facing and allow anonymous access on it's
>> >> virtual directory. Make the other internal facing and require
>> >> authentication on it. This allows you to both give anonymous users
>> >> rights
>> >> while ensuring fine grained security control over who can do report
>> >> server
>> >> operations.
>> >>
>> >> You will also want to customize the roles on your report server to
> limit
>> >> what anonymous users can do - anonymous shouldn't be able to subscribe
>> >> for
>> >> example, this might bring your report server to its knees in the hands
> of
>> > an
>> >> attacker :-).
>> >>
>> >> -Lukasz
>> >>
>> >>
>> >> --
>> >> This posting is provided "AS IS" with no warranties, and confers no
>> > rights.
>> >>
>> >>
>> >>
>> >> "Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
>> >> news:Ob62InICFHA.3504@.TK2MSFTNGP12.phx.gbl...
>> >> > How can I achive this. I need some reports to be on my page; I
> already
>> >> > know
>> >> > to use reportviewer. So I will show it inside my page. But I want
> to
>> >> > configure some of the reports that the user dont be asked for a
> DOMAIN
>> >> > user
>> >> > name.*
>> >> > What should I do?
>> >> >
>> >> > --
>> >> > LUIS ESTEBAN VALENCIA
>> >> > MICROSOFT DCE 3.
>> >> > MIEMBRO ACTIVO DE ALIANZADEV
>> >> > http://spaces.msn.com/members/extremed/
>> >> >
>> >> >
>> >>
>> >>
>> >
>> >
>>
>

How to deploy my reports on the Internet: Anonymous Access?

How can I achive this. I need some reports to be on my page; I already know
to use reportviewer. So I will show it inside my page. But I want to
configure some of the reports that the user dont be asked for a DOMAIN user
name.*
What should I do?
--
LUIS ESTEBAN VALENCIA
MICROSOFT DCE 3.
MIEMBRO ACTIVO DE ALIANZADEV
http://spaces.msn.com/members/extremed/Anonymous access is pretty difficult to set up. With a default
configuration, when you turn on anonymous access on the web site, then
you're not prompted for a user name at all, and then you can't do your other
stuff like get to protected information or publish files using the Report
Manager.
There are ways to do it, but because of the security concerns, my suggestion
would be to call Microsoft and open a support ticket asking them to walk you
through the process.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Luis Esteban Valencia" <luisvalen@.haceb.com> wrote in message
news:%23iPZZVrEFHA.1836@.tk2msftngp13.phx.gbl...
> How can I achive this. I need some reports to be on my page; I already
> know
> to use reportviewer. So I will show it inside my page. But I want to
> configure some of the reports that the user dont be asked for a DOMAIN
> user
> name.*
> What should I do?
> --
> LUIS ESTEBAN VALENCIA
> MICROSOFT DCE 3.
> MIEMBRO ACTIVO DE ALIANZADEV
> http://spaces.msn.com/members/extremed/
>

How to deplory reports using visual studio and Forms Authentication?

Hi,
i successfully installed the forms authentication example on my report
server.
The problem i am facing now is that i am no longer able to deploy my
reports using visual studio to the report server as i did before. Is
there a possibility to still use visual studio for deploying?
If not, is there an alternative for deploying? How can i transfer my
reports, data-sources and models to the server?Have you removed Windows Authentication as an option in IIS? My VS prompts
me when LogonUser fails.
"Patrick Dinger" <paxos2k@.gmail.com> wrote in message
news:1142000029.874965.138750@.u72g2000cwu.googlegroups.com...
> Hi,
> i successfully installed the forms authentication example on my report
> server.
> The problem i am facing now is that i am no longer able to deploy my
> reports using visual studio to the report server as i did before. Is
> there a possibility to still use visual studio for deploying?
> If not, is there an alternative for deploying? How can i transfer my
> reports, data-sources and models to the server?
>