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)
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
Please refer this alexmscrm.blogspot.my/.../how-to-show-report-in-entity-form-and.html
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156