I have created one Report using SRS and i am getting correct data from the
query in the preview in Visual Studio .NET, but when i am trying to run the
report after deploying it in MS CRM 3.0 no data is coming in the report.
Any suggestions?

Thanks.

This almost cirtainly has to be a security role issue. If you create the
report using filtered views and are logged in as administrator and join a few
different views together to get your desired result, lets say:

1. You join the FilteredContact view with the FilteredAccount View.
2. You do this while logged in as administrator to the network which is also
an admin user to CRM.
3. It previews fine.
4. You deploy it out to CRM.
5. A user tries to run it from their machine and gets nothing.

Well, if the users security role doesn't have access to read accounts for
example, then no results would be returned if they are inner joined, because
the security is not there.

You "could" if you have it setup for Windows Auth and SQL auth, use the SA
username and password for your datasource instead of windows authentication,
but then you cannot use filtered views, and would have to join all the data
manually.

This is not recommended, but completely do-able.
--
John Klemetsrud


"BHARAT" wrote:

First check if your report has default filter. It screens data only when you
run report in CRM but NOT in VS. Remove all filters if possible.

Secondly check your privileges to access reported entities. You should have
Read privilege at least. Reports are queried on filtered views. If you don't
have privilege to read entity records, you won't see any data.

Lan
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"BHARAT" <BHARAT@discussions.microsoft.com> wrote in message
news:0261292F-8F9E-496E-A995-9E832F83D4C3@microsoft.com...