How do I save crystal report to a specific disk path whilst using a dynamic filename

Question

0.00/5 (No votes)

See more:

I want to generate a Crystal Report such that on generation it exports to a folder on my application server. Additionally i want the report to also have a dynamic name. Currently the generated report is taking the name of the ActionResult as it s name and is being downloaded to Downloads folder.

I have amended the source but i have an exception whilst specifying these parameters "Cannot implicitly convert type void to 'System.I0.Stream'".

This is how im generating the Report after adding the parameters to the stream instance. The exception is also occuring on this line:

C#

public ActionResult AuditTrail()
      {

          SqlConnection con = new SqlConnection(Helpers.DatabaseConnect);
          DataTable dt = new DataTable();
          try
          {

              DateTime Today = DateTime.Today;
              var startdate = new DateTime(Today.Year, Today.Month, 1);
              var enddate = startdate.AddMonths(1).AddDays(-1);

              con.Open();
              SqlCommand cmd = new SqlCommand("SELECT Action,CreatedBy,CreatedOn,Entity,Username,Checker FROM Trail ", con);
              SqlDataAdapter adp = new SqlDataAdapter(cmd);
              adp.Fill(dt);

          }
          catch (Exception ex)
          {
              ViewBag.ErrorMessage = Helpers.Messages.GENERAL_ERROR;
              return View();
          }

          DateTime Todayy = DateTime.Today;
          var startdatte = new DateTime(Todayy.Year, Todayy.Month, 1);
          var enddatte = startdatte.AddMonths(1).AddDays(-1);

          string filename = "Trail";
          string OutputFileName = filename.ToString();

          //string fileName = System.IO.Path.GetTempPath() + Guid.NewGuid().ToString() + ".pdf";

          ReportClass rptH = new ReportClass();
          rptH.FileName = Server.MapPath(("~/Reports/") + "AuditTrail.rpt");
          rptH.Load();
          rptH.SetDataSource(dt);

          Stream stream = rptH.ExportToDisk(ExportFormatType.PortableDocFormat, @"C:\Users\myuser\source\repos\MyProject\MySolution\GeneratedReports\" + OutputFileName + "_" + enddatte + ".pdf");

          return File(stream, "application/pdf");
      }

What am i missing?

What I have tried:

I have attempted using CrystalDecisions.Shared.DiskFileDestinationOptions but im not sure how it can be used with Stream.

Posted 6-Jan-20 3:57am

Tshumore

Updated 7-Jan-20 2:26am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2020-01-06T04:22:00

Solution 1

If you look at the documentation at ReportDocument.ExportToDisk Method (CrystalDecisions.CrystalReports.Engine) | Microsoft Docs[^], you can clearly see that ExportToDisk does not return a stream object.

Posted 6-Jan-20 4:22am

Richard MacCutchan

Updated 6-Jan-20 4:23am

v2

Comments

Maciej Los 6-Jan-20 10:29am

Reading the documentation is the best way to resolve issue!

Richard MacCutchan 6-Jan-20 11:11am

Strange that so many 'developers' never think of doing it. :(

Tshumore 6-Jan-20 10:44am

Thanks guys, but is there something amiss in how im passing the parameters to stream

Richard MacCutchan 6-Jan-20 11:10am

Yes, please read my message again. The call to ExportToDisk does not return a stream object, so you cannot use it in the File constructor in the next line.

Tshumore · Answer 2 · 2020-01-07T02:27:00

This solved my issue-- I can generate, preview(in new browser window) and save to a specified server directory using a dynamic name

C#

public ActionResult AuditTrail()
       {
           string batch = string.Empty;
           batch = System.Web.HttpContext.Current.Session["BatchId"].ToString();

           SqlConnection con = new SqlConnection(Helpers.DatabaseConnect);
           DataTable dt = new DataTable();
           try
           {

               DateTime Today = DateTime.Today;
               var startdate = new DateTime(Today.Year, Today.Month, 1);
               var enddate = startdate.AddMonths(1).AddDays(-1);

               con.Open();
               SqlCommand cmd = new SqlCommand("SELECT Action,CreatedBy,CreatedOn,Entity,Username,Checker FROM Trail ", con);
               SqlDataAdapter adp = new SqlDataAdapter(cmd);
               adp.Fill(dt);

           }
           catch (Exception ex)
           {
               ViewBag.ErrorMessage = Helpers.Messages.GENERAL_ERROR;
               return View();
           }

           string OutputFileName = batch;

           //string fileName = System.IO.Path.GetTempPath() + Guid.NewGuid().ToString() + ".pdf";

           ReportClass rptH = new ReportClass();
           rptH.FileName = Server.MapPath(("~/Reports/") + "AuditTrail.rpt");
           rptH.Load();
           rptH.SetDataSource(dt);
           string filePath = Server.MapPath("~/GeneratedReports/") + OutputFileName + ".pdf";
           rptH.ExportToDisk(ExportFormatType.PortableDocFormat, filePath);
           Stream stream = rptH.ExportToStream(ExportFormatType.PortableDocFormat);

           return File(stream, "application/pdf");
       }

However im getting error 'The given path's format is not supported' when i try naming the file as i would want . ie using the BatchId and the current month-end date :

C#

string batch = string.Empty;
          batch = System.Web.HttpContext.Current.Session["BatchId"].ToString();
          DateTime Todayy = DateTime.Today;
          var startdatte = new DateTime(Todayy.Year, Todayy.Month, 1);
          var enddatte = startdatte.AddMonths(1).AddDays(-1);
          var monthend = enddatte.ToString();
          string OutputFileName = batch + " " + monthend;
          string filePath = Server.MapPath("~/GeneratedFolder/") + OutputFileName + ".pdf";
          rptH.ExportToDisk(ExportFormatType.PortableDocFormat, filePath);