knowledgecenter-breadcrum

Knowledge Center

10 Nov, 2020

How to convert SSRS report in word format using JavaScript?

Posted on 10 Nov, 2020 by Admin, Posted in Dynamics 365 Dynamics-365 Sales

How to convert SSRS report in word format using JavaScript? Blogs

How to convert SSRS report in word format using JavaScript?

Introduction

In this blog, I am going to explain how we can export SSRS reports as Word Document. To know how we can execute SSRS reports, you can refer below blog:

https://themscrmexpert.wordpress.com/2016/12/19/how-to-send-ssrs-report-as-a-pdf-in-email-in-dynamics-crm-online/

Solution

To get SSRS report in word format, first we need to execute SSRS report, you can refer above link to execute report. Then we will get the response in which we will get ReportSession and ControlID. We will need these report session and control id to generate word document version of SSRS report.

Now, create a query string to get word version of SSRS report as follows:

let queryString = [Organization URI] + "/Reserved.ReportViewerWebControl.axd?ReportSession=" + ReportSession + "&Culture=1033&CultureOverrides=True&UICulture=1033&UICultureOverrides=True&ReportStack=1&ControlID=" + ControlID + "&OpType=Export&FileName=public&ContentDisposition=OnlyHtmlInline&Format=DOCX";

Now, create request object that will be called to convert the response in DOCX base64 string:

function fnConvertReportToWord(queryString){
 var retrieveEntityReq = new XMLHttpRequest();
 retrieveEntityReq.open("GET", queryString, true);
 retrieveEntityReq.setRequestHeader("Accept", "*/*");
 retrieveEntityReq.responseType = "arraybuffer";
 retrieveEntityReq.onreadystatechange = function () { // This is the call-back function.
 if (retrieveEntityReq.readyState == 4 && retrieveEntityReq.status == 200) {
   var binary = "";
   var bytes = new Uint8Array(this.response);
   for (var i = 0; i < bytes xss=removed xss=removed xss=removed>[removed] + base64WordString;
   //open or download report in word format
   window.open(base64DataUrl);
 }
};
//This statement sends the request for execution asynchronously. Callback function will be called on completion of the request.
retrieveEntityReq.send();
}

You will get a data URL base64DataUrl of word version of SSRS report to print or download report in word format. You can use base64WordString to attach as an email attachments and send report as word document.

Comment

This is a Required Field

Loading

Recent Updates

Blogs
02 Jul, 2025

How to Show Icons in View Cells Based on Field Values in D365 CE

Introduction: In Dynamics 365, adding icons to view cells based on field values can make the interface more user-friendly and…

READ MORE
Blogs
01 Jul, 2025

Getting Started with Microsoft Access: Key Features and How to Use Them - Part 1

Getting Started with Microsoft Access: Key Features and How to Use Them Microsoft Access is a versatile and approachable database…

READ MORE
Thumbnail Image of ROI
Blogs
17 Jun, 2025

Maximizing ROI with Power Apps: The Role of Expert Consulting Services

Maximizing ROI with Power Apps: The Role of Expert Consulting Services Explore how skilled professionals can get you the best…

READ MORE