Deployment Report Folder

Hi,

I would like to be able to deploy a report to a particular folder in the report server. It seems when I deploy a report it always shows up in the root even after I have moved it into another folder where I wish it to reside.

Thanks,

DD

You set the deployment path of reports (and datasources in 2005) using the project property pages.

Right click on the project (in solution explorer) - select "properties", then if you expand "configuration properties" in the left hand pane of the dialog and select "general"

You can now see the "target report folder" (and if using 2005 "target data source folder")

you can amend this as follows

if you want the following folder

root/adminReports/server

just put

"adminReports/server" in the "target report folder" textbox

|||Right, but that changes the deployment folder for the whole project. I don't seem to be able to change the reports individually. What would be sweet would be if you add folders to your solution and the deployment process puts the reports in the corresponding folders.|||

You have these options:

1) Create 1 solution per folder group that you require, set them to point at the folders you requires

2) Use configuration manager to create different deployment folders, deploy the reports individually once you've picked your target folder using config mgr

3) Use a tool like Reporting Services scripter to generate a deployment script, then edit this (and the winnt folder structure) accordingly - "find in folders" using vs.net is easy enough [http://www.sqldbatips.com/]

|||

Thanks for the valuable tips. I will check out that Linked Report tool.

I ended up creating a project for every folder.

Thanks,

DD

Deployment Of SSIS With Config Files

I went through other threads and links on this subject. Still one thing which concerns me is the config files.

My current folder path is C:\Karunakaran\folder1\folder2\

Under folder2 I have the following files

4 dtsx files
1 .database file
1 .dtproj file
1 .dtproj.user file
1 .sln file
1 .suo file

Config folder ( C:\Karunakaran\folder1\folder2\Config\)
common.dtsConfig
oracle.dtsConfig

Based on some of the threads, when I enabled package configuration, I changed the path from
C:\Karunakaran\folder1\folder2\Config\common.dtsconfig -> common.dtsconfig

Once I did this, when I open the project I get a dozen of warning similar to the one below

Warning loading <package1>.dtsx: Failed to load at least one of the configuration entries for the package. Check configurations entries and previous warnings to see descriptions of which configuration failed.

What am I doing wrong here? If I have to deploy this to another box, what should I do to ensure that nothing breaks once its copied / installed?

Thanks

wouldn't you need \config\common.dtsconfig ? (since it isn't in the root folder?)|||You should always use absolute paths. Always. With that said, the best way to make the path portable is to use environment variables to store the base path. Then you can use the environment variable in the package configurations dialog to specify where to store the file.|||

EWisdahl wrote:

wouldn't you need \config\common.dtsconfig ? (since it isn't in the root folder?)

I did tried that earlier, when I give \Config\Common.dtsConfig i was getting the following error.

ADDITIONAL INFORMATION:
Could not find a part of the path 'C:\Config\Common.dtsConfig'. (mscorlib)

Thanks

|||

Phil Brammer wrote:

the best way to make the path portable is to use environment variables to store the base path. Then you can use the environment variable in the package configurations dialog to specify where to store the file.

I dont think Sys Admin will allow the usage of environment variables, looks like absolute path is the only way for me.
Looks like Microsoft should do something about the config files issues.

Thanks|||I'm not sure there are any issues. Besides, you can always use SQL Server based configs.

Using relative paths has a whole host of problems, when considering, depending on where dtexec is executed from, the root path could be different that what you are expecting.|||

But this also does not give me flexibility of where I want to store my config file.
The other problem I have noticed is that I cannot use one single config file for all my packages, causing a maintanence issue.

I have not tried Sql Server based config, let me try it and see.

Thanks

|||You can use one config file for numerous packages. No problem.|||I prefer SQL Server configs, for exactly the reasons you are describing. The only catch I have found with them is setting the initial connection to the database that stores the configurations. I like using a single environment variable to store that connect string, but you can also use the connection switch of DTEXEC to set it.|||

Phil Brammer wrote:

You can use one config file for numerous packages. No problem.

I'm not able to.

I can do that, ONLY if all my packages have all the variables, connection managers defined in the config file, else it throws errors / warnings whenever I open up the package.

Thanks|||There have been a few posts on this recently. You can create all your connection managers in every package (if you don't use one in the package, it doesn't cause any problems) or you can set variables through the configuration, and set the connections based on expressions that use the variables.|||I going to try with both. But I think this looks more a work around.
I hope MS address this issue.

Thanks|||

Karunakaran wrote:

I going to try with both. But I think this looks more a work around.
I hope MS address this issue.

Thanks

No, I'd consider this "best practices."

If you feel, though, that this is a bug, then please post a submission on the Connect site: http://connect.microsoft.com/sqlserver/feedback

|||I'm not sure if this is a bug,but I'm sure this flexibility is required, especially if there are multiple packages, and when developer has no access to the prod env.

