Comments

1. fcodinera
   01 May 2007 at 03:26
   where's is the source code?
2. Chris Higgins
   24 Jun 2005 at 16:46
   Hi,
   
   I tried implementing the code you posted and I keep receiving a "File or assembly name CrystalKeyCodeLib, or one of its dependencies, was not found." I'm sure it has something to do with the Crystal Reports registration issue in VS.NET. In a normal deployment you would use the proper merge modules to make it work but I can't seem to accomplish that here.
   
   Any help would be appreciated!!
   Thanks
3. alupigus
   08 Apr 2005 at 10:42

   I will post here a version of Crystal Reports integrated into Visual Studio.NET
   

   
   Basically you have to create a Crystal Report using VS.NET (Employees.rpt) and don't worry about "Save report with data Option". This does not exists in VS.NET.
   Another thing is to that line dt.tableName = "Table" because the table name is set at the begining of the code (string tableName = "Employees".
   

   
   I will attach the whole code here:
   

   
   using System;
   using System.Collections;
   using System.ComponentModel;
   using System.Data;
   using System.Drawing;
   using System.Web;
   using System.Web.SessionState;
   using System.Web.UI;
   using System.Web.UI.WebControls;
   using System.Web.UI.HtmlControls;
   using System.IO;
   using System.Xml;
   using System.Text;
   using CrystalDecisions.CrystalReports.Engine;
   using CrystalDecisions.Shared;
   

   
   namespace CRep
   {
   /// <summary>
   /// Summary description for WebForm1.
   /// </summary>
   public class WebForm1 : System.Web.UI.Page
   {
   

   
   private void Page_Load(object sender, System.EventArgs e)
   {
   // Put user code to initialize the page here
   //* INSTRUCTIONS:
   //define action for this program
   //1. set action to "CreateSchemaFile"
   //2. run program which creates your .xsd schema file
   //3. create crystal report based on that file
   //4. then set action permanently to "CreatePdf"
   //the command
   string action = "CREATEPDF";
   //variables
   string tableName = "Employees";
   string rptFile = "Employees.rpt";
   string xsdFile = "Employees.xsd";
   string pdfFile = "Employees.pdf";
   //either create the schema (first time only) or the pdf file
   if(action.ToUpper() == "CREATESCHEMAFILE")
   {
   DataTable dt = new DataTable();
   dt = DummyTable();
   DataSet ds = new DataSet();
   ds.Tables.Add(dt);
   CreateSchemaFile(xsdFile,ds);
   Response.Write("Your schema file has been created:<br/><br/> <b>" + Server.MapPath(xsdFile) + "</b><br/><br/>");
   Response.Write("Use it to create your Crystal Reports report file named:<br/><br/> <b>" + Server.MapPath(pdfFile) + "</b>");
   }
   else
   {
   //create the report document
   ReportDocument doc = new ReportDocument();
   string fileName = Server.MapPath(rptFile);
   doc.Load(fileName);
   DataTable dt = DummyTable();
   dt.TableName = tableName;
   DataSet ds = new DataSet();
   ds.Tables.Add(dt);
   doc.SetDataSource(ds);
   ExportOptions exportOpts = doc.ExportOptions;
   exportOpts.ExportFormatType = ExportFormatType.PortableDocFormat;
   exportOpts.ExportDestinationType = ExportDestinationType.DiskFile;
   exportOpts.DestinationOptions = new DiskFileDestinationOptions();
   

   
   // Set the disk file options.
   DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions();
   ( ( DiskFileDestinationOptions )doc.ExportOptions.DestinationOptions ).DiskFileName = Server.MapPath("Employees.pdf");
   doc.Export();
   Response.Write("<a href=\"" + pdfFile + "\">" + pdfFile + "</a>");
   }
   

   
   }
   

   
   

   region Web Form Designer generated code

   
   override protected void OnInit(EventArgs e)
   {
   //
   // CODEGEN: This call is required by the ASP.NET Web Form Designer.
   //
   InitializeComponent();
   base.OnInit(e);
   }
   

   
   /// <summary>
   /// Required method for Designer support - do not modify
   /// the contents of this method with the code editor.
   /// </summary>
   private void InitializeComponent()
   {    
   this.Load += new System.EventHandler(this.Page_Load);
   

   
   }
   

   endregion

   
   

   
   private void CreateSchemaFile(string fileName, DataSet ds)
   {
   string absoluteFileName = HttpContext.Current.Server.MapPath(fileName);
   FileStream myFileStream = new FileStream (absoluteFileName, FileMode.Create);
   XmlTextWriter myXmlWriter = new XmlTextWriter(myFileStream, Encoding.Unicode);
   ds.WriteXml( myXmlWriter,XmlWriteMode.WriteSchema );
   myXmlWriter.Close();
   }
   

   
   private DataTable DummyTable()    
   {
   //create table
   DataTable dt = new DataTable("Employees");
   dt.Columns.Add("id",Type.GetType("System.Int32"));
   dt.Columns.Add("FirstName",Type.GetType("System.String"));
   dt.Columns.Add("LastName",Type.GetType("System.String"));
   dt.Columns.Add("HireDate",Type.GetType("System.DateTime"));
   //fill rows
   DataRow dr;
   for(int x=1;x<=10;x++)
   {
   dr = dt.NewRow();
   dr["id"] = x;
   dr["FirstName"] = "Joe" + x;
   dr["LastName"] = "Smith" + x;
   dr["HireDate"] = DateTime.Now;
   dt.Rows.Add(dr);
   }
   return dt;
   }
   }
   }
   

4. grigorythegreat
   07 Dec 2004 at 10:45

   Very good article, but it doesn't discuss the version of Crystal Reports integrated into Visual Studio.NET. How do I turn OFF the "Save Report with Data" option in that environment? I need to get it working. Please, help!

5. James Crowley
   02 Mar 2004 at 04:42

   The only code missing that I can see is the functions that retrieved the info from the database - so just replace the line
   

   
   DataTable dt = qs.GetDataTable("SELECT * FROM fin");
   

   
   in GetTheData() with your own method for retrieving the data.

6. Wayne Russell
   16 Feb 2004 at 17:27

   Hi
   Do you have all the source code available so that I can try the example out
   

   
   Wayne

7. Developer Fusion Bot
   01 Jan 1999 at 00:00

   This thread is for discussions of How to create PDF files from ASP.NET pages.