Adding New Folders to Report Server Project

I am building a reporting services project, that will eventually contain 100+
reports.
I would like to add subfolders to my Report Server project, to help with
organising them (Finance,Warehouse etc).
I frequently perform this task in standard VS projects (class libraries
etc), but I can't find an option to do this here.
Is this possible?You should be able to add new projects to your main solution, which will
create a new folder for each project.
Open your solution.
Right click on the Solution name in your Solution Explorer. Click on Add ->
New Project
Type a name and choose the location. It could be as a subfolder of your
solution, or as a new folder somewhere else.
I haven't figured out how to use Shared Data Sources from different sub
projects, but you can copy existing datasources failry easily between the
different projects, so that's not too much of a problem. And by doing it
like this, you can have datasources connecting to the same database with
different credentials in the same project structure, which is nice.
Kaisa M. Lindahl Lervik
"programmer_mike" <programmermike@.discussions.microsoft.com> wrote in
message news:E0499886-58C5-4F62-AE60-44A025FD2EDF@.microsoft.com...
>I am building a reporting services project, that will eventually contain
>100+
> reports.
> I would like to add subfolders to my Report Server project, to help with
> organising them (Finance,Warehouse etc).
> I frequently perform this task in standard VS projects (class libraries
> etc), but I can't find an option to do this here.
> Is this possible?|||I had considered this option, but I would prefer to add multiple folder to
just one project.
If I reference a second report server project, will I be able to pick up
referenced reports in the Navigation -> Jump to report option. (Similar to
the way in which you can search for referenced datasets in standard projects)
I am planning on having a lot of links between reports in my project, and
this is one of the reason why I wanted to avoid multiple projects.
Thank yo for your comments
"Kaisa M. Lindahl Lervik" wrote:
> You should be able to add new projects to your main solution, which will
> create a new folder for each project.
> Open your solution.
> Right click on the Solution name in your Solution Explorer. Click on Add ->
> New Project
> Type a name and choose the location. It could be as a subfolder of your
> solution, or as a new folder somewhere else.
> I haven't figured out how to use Shared Data Sources from different sub
> projects, but you can copy existing datasources failry easily between the
> different projects, so that's not too much of a problem. And by doing it
> like this, you can have datasources connecting to the same database with
> different credentials in the same project structure, which is nice.
> Kaisa M. Lindahl Lervik
>
> "programmer_mike" <programmermike@.discussions.microsoft.com> wrote in
> message news:E0499886-58C5-4F62-AE60-44A025FD2EDF@.microsoft.com...
> >I am building a reporting services project, that will eventually contain
> >100+
> > reports.
> > I would like to add subfolders to my Report Server project, to help with
> > organising them (Finance,Warehouse etc).
> > I frequently perform this task in standard VS projects (class libraries
> > etc), but I can't find an option to do this here.
> > Is this possible?
>
>|||You can use either jump to URL or with the jump to report you specify the
folder as well as the report name. However, you can only test the report
when deployed.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"programmer_mike" <programmermike@.discussions.microsoft.com> wrote in
message news:EFB1314B-6747-4A16-9A74-280662C68EC9@.microsoft.com...
>I had considered this option, but I would prefer to add multiple folder to
> just one project.
> If I reference a second report server project, will I be able to pick up
> referenced reports in the Navigation -> Jump to report option. (Similar to
> the way in which you can search for referenced datasets in standard
> projects)
> I am planning on having a lot of links between reports in my project, and
> this is one of the reason why I wanted to avoid multiple projects.
> Thank yo for your comments
> "Kaisa M. Lindahl Lervik" wrote:
>> You should be able to add new projects to your main solution, which will
>> create a new folder for each project.
>> Open your solution.
>> Right click on the Solution name in your Solution Explorer. Click on
>> Add ->
>> New Project
>> Type a name and choose the location. It could be as a subfolder of your
>> solution, or as a new folder somewhere else.
>> I haven't figured out how to use Shared Data Sources from different sub
>> projects, but you can copy existing datasources failry easily between the
>> different projects, so that's not too much of a problem. And by doing it
>> like this, you can have datasources connecting to the same database with
>> different credentials in the same project structure, which is nice.
>> Kaisa M. Lindahl Lervik
>>
>> "programmer_mike" <programmermike@.discussions.microsoft.com> wrote in
>> message news:E0499886-58C5-4F62-AE60-44A025FD2EDF@.microsoft.com...
>> >I am building a reporting services project, that will eventually contain
>> >100+
>> > reports.
>> > I would like to add subfolders to my Report Server project, to help
>> > with
>> > organising them (Finance,Warehouse etc).
>> > I frequently perform this task in standard VS projects (class libraries
>> > etc), but I can't find an option to do this here.
>> > Is this possible?
>>|||By test the report I meant test the link.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"programmer_mike" <programmermike@.discussions.microsoft.com> wrote in
message news:EFB1314B-6747-4A16-9A74-280662C68EC9@.microsoft.com...
>I had considered this option, but I would prefer to add multiple folder to
> just one project.
> If I reference a second report server project, will I be able to pick up
> referenced reports in the Navigation -> Jump to report option. (Similar to
> the way in which you can search for referenced datasets in standard
> projects)
> I am planning on having a lot of links between reports in my project, and
> this is one of the reason why I wanted to avoid multiple projects.
> Thank yo for your comments
> "Kaisa M. Lindahl Lervik" wrote:
>> You should be able to add new projects to your main solution, which will
>> create a new folder for each project.
>> Open your solution.
>> Right click on the Solution name in your Solution Explorer. Click on
>> Add ->
>> New Project
>> Type a name and choose the location. It could be as a subfolder of your
>> solution, or as a new folder somewhere else.
>> I haven't figured out how to use Shared Data Sources from different sub
>> projects, but you can copy existing datasources failry easily between the
>> different projects, so that's not too much of a problem. And by doing it
>> like this, you can have datasources connecting to the same database with
>> different credentials in the same project structure, which is nice.
>> Kaisa M. Lindahl Lervik
>>
>> "programmer_mike" <programmermike@.discussions.microsoft.com> wrote in
>> message news:E0499886-58C5-4F62-AE60-44A025FD2EDF@.microsoft.com...
>> >I am building a reporting services project, that will eventually contain
>> >100+
>> > reports.
>> > I would like to add subfolders to my Report Server project, to help
>> > with
>> > organising them (Finance,Warehouse etc).
>> > I frequently perform this task in standard VS projects (class libraries
>> > etc), but I can't find an option to do this here.
>> > Is this possible?
>>