Thanks
|||

With regards to best practice:

I can't see how to use configuration in the case of branching using source control without manually changing the path for every branch.

And even worse if the files are checked out to different folders then the config will not work with an absolute path.

Storing configuration on the SQL server would also be difficult to use when using source control especially if you are working on local databases.

Do any of you have a good solution to using SSIS with source control and branching?

Deploying to a folder?

Is there any method to deploy a report to a folder under the project's
folder? I currently deploy new reports from within VS.NET and manually move
them to their correct folders using the "move" button on the
http://servername/reports/pages/folder.aspx?IsDetailsView=True web page. Is
there anyway to setup the sub folders in VS.NET?
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynchHello Jeff,
Based on my scope, there is no official method to change the subfolder
path. The catalog information is stored in catalog table in ReportServer
database.
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
| From: "Jeff Lynch" <jeff.lynch@.newsgroup.nospam>
| Subject: Deploying to a folder?
| Date: Mon, 18 Apr 2005 08:10:04 -0500
| Lines: 12
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
| X-RFC2646: Format=Flowed; Original
| Message-ID: <OlXjwfBRFHA.996@.TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: gateway.gulfcoastseal.com 65.212.192.66
| Path:
TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP0
9.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.reportingsvcs:47959
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Is there any method to deploy a report to a folder under the project's
| folder? I currently deploy new reports from within VS.NET and manually
move
| them to their correct folders using the "move" button on the
| http://servername/reports/pages/folder.aspx?IsDetailsView=True web page.
Is
| there anyway to setup the sub folders in VS.NET?
|
| --
| Jeff Lynch
| "A BizTalk Enthusiast"
| http://codebetter.com/blogs/jeff.lynch
|
|
|

Deploying Sub Reports

Just wondering what people do when they deploy sub reports and what is the 'best practise' for this. I'm just deploying them to the same folder as the main report and hiding them.

This is, to say the least, messy. As a user has to click 'Show Details' and they can see the sub report.

Is there a better way?

Thanks

Hi,

I'm doing also the same. Unfortunatelly, I do not know other solution than to hide the report in list view.

In this case, the communication is important to te report users, use just the main reports insted of using the subreports individually. Anyway, I do not see any problem, if they are able to recognize the subreports and run them.

regards,

Janos

|||Hi,

I agree with Janos. You don't need to do anything for sub-reports. In our application we do not give users direct access to reports, we have some customized pages which render these reports for these users. On these pages we present all criteria options and then using these we display our reports using "ReportViewer" control.

Zafar Iqbal|||

Hi

Thanks for the replys. I agree that there is no real problem with it. I just think it'd nicer to not have the sub reports in the same folder cluttering it up Maybe one day we'll implement a custom front end, for now I'm happy to leave the sub reports where they are and ignore them.

Cheers

|||

I had posted this issue some months ago on Connect.Microsoft... They have closed it saying it was fixed. So it will probably be available on next Service Pack or version.

It will allow folders in RS project.

You can check: http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=278068

Regards

Deploying reports to subfolders

How can I have different reports deploy to different subfolders? all of them
are currently going to same folder.
TIA
DeanThe easiest way is to put the reports in different projects. Each project
goes to a different folder. I have a solution with 8 projects (corresponding
to 8 folders).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:%23OFh7QMuHHA.1184@.TK2MSFTNGP04.phx.gbl...
> How can I have different reports deploy to different subfolders? all of
> them are currently going to same folder.
> TIA
> Dean
>

Deploying report with RS utility with different datasource folder

