web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

D365 CE v9 on Prem SSRS Parameter Issue

(0) ShareShare
ReportReport
Posted on by 375

OK I have been at this for 4 hours and cannot figure out how to get parameters to work, nor can I find helpful docs. I am trying to build a report which runs ONLY on the current record.  

I am familiar with CRMAF_.  That is not working as CRM will not accept the report. When uploading the report, I receive an error which states the defined number of parameters do not equal the cell definitions.

When using WHERE columnname = (@attribute), I cannot figure out how to pass the current record GUID to this parameter. When I manually enter the GUID it works... however users obviously are not going to do that.  Could someone please shed some light on how to automatically pass the current record guid through to the parameter so that the report will run without having to manually specify a value?

I have the same question (0)
  • RugerSR762 Profile Picture
    375 on at

    OK so now there is definitely an issue here.  I used the most generic query example from the online docs:

    docs.microsoft.com/.../dn531099(v=crm.8)

    SELECT name

    FROM FilteredAccount AS CRMAF_FilteredAccount

    After building the report in VS2019, I attempted to upload to CE and it failed with this error:

    "The number of defined parameters is not equal to the number of cell definitions in the parameter panel."

    So, could someone please translate this for me?  There is one column one parameter... I am totally confused here.

  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Hello,

    Search engines do the work here:

    stackoverflow.com/.../ssrs-file-error-message-the-number-of-defined-parameters-is-not-equal-to-the-nu

  • RugerSR762 Profile Picture
    375 on at

    Thanks but I did see that yesterday.  Still unclear as to why this is all of the sudden a problem when previously was able to upload reports using CRMAF.

  • a33ik Profile Picture
    84,331 Most Valuable Professional on at

    I don't think that this is related to CRMAF thing. What version of VS/SSDT do you use to edit reports?

  • Verified answer
    RugerSR762 Profile Picture
    375 on at

    Thanks for following up, Andrew.  I just got it working.  It turns out that there were two missing components: 1) needed a separate dataset for the parameter and 2) had to change the target version to support 2014.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 73 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 43 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans