public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptCR rpt = new rptCR();
rpt.Site = this.Site;
return(rpt);
}
private void Form1_Load(object sender, EventArgs e)
{
//declare connection string, please substitute DataSource with your Server name
string cnString = "Data Source=(local);Initial Catalog=RealWorld; Integrated Security=SSPI;";
//declare Connection, command and other related objects
SqlConnection conReport = new SqlConnection(cnString);
SqlCommand cmdReport = new SqlCommand();
SqlDataReader drReport;
DataSet dsReport = new dsRSandCR();
try
{
//open connection
conReport.Open();
//prepare connection object to get the data through reader and populate into dataset
cmdReport.CommandType = CommandType.Text;
cmdReport.Connection = conReport;
cmdReport.CommandText = "Select * FROM BooksInfo Order By BookTitle";
//read data from command object
drReport = cmdReport.ExecuteReader();
//load data directly from reader to dataset
dsReport.Tables[0].Load(drReport);
//close reader and connection
drReport.Close();
conReport.Close();
//provide local report information to viewer
reportViewer1.LocalReport.ReportEmbeddedResource = "RSandCR.rptRS.rdlc";
//prepare report data source
ReportDataSource rds = new ReportDataSource();
rds.Name = "dsRSandCR_dtRSandCR";
rds.Value = dsReport.Tables[0];
reportViewer1.LocalReport.DataSources.Add(rds);
//load report viewer
reportViewer1.RefreshReport();
// prepare and load crystal reports viewer
rptCR reportCR = new rptCR();
// add typed data set as data source
reportCR.SetDataSource(dsReport.Tables[0]);
// hide group tree which is visible by default for full view of report
crystalReportViewer1.DisplayGroupTree = false;
// bind report instance with cyrstal report viewer for user display
crystalReportViewer1.ReportSource = reportCR;
}
catch (Exception ex)
{
//display generic error message back to user
MessageBox.Show(ex.Message);
}
finally
{
//check if connection is still open then attempt to close it
if (conReport.State == ConnectionState.Open)
{
conReport.Close();
}
}
}
