Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying to subfolders from VS

I've got a report project with a few reports in I want in the root target directory. I also want to create several folders and put reports in those. The problem is I don't see any way to create a report folder in VS. I also don't see any way to pick the deployment path of a single reprot in VS. This makes me think I'll have to create a different Report Project in VS for each folder!! (this sucks). Does anyone have an idea or suggestion here?

Sorry, creating subfolder hierarchies directly from within a VS report project is currently not supported.

The closest you can get is to write a little application using the RS SOAP API to deploy your reports - you will then have full control over the folder hierarchy.

-- Robert

|||

This is highly unfortunate.

It makes deploying reports a real pain
because of the manual nature of having
to organize and overwrite older reports
(after deployment) that are existing in
sub-folders.

Can anyone provide some sources on
where to get started if one were to try
to write a custom deployment app?

|||

This link is to a tool that will give you some insight on how to deploy reports programmatically. It is not an automated process itself, but will give you an idea how it could be done.

http://www.sqldbatips.com/showarticle.asp?ID=62

I am creating a C# application that will use a small database for deployment data. With 3K+ remote servers, we have the same issue.

I originally thought I would use a method described elsewhere in the forum where you always deploy to one hidden folder and link all of your reports to their visible spots. I am not yet sure of the ramifications of that yet. If anyone has done deployments in this method, please let me know.

R

|||

Well, if you have any linked reports with landscape orientation, they will, more than likely, insist on printing portrait. Just something to consider. Another thread covers this:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=137986&SiteID=1

Even with the small glitches, SRS is a pleasure to work with.

|||So far the easiest way I've found to deal with this problem is to simply deploy all the reports in a project to the report server in a single place. Then, using the sql server management studio I can create folders and move reports into the proper location. It is not the best solution, but it works. It is a real hassle when updating reports. I just don't understand why microsoft did not make it possible to have report folders inside of visual studio. It would have taken an extra 10 minutes to program!
|||I agreed! Logical grouping is the most fundamental user function that you can find in all other MS or non MS products, but why not this one? We have 100+ reports, this has forced me to use some sort of special naming convention (Initiative - Category - subcategory - report name) for report name so that it's easier for me to find the reports in a flat list! Painful is to say the least...

Deploying SQL Express Throughout the Organization/Enterprise

What are some recommended methods for deploying SQL Express throughout an entire organization? It appears that Active Directory/GPO deployment is out of the equation.

Thanks,

Shane

hi Shane,

as SQLExpress is SQL Server, and as SQL Server is a service potentially serving lot's of user, SQLExpress is usually installed on a machine available through the whole lan.. all the clients connect to that instance and it answers to all the incoming requests... this is the "traditional" scenario of an enterprise wide database server...

what is your "problem"?

regards

|||

In our case SQL Express needs to be deployed to each PC because the product is used connected and disconnected to the network. Is there a documented or recommended method of deploying SQL Express to each PC?

Thanks,

Shane

|||

hi Shane,

a nice article has been written by Robert Walters including ClickOnce as well..

regards

|||

Andrea,

Thanks for the information. I have seen that article before and it is very good. We are using the ClickOnce bootstrapper but not actually using ClickOnce itself. What I am really looking for is recommendations on pushing SQL Express to PCs in an organization. Active Directory/GPO is commonly used for Windows Installer installations and while SQL Express is a Windows Installer installation under the hood it doesn't appear it would be practical and possibly not even possible to push it out this way. Is this a valid assessment? There are other electronic software delivery tools out there like SMS that may do the job, but we don't have experience with those tools. Would these tools be appropraite for pushing out SQL Express? Has anyone tried this successfully?

Thanks,

Shane

Deploying SQL Express 2005

Hello,
I work for a company that manages computers and their software using Active Directory. One of our packages requires SQL Express 2005, and so far I've been unable to find a good resource online. All I need to do is find a .msi file or a batch script that will install it. Thanks!

Start here http://msdn.microsoft.com/vstudio/express/

Deploying report to multiple locations

