Is there any way to keep the SP's and other DB objects that Reports use; =
inside the Solution?

This way a developer; when he opens a specific solution has all the =
related objects that the reports need. Or do most folks manage the DB =
objects outside BIDS?

Still not even clear how most people are managing their solutions when =
they have say 200 reports. Do they stuff all the reports inside one =

[quoted text, click to view]

We do a few things.
First, we have a separate database that contains VIEWS and stored
procedures/functions only. The data is stored on other databases so
that we're not accessing it directly. The only tables we have are
mapping tables used to fill the drop down menus (for example).
Second, we have multiple solutions according to the individual parts
of the business and they're all stored in sourcesafe in separate
projects there also. Sometimes there is a "gray line" when a report
seems that it can go into different folders, but that's not a
problem. We have maybe 100 reports or something and over 100 views.
It's not too complicated to manage, sometimes it does get tedious I'll
admit. Also, you can use Sql Server Management Studio to organize the
reports on the server, as opposed to using the Report Manager
interface. Sometimes it's a bit easier.
The last thing we do is we make a "Help" file for each report that
indicates what views/procedures/functions the report uses. It also
has information about the report which the user can read, so it has a
dual purpose.

Hope that helps!

Take a look at Visual Studio Team Edition for Database Professionals.
http://msdn2.microsoft.com/en-gb/teamsystem/aa718807.aspx

And don't post HTML!!!

[quoted text, click to view]
Is there any way to keep the SP's and other DB objects that Reports use;
inside the Solution?

This way a developer; when he opens a specific solution has all the related
objects that the reports need. Or do most folks manage the DB objects
outside BIDS?

Still not even clear how most people are managing their solutions when they
have say 200 reports. Do they stuff all the reports inside one huge
solution or what?