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

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.

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...
}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Nanddeep Nachan8y ago
Is there a possibility to use MS Flow in your work?
If so, it is an good out of box option.
Shraddha9y ago
Thankyou Manas for the response, but is this not possible using javascript/jquery, actually we can only use designer for coding purpose.
Manas Mohapatra9y ago
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...
}