SSRS Report - Blank Parameter Dropdown Values in App RRS feed

  • Question

  • I have a parameterized report that requires the user to select Opportunity Names, and passes Opportunity Ids into the query. The report works fine in BIDS, but when uploaded to CRM 2013, the parameter dropdown is blank. After further troubleshooting, this seems to be a problem with all reports that have a parameter dropdown that uses a dataset to populate selections (e.g. SELECT accountid, name FROM FilteredAccount). The client has an old 2011 instance we upgraded from, and we noticed that the issue is there too. We tried to run the report from multiple user accounts. The main one I'm running it from is a System Administrator. 

    Any ideas?

    Tuesday, April 15, 2014 2:46 PM

All replies

  • Raymond,

    IF the report works fine in BIDS but has such issues when uploaded to CRM then it would more likely be a problem with the data source. CRM Updates the data source when you upload a report. Check this in the Report Manager (report server). Use a shared data source when you are using multiple data sets in a report.

    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    • Proposed as answer by Mamatha Swamy Tuesday, April 15, 2014 10:18 PM
    Tuesday, April 15, 2014 10:17 PM