error running Custom SSRS report from CRM when Prefiltering Incident(Case) entity RRS feed

  • Question

  • Hi all,

    I need to pre filter my SSRS custom report when running it from CRM fro incident(Case) records

    In my report:

        - My Data Source is SQL

        - My Sql statement is :

           Select incidentid from FilteredIncident as CRMAF_FilteredIncident

         - In the report 

               In my report I only have a list and Inside the list I have incidentid field.

    When I upload this  report in CRM  and Set it to run from the incident entity, I get the following error

       The are some clauses that have errors in them remove them and try again

    This is strange. It should work according to all the blogs I read . Can you guys help me please? I am not sure what I am doing wrong

    I have the same issue with Account entity but when I do this for my custom entity named new_risk

    Select new_riskid from Filterednew_risk as CRMAF_Filterednew_risk it works fine.

    Any help would be much appreciated.



    Tuesday, November 18, 2014 1:13 AM

All replies