Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Passing parameters to SSRS from MS Dynamics CRM 2011 and Sub reports Expand / Collapse
Posted Thursday, July 11, 2013 9:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, November 9, 2016 2:15 AM
Points: 38, Visits: 315
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
Post #1472651
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse