Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

CRM 2016 Report: rsParameterError

Posted on by Microsoft Employee

Hi All,

Am facing a Reporting error in CRM 2016 Report.

I have a report and am passing an parameter to the report.

Please find the report parameter details:

Parameter name: accnum

Parameter Properties: Unchecked for ( Allow null values, Allow blank values, Allow multiple values)

Its an internal parameter visibility. Not passing any values from the query to the parameter.

When I run this in visual studio I got an error stating 'The accnum is missing a value' which is right because am not passing values to parameter from the query. but am getting value from the field (Accnum) through javascript.

Please find the below script where am getting the value for the parameter and calling the report in an entity using Iframe.

var Accnum= Xrm.Page.getAttribute("new_accnum").getValue(); 

var formType = Xrm.Page.ui.getFormType();

if (formType != 1 && Accnum!= null) {  

Xrm.Page.getControl("IFRAME_Attendance").setSrc("/crmreports/viewer/viewer.aspx?action=run&helpID=XYZ_Report_Card.rdl&id=%7b92B8197F-85C6-E611-80D5-005056923E9C%7d&p:Accnum=" + Accnum);

}else {

Xrm.Page.getControl("IFRAME_Attendance").setSrc("/crmreports/viewer/viewer.aspx?action=run&helpID=XYZ_Report_Card.rdl&id=%7b92B8197F-85C6-E611-80D5-005056923E9C%7d&p:Accnum=" + Accnum);

 }

}

But when I upload this rdl in CRM and run the report its giving me below error in the screenshot (rsParameterError)

Reporting-error.png

The same rdl file is running in Test environment but not running in Production environment after changing the connection string to Production.

Tried below ways:

Created a new Report in CRM and uploaded the existing rdl file and pointed the new report guid in JavaScript.

But still facing same issue.

Can anyone help me on this ?

*This post is locked for comments

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    RE: CRM 2016 Report: rsParameterError

    Please refer this alexmscrm.blogspot.my/.../how-to-show-report-in-entity-form-and.html

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans