60
I am facing issue while downloading SQL based SSRS Reports from ribbon button, Its working fine when No parameters will added, but with parameters not worked. It may be because of missing the correct way to pass parameters, currently i'm downloading report using Javascript code. Please help ?
*This post is locked for comments
Hi Jasdeep, i use the logic below:
Share
Report
All responses (
Answers (
//INI
var retrieveEntityReq = new XMLHttpRequest();
var clientUrl = Xrm.Page.context.getClientUrl();
retrieveEntityReq.open("POST", clientUrl + "/CRMReports/rsviewer/reportviewer.aspx", false);
retrieveEntityReq.setRequestHeader("Accept", "*/*");
retrieveEntityReq.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
retrieveEntityReq.send("id=%7B" + reportId + "%7D&uniquename=" + Xrm.Page.context.getOrgUniqueName() + "&iscustomreport=true&reportnameonsrs=&reportName=" + reportName + "&isScheduledReport=false&p:ngdId=" + ngdId +"&p:Preview=" + preview);
//END
console.log('gerou report!');
//INI
var firstIndexOfReportSession = retrieveEntityReq.responseText.indexOf("ReportSession=");
var x = retrieveEntityReq.responseText.indexOf("ReportSession=", firstIndexOfReportSession + 3);
var reportSession = retrieveEntityReq.responseText.substr(x + 14, retrieveEntityReq.responseText.indexOf("&", x) - x - 14); //the session id
var firstIndexOfControlId = retrieveEntityReq.responseText.indexOf("ControlID=");
x = retrieveEntityReq.responseText.indexOf("ControlID=", firstIndexOfControlId + 3);
var controlId = retrieveEntityReq.responseText.substr(x + 10, retrieveEntityReq.responseText.indexOf("&", x) - x - 10); //the control id
//END
var fileName = escape(ngdId + " - " + customer + " - v.");
//Generate URL
var url = clientUrl +
"/Reserved.ReportViewerWebControl.axd?ReportSession=" +
reportSession +
"&Culture=1046&CultureOverrides=True&UICulture=1046&UICultureOverrides=True&ReportStack=1&ControlID=" +
controlId +
"&OpType=Export&FileName=" +
fileName +
"&ContentDisposition=OnlyHtmlInline&Format=PDF";
console.log(url);
//Report Download
window.location.assign(url);
You need to pass the parameters slightly differently depending on which approach you are using .
I did a blog about this along time ago - www.develop1.net/.../Embedding-CRM-reports-in-IFrames-using-the-CRM2011-Report-Viewer.aspx
Also see social.microsoft.com/.../passing-parameters-to-crm-reports-through-url
Hope this helps
What happens if you add parameters ? Do you get an error, or are the parameters ignored ?
Can you post an example of the request that you submit to download the report ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156