Convert .rdl file saved in document library to pdf and save

Question

Hi All, I have scenario where i have 2 document Library say A and B what i want is 1. I have abc.rdl file into Document Library A 2. I want to save the above document library as abc.pdf into Document Library B. Is this possible, (No C# code.recommended by the client) Would like to use only javascript/Jquery. Any suggestion and help.

Manas Mohapatra · Answer

You need to add the report parameters and report sources as per your need. Follow below code: Byte[] reportData; //Load report definition stream into report viewer LocalReport report = new LocalReport(); string path = "path of rdl file" ; if (!File.Exists(path)) { throw new System.IO.FileLoadException( "could not find the file to load it" ); } try { report.ReportPath = path; report.EnableExternalImages = true ; var reportParameters = reportObject.GetReportParameters(); ReportParameter reportParameter = new ReportParameter(); foreach (var item in reportParameters.Keys) { dynamic parameterData = reportParameters[item]; reportParameter = new ReportParameter(item.ToString(), parameterData); report.SetParameters(reportParameter); } //Fetch data sources , iterating through data sources of the report template and assign to the report template data sources. var reportSources = reportObject.GetReportDatasources(); ReportDataSource rds = new ReportDataSource(); foreach (var data in reportSources.Keys) { rds = new ReportDataSource(); rds.Name = data.ToString(); rds.Value = (IEnumerable)reportSources[data]; report.DataSources.Add(rds); } //render the report data into byte array means pdf format reportData = report.Render( "PDF" ); using (FileStream fs = File.Create(@ "D:\SampleReport" + ".pdf" )) { fs.Write(reportData, 0, reportData.Length); } } catch (Exception ex) { // Log it... }

Nanddeep Nachan · Answer

Is there a possibility to use MS Flow in your work? If so, it is an good out of box option.

Shraddha · Answer

Thankyou Manas for the response, but is this not possible using javascript/jquery, actually we can only use designer for coding purpose.