Reporting Services Error

Hi,

I created a report that pulls info from the ContractExtensionBase table,
ContractBase, and ContractDetailBase table.

The report runs fine under the System Admin Account however every other user
is unable to run it.

The error i get is:

"An error has occurred during report processing. (rsProcessingAborted)
Query exection failed for data set 'CRM'. (rsErrorExecutingCommand)
Select permission denied on object...."

I tried playing around with the permissions on other roles but still get the
same error.

I have created reports before and never had this problem.

Anyone have a similar problem?

Scott
Thu Aug 30 21:06:04 PDT 2007

On Aug 30, 5:52 pm, Arion <Ar...@discussions.microsoft.com> wrote:
> Hi,
>
> I created a report that pulls info from the ContractExtensionBase table,
> ContractBase, and ContractDetailBase table.
>
> The report runs fine under the System Admin Account however every other user
> is unable to run it.
>
> The error i get is:
>
> "An error has occurred during report processing. (rsProcessingAborted)
> Query exection failed for data set 'CRM'. (rsErrorExecutingCommand)
> Select permission denied on object...."
>
> I tried playing around with the permissions on other roles but still get the
> same error.
>
> I have created reports before and never had this problem.
>
> Anyone have a similar problem?

Try using the filteredcontract views instead.

Scott
www.easiintl.com

Matt
Fri Aug 31 07:38:39 PDT 2007

You should not report directly against the tables in the DB. CRM users, by
default, do not have select access tot he tables themselves. Reports should
be directed against the Filtered* views which will enforce the row level
security of the app.

--

Matt Parks
MVP - Microsoft CRM


"Arion" <Arion@discussions.microsoft.com> wrote in message
news:1DC93914-4C38-4785-A6A6-49880EDE69A7@microsoft.com...
Hi,

I created a report that pulls info from the ContractExtensionBase table,
ContractBase, and ContractDetailBase table.

The report runs fine under the System Admin Account however every other user
is unable to run it.

The error i get is:

"An error has occurred during report processing. (rsProcessingAborted)
Query exection failed for data set 'CRM'. (rsErrorExecutingCommand)
Select permission denied on object...."

I tried playing around with the permissions on other roles but still get the
same error.

I have created reports before and never had this problem.

Anyone have a similar problem?