Managing solutions, projects and reports in BIDS

Using SSRS 2005 - how do you organize your files/projects/reports/solutions?

Am I missing something, as I would like the solution view to mimic the 'deployed' view

So for example if I have my report server looking like this, where bold indicates a folder

--> Accounting
-----> Accounts Payable
---------> Report1
---------> Report2
-----> Accounts Receivable
---------> Report3
--> Sales
-----> Report4
-----> Report5

then I have 3 projects in my solution

  • Accounts Payable, with a TargetReportFolder of 'Accounting/Accounts Payable', and 2 reports

  • Accounts Receivable, with a TargetReportFolder of 'Accounting/Accounts Receivable', and 1 report

  • Sales, with a TargetReportFolder of 'Sales', and 2 reports

BUT I would like, somehow, to see this in solution explorer in SSRS in the same tree view as I get when it's deployed.

Now I know that there is a disconnect here between what's in BIDS and what gets deployed, but wouldn't that be useful?

more ▼

asked Sep 20, 2010 at 04:38 AM in Default

avatar image

Kev Riley ♦♦
66.8k 48 65 81

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

Hello I think this question is similar to the question that was asked before, Please refer to the link given below. http://ask.sqlservercentral.com/questions/3278/deploy-ssrs-reports-to-folders-within-a-report-server

Thank you

more ▼

answered Sep 21, 2010 at 11:21 AM

avatar image

V Padmala
83 2 3 6

No - that question is about how to utilise folders in the report server structure. I want to mimic that in BIDS.

Oct 14, 2010 at 07:01 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left

Due to the way Solutions have Projects as 'child' objects but they then dont have child objects of their own then you are going to be find they wont match. The best you can do is a project per directory (at whatever level on your RS server).

Do you know anyone who could write a IDE that could nest the projects in the way you need it?

One way to make it all work would be to make sure your report server never has nested folders. That way every folder on the server will equate to a project and then the reports will be inside - simples!

more ▼

answered Oct 14, 2010 at 07:50 AM

avatar image

Fatherjack ♦♦
43.8k 79 101 118

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 20, 2010 at 04:38 AM

Seen: 2159 times

Last Updated: Sep 20, 2010 at 04:38 AM

Copyright 2018 Redgate Software. Privacy Policy