How does one specify a different data source folder path when deploying a
report to a report server (2005) using RS scripting? I started with the
PublishSampleReport.rss script sample from microsoft and need to publish a
report (i.e. rs.CreateReport... ) to the report server that references the
shared data source in a different folder than the default "/Data Sources"
(i.e. /ApplicationName/ReleaseName/Data Sources). Any ideas? You can
change in Visual Studio 2005 the TargetDataSourceFolder in the project
properties for deployment, but how do you do it in script?I think something like this should do the trick (it's worked for me):
Private Sub SetItemDataSources()
Dim Item As String = "/My Reports/MyReport"
Dim DataSources(0) As Microsoft.SqlServer.ReportingServices2005.DataSource
DataSources(0) = New Microsoft.SqlServer.ReportingServices2005.DataSource
DataSources(0).Name = "MyDataSource"
Dim Item1 As Microsoft.SqlServer.ReportingServices2005.DataSourceReference
= New Microsoft.SqlServer.ReportingServices2005.DataSourceReference
Item1.Reference = "/Data Sources/MyDataSource"
DataSources(0).Item = Item1
RS.SetItemDataSources(Item, DataSources)
End Sub
I find it pretty useful to use the "script" option in in SQL Server
Management Studio (connected to Reporting Services rather than the Database
Engine) when I want to see how to make a particular change using RS. That's
how I got the above example.
Regards.
"vnapoli" wrote:
> How does one specify a different data source folder path when deploying a
> report to a report server (2005) using RS scripting? I started with the
> PublishSampleReport.rss script sample from microsoft and need to publish a
> report (i.e. rs.CreateReport... ) to the report server that references the
> shared data source in a different folder than the default "/Data Sources"
> (i.e. /ApplicationName/ReleaseName/Data Sources). Any ideas? You can
> change in Visual Studio 2005 the TargetDataSourceFolder in the project
> properties for deployment, but how do you do it in script?
>
>

Deploying report into a folder

Hello,

I deploy my report through deploy command in the menu. If I create a folder in the report manager how can deploy my report into the folder?

Thanks,

Go to Project Prperties in that you have to type in the newly createdfolder name in the 'TargetFolder' also check the TargetServerURL.
This would solve your issue.

deploying - but where to?

Hi,
when I deploy a report - where does it go? As in, are each of the
individual reports sent to some folder somewhere, or are they bundled
into some dll or something? All I know is I've set my deploy location
to http://<machinename>/reportserver - but can't see the reports in
that folder...
Any ideas?
GearóidThey are being stored in the database used by RS. That is why you don't see
anything.
Bruce L-C
"Gearoid" <gearoid_healy@.yahoo.com> wrote in message
news:3d6ebe80.0409280203.3aaed82b@.posting.google.com...
> Hi,
> when I deploy a report - where does it go? As in, are each of the
> individual reports sent to some folder somewhere, or are they bundled
> into some dll or something? All I know is I've set my deploy location
> to http://<machinename>/reportserver - but can't see the reports in
> that folder...
> Any ideas?
> Gearóid

deploy reports directly into right folders

hi,
is it possible to deploy an report directly to a folder from the
business intellegence studio?
or can I only move reports via the Report Manager?
Thanks!Hi,
Create a folder in the Report Manager and specify the folder name and
target url in the project properties.
This automatically move the reports to the desired folder when u deploy
that report.
Thanks.
florian wrote:
> hi,
> is it possible to deploy an report directly to a folder from the
> business intellegence studio?
> or can I only move reports via the Report Manager?
> Thanks!|||but what if I have a project with several reports belonging to
different folders?
Sara schrieb:
> Hi,
> Create a folder in the Report Manager and specify the folder name and
> target url in the project properties.
> This automatically move the reports to the desired folder when u deploy
> that report.
> Thanks.
> florian wrote:
> > hi,
> >
> > is it possible to deploy an report directly to a folder from the
> > business intellegence studio?
> >
> > or can I only move reports via the Report Manager?
> >
> > Thanks!|||Yeah, that's what I want to know. I have the same thing, one project with 10
reports in it. 3 of the reports go in their own folder.
I guess you could argue that because the reports have their own folder in
the UI that they should have their own project. But then that raises the
issue of having to duplicate your shared data sources. As of yet I have not
found a way to share data sources across projects withing the same solution
in VS.Net 2003.
"florian" wrote:
> but what if I have a project with several reports belonging to
> different folders?
> Sara schrieb:
> > Hi,
> > Create a folder in the Report Manager and specify the folder name and
> > target url in the project properties.
> >
> > This automatically move the reports to the desired folder when u deploy
> > that report.
> >
> > Thanks.
> > florian wrote:
> > > hi,
> > >
> > > is it possible to deploy an report directly to a folder from the
> > > business intellegence studio?
> > >
> > > or can I only move reports via the Report Manager?
> > >
> > > Thanks!
>

Deploy Packages To Folder Other Than MSDB

Is it possible to create a folder within the MSDB folder in Integration Services and deploy packages in it?

When connected to Integration Services via Management Studio, you can right click on the MSDB folder and chose New Folder...|||See http://technet.microsoft.com/en-us/library/ms137916(SQL.90).aspx for more details.

Deploy Packages To Folder Other Than MSDB

Is it possible to create a folder within the MSDB folder in Integration Services and deploy packages in it?

When connected to Integration Services via Management Studio, you can right click on the MSDB folder and chose New Folder...|||See http://technet.microsoft.com/en-us/library/ms137916(SQL.90).aspx for more details.

Deploy Folder

How can I change the deployment folder in a Visual Studio Solution?. I
understood it is not possible to deploy to a different folders, is that
correct?. ThanksDo you mean:
Project menu --> properties --> targetfolder and targetserverURL
Mike G.
"Daniel" <Daniel@.discussions.microsoft.com> wrote in message
news:30941407-8AFF-4764-AFA3-B50D8A74E1C5@.microsoft.com...
> How can I change the deployment folder in a Visual Studio Solution?. I
> understood it is not possible to deploy to a different folders, is that
> correct?. Thanks