all groups > sql server reporting services > june 2006 >
You're in the

sql server reporting services

group:

Adding subfolders to to a project


Adding subfolders to to a project Galg
6/27/2006 5:25:08 AM
sql server reporting services: Can subfolders be added to a project?
i want a few folder like : dashboards, full reports , management
reports etc.
in each folder i would like to store only the relevanr .rdl files and
images used in the reports.
but i dont see an option to add a folder when i right click on the
project name.
the only options i get when right clicking is new report or new
dataset.

i know folders can be added on the report server itself using the
manager but then i have to manually move all the files i wish to use in
the report and the report itself, and the next time i deploy the
reports, the updated files wont automaticaly be put in the folders.

any ideas?

thanks,

Gal.
Re: Adding subfolders to to a project Kaisa M. Lindahl Lervik
6/28/2006 5:43:21 PM
In your report solution, you can have several projects.

In Visual Studio (2005), click on your Solution. CLick on File -> Add -> New
project
Choose Reporting Services project
Give your project a name, and make sure the location of it is in the same
folder as the solution. (You'll get a new folder in the solution folder for
your new project)
Click OK, and you now have a sub-project in your solution.
Save your solution to not loose the connections to the new project. (Click
on the Save All, not just Save)

You now have to create all the data sources in your new project. But they
are easy to copy, just copy from your main solution, and paste to the new
project. You have to paste to the project, not in the data sources folder,
as VS gets confused by this... You might have to check the credentials in
your data sources too, sometimes mine are blanked out when I do this.

Kaisa M. Lindahl Lervik


[quoted text, click to view]

Re: Adding subfolders to to a project gal granov
6/29/2006 8:42:02 AM
thanks,

but cant i use the same data source for all?
i want to make a logical sepration of types of reports... no need to created
the same data source a few times.



[quoted text, click to view]
AddThis Social Bookmark Button