Crystal Report Exporting issue. RSS

• • Reply
  

  sujilkumar

  Member

  115 Points

  135 Posts

  Crystal Report Exporting issue.

  Jan 20, 2012 05:42 AM|LINK

  Hai, i have one crystal report in my web portal but i can't export report to PDF,its showing one error like this..can u any tell me what is the exact problme below i attched the code and error

  protected void btnView_Click(object sender, EventArgs e)
      {      
  
          ParameterDiscreteValue disvalue1 = new ParameterDiscreteValue();
          
          disvalue1.Value = drpKickoffProjects.SelectedItem.Text;
  
          crystalReport.Load(Server.MapPath("MeetingReport.rpt"));
          crystalReport.SetDatabaseLogon("testServer", "testServer", "Server1", "Project");
  
          
          CrystalDecisions.Shared.ParameterFields pfields = new CrystalDecisions.Shared.ParameterFields();
          CrystalDecisions.Shared.ParameterField pfield1 = new ParameterField();
          
          pfield1.Name = "Project";
          pfield1.CurrentValues.Add(disvalue1);
          pfields.Add(pfield1);
  
          crystalReportViewer1.ParameterFieldInfo = pfields;
          crystalReport.Refresh();
          crystalReportViewer1.HasRefreshButton = true;
          Session.Add("rep", crystalReport);
  
          crystalReportViewer1.ReportSource = Session["rep"];
  
          
      }

  Error is 

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

  I Solved this Issue Using this Code. if any one have like this issue please use this technique,

  using System;
  using System.Collections.Generic;
  using System.Linq;
  using System.Web;
  using System.Web.UI;
  using System.Web.UI.WebControls;
  using CrystalDecisions.CrystalReports.Engine;
  using CrystalDecisions.Shared;
  
  public partial class ClientKickOffMeetingReport : System.Web.UI.Page
  {
      
      ParameterFields pfields = new CrystalDecisions.Shared.ParameterFields();
      ParameterField pfield1 = new ParameterField();
      ParameterDiscreteValue disvalue1 = new ParameterDiscreteValue();
      protected void Page_Load(object sender, EventArgs e)
      {
          if (!Page.IsPostBack)
          {
              Session.Remove("rep");
              Session.Clear();
  
              drpKickoffProjects.DataBind();
              BindReport();
          }
          crystalReportViewer1.ReportSource = Session["rep"];        
      }
      protected void btnView_Click(object sender, EventArgs e)
      {
          BindReport();
      }
      void BindReport()
      {        
          ReportDocument crystalReport = new ReportDocument();
          disvalue1.Value = drpKickoffProjects.SelectedItem.Text;
          crystalReport.Load(Server.MapPath("ClientKickoffMeetingReport.rpt"));
          crystalReport.SetDatabaseLogon("userName", "Password", "ServerName", "DB Name");
  
          pfield1.Name = "Project";
          pfield1.CurrentValues.Add(disvalue1);
          pfields.Add(pfield1);
           
          crystalReportViewer1.ParameterFieldInfo = pfields;
          crystalReport.Refresh();
          Session.Add("rep", crystalReport);        
          crystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None;           
      }
  }

  • Moved by MetalAsp.Net on Jan 20, 2012 06:09 AM
  • Edited by sujilkumar on Jan 20, 2012 08:24 AM
  • Marked as answer by sujilkumar on Jan 20, 2012 08:25 AM
• • Reply
  

  Sujeet Bhujb...

  Member

  306 Points

  81 Posts

  Re: Crystal Report Exporting issue.

  Jan 20, 2012 06:07 AM|LINK

  Hi

  Use following

  CrystalReportViewer1.ReportSource = report;
  CrystalReportViewer1.Visible = true;

  
  MemoryStream oStream;
  oStream = (MemoryStream)report.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
  Response.Clear();
  Response.Buffer= true;
  Response.ContentType = "application/pdf";
  Response.BinaryWrite(oStream.ToArray());
  Response.End();

   

  Regards

  Sujeet

  Regards
  
  Sujeet Bhujbal
  
  Sujeet Bhujbal's Blog
  
  --------------------------------------------------------
  
  If the post is useful don't forget to MARK as Answer
  
• • Reply
  

  hasanahn

  Member

  2 Points

  1 Post

  Re: Crystal Report Exporting issue.

  Jan 07, 2013 05:57 AM|LINK

  <div>TO</div> <div>
  </div> <div>Sujeet Bhujbal SIR</div> <div>
  </div> <div>Re: Crystal Report Exporting issue.</div> <div>01-20-2012 07:07 AM</div> <div></div> <div>Very... Very Much Thanking you , because of your code above ref. my report print options is doing well</div> <div></div> <div>But problem is that my report page heading not coming on second page</div> <div></div> <div>Thanks </div> <div>From</div> <div>HASANA COMPUTER - ZINDAGI BANANA</div> <div>M.H.SANADI  - 9975376688</div> <div>KABNUR , ICHALKARANJI , HATKANGALE, DIST. KOLHAPUR</div>