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