We would like to be able to publish a report to more than 1 directory at the
same time. Is this or would this be possible? Currently, we deploy the base
report to a central location and create linked reports to all other locations.The benefit of using linked reports is that updating the report contents of
the original report will update the linked reports automatically. Note:
report parameters and data source settings won't get updated because they
are administrated separately for linked reports.
You may also want to check the following tool courtesy Jasper Smith (a SQL
Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
> We would like to be able to publish a report to more than 1 directory at
> the
> same time. Is this or would this be possible? Currently, we deploy the
> base
> report to a central location and create linked reports to all other
> locations.|||Thanks for the feedback. I was hoping you could answer one more thing.
Will it be possible to create a linked report, but have the ability to
select multiple locations at the same time? Rather than having to do each one
individually.
Thank you!
"Robert Bruckner [MSFT]" wrote:
> The benefit of using linked reports is that updating the report contents of
> the original report will update the linked reports automatically. Note:
> report parameters and data source settings won't get updated because they
> are administrated separately for linked reports.
> You may also want to check the following tool courtesy Jasper Smith (a SQL
> Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "clutch" <clutch@.discussions.microsoft.com> wrote in message
> news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
> > We would like to be able to publish a report to more than 1 directory at
> > the
> > same time. Is this or would this be possible? Currently, we deploy the
> > base
> > report to a central location and create linked reports to all other
> > locations.
>
>|||No, you can only create one linked report at a time in report manager. But
since creating a linked report is just a SOAP-call (look for
CreateLinkedReport in BOL), you could write a RSS script which creates
multiple linked reports in a sequence.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"clutch" <clutch@.discussions.microsoft.com> wrote in message
news:08A92FF1-5327-435D-9877-D6A0179F0866@.microsoft.com...
> Thanks for the feedback. I was hoping you could answer one more thing.
> Will it be possible to create a linked report, but have the ability to
> select multiple locations at the same time? Rather than having to do each
> one
> individually.
> Thank you!
> "Robert Bruckner [MSFT]" wrote:
>> The benefit of using linked reports is that updating the report contents
>> of
>> the original report will update the linked reports automatically. Note:
>> report parameters and data source settings won't get updated because they
>> are administrated separately for linked reports.
>> You may also want to check the following tool courtesy Jasper Smith (a
>> SQL
>> Server MVP): http://www.sqldbatips.com/showarticle.asp?ID=62
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "clutch" <clutch@.discussions.microsoft.com> wrote in message
>> news:C16C6284-800A-41C1-822F-6C5FD518B727@.microsoft.com...
>> > We would like to be able to publish a report to more than 1 directory
>> > at
>> > the
>> > same time. Is this or would this be possible? Currently, we deploy the
>> > base
>> > report to a central location and create linked reports to all other
>> > locations.
>>

Deployed Report

Hello,

When I run Build=> Deploy , where does the report go, I check Virtual Directory of ReportServer which is C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer in my case and I do not see any file related to my report.

Thanks,

It depends on the Target URL specified under project in VS.Net

Deploye the report server ( URGENT Plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz)

hi friends,

i was created the virtual directory ( http://yh861/REPORTSS)

when i click on the deploy i am getting the error

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://yh861/REPORTSS.

ADDITIONAL INFORMATION:

The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)

The request failed with HTTP status 404: Not Found. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

please help

How have you created the virtual directory?

Did you use the installer? Did you use the Reporting Services configuation tool?

Is IIS running and the default website started?

Can you create a test html file and browse to it using Internet explorer? (put it in c:\inetpub\wwwroot\test.html and browse using http://localhost/test.html)

|||Have you made this virtual directory an application (if you created it yourself)? You can't just make a virtual directory and expect it to run. It's probably best to use the installer.

Deploy SQL Server Management Studio

Hello,

I need to deploy Server Management Studio by Active directory and I will like to know where I can find the MSI do it. (I didn't find it on the CD)

Thank you for your help

There is no separate msi file for SQL Server 2005 Management Studio. Instead, SQL Server Management Studio is packed in SqlRun_Tools.msi under tools directory.