Report Organization

I am taking over a RS solution from an ex employee and looking for some
report organization help.
I see you can have a shared datasource with RS.
In the solution there are about 20 projects. Each project contains reports
that are displayed in a folder seen off Report Manager. Is this the proper
way to organize reports -- through projects? Is there a way to have
IIS/Report Manager folder structure to appear in the solution explorer?
Or do you have to create the structure manually? Any help would be
appreciated.
Thanks.Yes very much the right way for you to maintain is using "Projects", moreover
I suggest you can add one more thing as well. i.e. Source control like VSS
integration so that all your reports are very well managed. Regarding your
2nd question it is a "No".
Amarnath
"Brian Shannon" wrote:
> I am taking over a RS solution from an ex employee and looking for some
> report organization help.
> I see you can have a shared datasource with RS.
> In the solution there are about 20 projects. Each project contains reports
> that are displayed in a folder seen off Report Manager. Is this the proper
> way to organize reports -- through projects? Is there a way to have
> IIS/Report Manager folder structure to appear in the solution explorer?
> Or do you have to create the structure manually? Any help would be
> appreciated.
> Thanks.
>
>

Report Model and Security Filter

I have a single database which will be shared by many customers.
So the idea was to design a "Report Model" and use Security Filters to make
sure that customers only see data belonging to them. Each tabel has a field
called ClientID.
How can one design a single report model which asures that each customer
only sees those records, belonging to him.
br, MichaelMaybe I shoul be more specific:
Is the concept of security filters the right way to go?
Is it better to design a special Report Model for each customer, where the
entities are based on queries?
thx, for any help
"Michael Schwabl" wrote:
> I have a single database which will be shared by many customers.
> So the idea was to design a "Report Model" and use Security Filters to make
> sure that customers only see data belonging to them. Each tabel has a field
> called ClientID.
> How can one design a single report model which asures that each customer
> only sees those records, belonging to him.
> br, Michael
>

Report looking at wrong (old) data source

Hi,
I've changed some reports to use a different data source. To do so I
created a new shared data souce called ReportsTest, and changed the
data source for some reports to now point to ReportsTest instead of
the original Reports data source. However I am getting the following
error.
An error has occurred during report processing. (rsProcessingAborted)
Get Online Help
Cannot create a connection to data source 'Reports'.
(rsErrorOpeningConnection) Get Online Help
SQL Server does not exist or access denied.
It's as if the report is still trying to use the original data source
for some reason' It still exists, but I want this report to use the
other data source that I've created. Why is this happening and how
can I fix it'Sorry, just hoping to get some feedback on this. If a report has to
use a particular data source does this data source have to be created
in the report designer and linked to the report here?
Is the name of the data source used by a report hardcoded into the
.rdl file of a report somehow, and not able to be changed in the
report manager'
gearoid_healy@.yahoo.com (Gearoid) wrote in message news:<3d6ebe80.0411050413.1fc8bcfb@.posting.google.com>...
> Hi,
> I've changed some reports to use a different data source. To do so I
> created a new shared data souce called ReportsTest, and changed the
> data source for some reports to now point to ReportsTest instead of
> the original Reports data source. However I am getting the following
> error.
>
> An error has occurred during report processing. (rsProcessingAborted)
> Get Online Help
> Cannot create a connection to data source 'Reports'.
> (rsErrorOpeningConnection) Get Online Help
> SQL Server does not exist or access denied.
>
> It's as if the report is still trying to use the original data source
> for some reason' It still exists, but I want this report to use the
> other data source that I've created. Why is this happening and how
> can I fix it'