Skip to main content

Failed to export using the options you specified. Please check your options and try again.

#Solution:1
 in post back just set report loading event as follows btnViewReport_Click(null, null);



  protected void Page_Load(object sender, EventArgs e)  
     {  
       if (!IsPostBack == true)  
       {  
         LoadFactoryName();  
       }  
       else  
       {  
         // Your report viewing button event name  
         btnViewReport_Click(null, null);  
       }  
     }



#Solution:2
You are trying to export the crystal report in PDF or other format.  But it is not working in  VS2010 asp.net SAP crystal report. my this article is not solve the exception but you may can take a alternative way for the solution. you can export the the crystal report in pdf when the report load.

Consider the method it will just load the crystal report

  private void LoadDateRangeWiseAllItemDetails()  
     {  
       _secondarySales = new SecondarySales();  
       _secondarySaleses = new List<SecondarySales>();  
       _secondarySales.FromDate = Convert.ToDateTime(String.Format("{0}", Request.Form["startDate"]));  
       _secondarySales.ToDate = Convert.ToDateTime(String.Format("{0}", Request.Form["endDate"]));  
       _secondarySaleses = _secondarySalesObj.LoadDateRangeWiseAllItemDetails(_secondarySales);  
       ReportDocument details = new ReportDocument();  
       details.Load(Server.MapPath("../Report/secondarySalesItemDetailsCrystalReport.rpt"));  
       details.SetDataSource(_secondarySaleses);  
       secondarySalesCrystalReportViewer.ReportSource = details;  
     }

it will look like this:

 


if i want to load the report in PDF....then..?? then we can take a  another button name Download Pdf . click on this button it will load a pdf file to download. In this button event method we will use the previous method code + add the code for pdf.then the crystal report to PDF method will be look like :


  private void LoadDateRangeWiseAllItemDetails()  
     {  
       _secondarySales = new SecondarySales();  
       _secondarySaleses = new List<SecondarySales>();  
       _secondarySales.FromDate = Convert.ToDateTime(String.Format("{0}", Request.Form["startDate"]));  
       _secondarySales.ToDate = Convert.ToDateTime(String.Format("{0}", Request.Form["endDate"]));  
       _secondarySaleses = _secondarySalesObj.LoadDateRangeWiseAllItemDetails(_secondarySales);  
       ReportDocument details = new ReportDocument();  
       details.Load(Server.MapPath("../Report/secondarySalesItemDetailsCrystalReport.rpt"));  
       details.SetDataSource(_secondarySaleses);  
       secondarySalesCrystalReportViewer.ReportSource = details;  
       // for pdf  
       BinaryReader stream = new BinaryReader(details.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat));  
       Response.ClearContent();  
       Response.ClearHeaders();  
       Response.ContentType = "application/pdf";  
       Response.AddHeader("content-disposition", "attachment; filename=" + "pdfName");  
       Response.AddHeader("content-length", stream.BaseStream.Length.ToString());  
       Response.BinaryWrite(stream.ReadBytes(Convert.ToInt32(stream.BaseStream.Length)));  
       Response.Flush();  
       Response.Close();   
     }

Build and run the application you will get you report as pdf for download.



Enjoy...
Labels:

Comments

  1. AnonymousDecember 8, 2012 at 9:01 AM

    Thank you very much. I spent days trying to resolve this problem and with your help I am able to move forward with my project.

    ReplyDelete
  2. Mohammad Atiour IslamDecember 24, 2012 at 2:31 AM

    Thank you.

    ReplyDelete
  3. UnknownJanuary 10, 2013 at 1:48 PM

    thank u

    ReplyDelete

Post a Comment

Popular posts from this blog

The calling thread must be STA, because many UI components require this.

Using Thread: // Create a thread Thread newWindowThread = new Thread(new ThreadStart(() => { // You can use your code // Create and show the Window FaxImageLoad obj = new FaxImageLoad(destination); obj.Show(); // Start the Dispatcher Processing System.Windows.Threading.Dispatcher.Run(); })); // Set the apartment state newWindowThread.SetApartmentState(ApartmentState.STA); // Make the thread a background thread newWindowThread.IsBackground = true; // Start the thread newWindowThread.Start(); Using Task and Thread: // Creating Task Pool, Each task will work asyn and as an indivisual thread component Task[] tasks = new Task[3]; // Control drug data disc UI load optimize tasks[0] = Task.Run(() => { //This will handle the ui thread :The calling thread must be STA, because many U...
Post a Comment
Read more

WPF Crystal Report Viewer Using SAP

There is no doubt that we fall a great problem that the VS2010 is not intregated crystal report. Initially it seems to be a big problem. Hare is some step for SAP crystal report that we can use in our WPF application. 1.Download  Crystal report from this Link: http://scn.sap.com/docs/DOC-7824 2 . Remove Crystal report if any exist. 3. Close your VS-2010 and install the new downloaded CRforVS_13_0 . 4. Take a new WPF project   5. Right click on the project click on Properties 6. Change the target framework .NET Framework 4 Client Profile to  .NET Framework 4. 7. Click on main window then click on Toolbox.  Right Click on the General Tab then click on Choose Item. 8. It will appear this window click on WPF Component. 9.  Select CrystalReportsViewer  click on ok   Button. 10. Now you will see the report viewer control. 11. Your Crystal Report Environment is ready. Now we will a...
11 comments
Read more

SQL Query Execution time of you in SQL Management Studio

You can check the Execution time of you SQL Query in SQL Management Studio. like this It is very simple that you just put your SQL Query in to the Estimated time execution query DECLARE @StartTime datetime DECLARE @EndTime datetime SELECT @StartTime=GETDATE() -- Write Your Query SELECT @EndTime=GETDATE() --This will return execution time of your query SELECT DATEDIFF(NS,@StartTime,@EndTime) AS [Duration in millisecs]
Post a Comment
Read more