Adding folders under the solution

In RS, can one add a folder under the Reports folder? I don't see where I can do this. We work with many different state's and we would like to organize reports by state.

Thanks for the information.

hi,

Yes, you can. You can do it on the Report Server website (eg: http://reporservername/reports) clicking on the new folder. Then you can set up explicit security on it, if you do not want to have the inherited.

Also you can set up in the VS2005 SSRS project the destination folder in the project properties. It used when you deploy reports in a project. If the folder does not exist, it will create it and inherits the permission from the parent.

Regards,

Janos

|||

What I guess I was hoping to be able to do is to right click in the solution and Add a folder, like I can in a web project. We also use Source Safe and would like a similar directory structure there too. We would like to create one solution with the reports, however each report might vary because of different state requirements. From there, we would like a directory structure of Reports/StateName/thisreport.rdl.

Each state then get a copy of their own reports when the program as a whole is delivered to them. They have no need to see other state reports.

We are trying not to create a new Solution for each state because there are reports that are generic and can be created just once.

|||

You can create your folder structure in a solution. Each folder must have its own project below the solution.

eg.> I'd like a folder structure like this:

\

--US

|

-CA

-WA

Then I create an SSRS solution, then I add 3 projects. 1st project property page set the TargetReportFolder to /US, 2nd /US/CA, 3rd /US/WA.... etc.

I hope it helps.

regrads,

Janos

|||I'm also trying to create a folder structure inside the report project itself, to no avail. I think what guyinkalamazoo3 was really going for is the ability to create folders inside the single report project to keep things organized, without having to add a separate report project for each different state, i.e.:

ReportProject
-Reports (Root directory)
--California (Subdirectory)
--Washington (Subdirectory)

It seems odd that you can add folders to organize your project with any other project type, but you can't organize your reports this way. Was this missed in development of SSRS, or is it just another "feature"?

Adding folders in the solution explorer?

Hi..
Isn′t it possible to create sub folders in the solution explorer?
I have it hard time to create a decent structure inside the SSIS Package folder, since I have like 30 packages in my project. Is it just me being silly or cannot this be done?
Have a nice day
/Erik

nope...

You can add folders to a solution but withing a project, everything is either in packages of misc.

|||ok, thanks for the input though