Saving report files to database

[Seckin Karabacakoglu]

Hi

Is it possible to store and use report design files (rdl files) in database instead of file system?

Thanks a lot. 

[Arumugasami Murugesan]

Hi Seckin Karabacakoglu,

Thanks for the update,

You have to add the external server option with the API to save the report in your application or the database. Please find the sample below, 

Sample:  https://www.syncfusion.com/downloads/support/directtrac/general/ze/BoldReportsCore236484395.zip

In Server side: (ExternalReportServer.cs)

Using the GetReport method you can open your report from your application. 

If you want to open from your server. Please modify the below method as per your requirement. 

public override System.IO.Stream GetReport() 

        { 

            string reportPath = Path.Combine(this.reportResourcePath, this.ReportPath.TrimStart('\\').TrimStart('/')); 

  

            if (!reportPath.Contains(".rdl")) 

            { 

                reportPath = reportPath + ".rdl"; 

            } 

  

            if (File.Exists(reportPath)) 

            { 

                return this.ReadFiles(reportPath); 

            } 

  

            return null; 

        } 

 In the provided sample the report will be saved in our application location. If you want to save the report in database means, then you can modify the below method as per your requirement. 

        public override bool CreateReport(string reportName, string folderName, byte[] reportdata, out string exception) 

        { 

            exception = null; 

            reportName = reportName.TrimStart('\\').TrimStart('/'); 

  

            if (!Path.HasExtension(reportName)) 

            { 

                reportName += ".rdl"; 

            } 

  

            string reportPath = Path.Combine(this.reportResourcePath, reportName); 

            File.WriteAllBytes(reportPath, reportdata.ToArray()); 

  

            return true; 

        } 

 

Note: If this post is helpful, please consider Accepting it as the solution so that other members can locate it more quickly.

Regards,

Arumugasami M