Filtered Views returning no values - MSCRM RRS feed

  • Question

  • 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?



    Friday, May 28, 2010 2:29 PM


  • 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 Hussain | http://hassanhussain.wordpress.com/ | http://www.mscrmvirtualusergroup.com/
    Sunday, May 30, 2010 7:37 AM