Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Filtered Views returning no values - MSCRM RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello,

    We are using SSRS 2005 to repport out of data coming from Microsoft CRM.

     

    I am using filtered views of the CRM tables to get the data for my reports.

    It was returning values properly. All of a sudden its retruning all null values. However the direct table query is reurting values, but the corresponding view is not. Could anyone suggest anything?

     

    Thanks

    Friday, May 28, 2010 2:29 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    Check the connection string for the report. The developer might have hard coded the connection string with possibly a user account instead of integrated security. The account used in the connection string might have recently been either disabled or its rights revoked. I have seen this happen before! Open the rdl file in notepad and look for the connection string. You should be able to spot the problem quite quickly.

     Good luck and let me know if this fixes the problem.

    Hassan.

     

    Hassan Hussain | http://hassanhussain.wordpress.com/ | http://www.mscrmvirtualusergroup.com/
    Sunday, May 30, 2010 7:37 AM