Showing posts with label subfolders. Show all posts
Showing posts with label subfolders. Show all posts

Tuesday, March 20, 2012

Adding subfolders to to a project

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.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
"Galg" <gal.granov@.gmail.com> wrote in message
news:1151411108.304933.276730@.y41g2000cwy.googlegroups.com...
> 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.
>|||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.
"Kaisa M. Lindahl Lervik" wrote:
> 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
>
> "Galg" <gal.granov@.gmail.com> wrote in message
> news:1151411108.304933.276730@.y41g2000cwy.googlegroups.com...
> > 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.
> >
>
>

Thursday, March 8, 2012

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?
>>