Passing parameters to SSRS from MS Dynamics CRM 2011 and Sub reports

  • Hi All thanks in advance for any answers to my problem

    We are trying to setup a report in CRM for client data with a few sub reports for that client eg below

    Main reports has the client name and address ect

    Sub report 1 has count of contacts for that client

    Sub report 2 number of calls with outcome ect

    Quite simple so I thought

    I added a parameter to the main report for clientID and passed that down to the sub reports as the report is to be run for one client at a time and it works fine in SSRS web server page ie http://ourserver/Reports/Pages/Folder.aspx?ViewMode=Detail

    When we upload it into MS Dynamics CRM 2011 the report will not work I have tried the pre filter CRMAF_ and the CRM_Filtered<entity> options but I still can’t get it working has anyone got an idea how I can get this working in CRM seeing as they are both MS products you would think this would be easy how wrong could I be VERY wrong been looking for a solution to this on and off for a week now

    Kind regards

    Simon

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply