Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / D365 CE v9 on Prem SSR...
Customer experience | Sales, Customer Insights,...
Answered

D365 CE v9 on Prem SSRS Parameter Issue

(0) ShareShare
ReportReport
Posted on by RugerSR762 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?

  • Verified answer
    RugerSR762 Profile Picture
    RugerSR762 375 on at
    RE: D365 CE v9 on Prem SSRS Parameter Issue

    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.

  • a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: D365 CE v9 on Prem SSRS Parameter Issue

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

  • RugerSR762 Profile Picture
    RugerSR762 375 on at
    RE: D365 CE v9 on Prem SSRS Parameter Issue

    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.

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,325 Most Valuable Professional on at
    RE: D365 CE v9 on Prem SSRS Parameter Issue

    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
    RugerSR762 375 on at
    RE: D365 CE v9 on Prem SSRS Parameter Issue

    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.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans