Creating Report in datagrid

Here is a sample

private void loadReceipt()

{

DataSet1 dataSet1 = new DataSet1(); //Created dataset that contains datatable columns as shown as the below fields..

DataTable u = dataSet1.Tables.Add("DataTable1"); //"DataTable1" is the name of datatable from the created dataset

//fields...

u.Columns.Add("CustomerName", Type.GetType("System.String"));

u.Columns.Add("Address", Type.GetType("System.String"));

u.Columns.Add("Date", Type.GetType("System.String"));

u.Columns.Add("Qty", Type.GetType("System.String"));

u.Columns.Add("UOM", Type.GetType("System.String"));

u.Columns.Add("Description", Type.GetType("System.String"));

u.Columns.Add("UnitPrice", Type.GetType("System.String"));

u.Columns.Add("Amount", Type.GetType("System.String"));

//u.Columns.Add("Discount", Type.GetType("System.String"));

u.Columns.Add("TotalSales", Type.GetType("System.String"));

u.Columns.Add("Tax", Type.GetType("System.String"));

u.Columns.Add("NetTotal", Type.GetType("System.String"));

DataRow s;

int i = 0;

try

{

//loop for datagridview column...

for (i = 0; i < dgvDesc.Rows.Count; i++)

{

s = u.NewRow();

s["CustomerName"] = txtCustomer.Text;

s["Address"] = txtAddress.Text;

s["Date"] = DateTime.Parse(dtpDate.Text.ToString());

s["TotalSales"] = txtTotal.Text;

s["Tax"] = rdTotalTax;

s["NetTotal"] = txtNetTotal.Text;

s["Qty"] = dgvDesc.Rows[i].Cells[Qty.Name].Value.ToString();

s["UOM"] = dgvDesc.Rows[i].Cells[Uom2.Name].Value.ToString();

s["Description"] = dgvDesc.Rows[i].Cells[Description.Name].Value.ToString();

s["UnitPrice"] = dgvDesc.Rows[i].Cells[UnitPrice.Name].Value.ToString();

s["Amount"] = dgvDesc.Rows[i].Cells[Amount2.Name].Value.ToString();

//s["Discount"] = discount;

u.Rows.Add(s);

}

catch (NullReferenceException) { }

CrystalReport1 crystalReport1 = new CrystalReport1();

crystalReport1.SetDataSource(dataSet1.Tables[1]);

crystalReportViewer1.ReportSource = crystalReport1;

crystalReportViewer1.Refresh();

}

http://social.msdn.microsoft.com/Forums/en-US/5a562e3b-3e5c-46ad-88dc-ef7c19675b02/create-report-from-datagridview-with-crystal-report

http://forums.sdn.sap.com/forum.jspa?forumID=313

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suresh Babu13y ago
hi
u need to perform the pivot operation for filling u r req.
see the below link its useful for u
http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx
Ring Zhong13y ago
Here is a sample
private void loadReceipt()
{
DataSet1 dataSet1 = new DataSet1(); //Created dataset that contains datatable columns as shown as the below fields..
DataTable u = dataSet1.Tables.Add("DataTable1"); //"DataTable1" is the name of datatable from the created dataset

//fields...
u.Columns.Add("CustomerName", Type.GetType("System.String"));
u.Columns.Add("Address", Type.GetType("System.String"));
u.Columns.Add("Date", Type.GetType("System.String"));
u.Columns.Add("Qty", Type.GetType("System.String"));
u.Columns.Add("UOM", Type.GetType("System.String"));
u.Columns.Add("Description", Type.GetType("System.String"));
u.Columns.Add("UnitPrice", Type.GetType("System.String"));
u.Columns.Add("Amount", Type.GetType("System.String"));
//u.Columns.Add("Discount", Type.GetType("System.String"));
u.Columns.Add("TotalSales", Type.GetType("System.String"));
u.Columns.Add("Tax", Type.GetType("System.String"));
u.Columns.Add("NetTotal", Type.GetType("System.String"));
DataRow s;
int i = 0;
try
{
//loop for datagridview column...
for (i = 0; i < dgvDesc.Rows.Count; i++)
{
s = u.NewRow();
s["CustomerName"] = txtCustomer.Text;
s["Address"] = txtAddress.Text;
s["Date"] = DateTime.Parse(dtpDate.Text.ToString());
s["TotalSales"] = txtTotal.Text;
s["Tax"] = rdTotalTax;
s["NetTotal"] = txtNetTotal.Text;
s["Qty"] = dgvDesc.Rows[i].Cells[Qty.Name].Value.ToString();
s["UOM"] = dgvDesc.Rows[i].Cells[Uom2.Name].Value.ToString();
s["Description"] = dgvDesc.Rows[i].Cells[Description.Name].Value.ToString();
s["UnitPrice"] = dgvDesc.Rows[i].Cells[UnitPrice.Name].Value.ToString();
s["Amount"] = dgvDesc.Rows[i].Cells[Amount2.Name].Value.ToString();
//s["Discount"] = discount;
u.Rows.Add(s);
}
}
catch (NullReferenceException) { }
CrystalReport1 crystalReport1 = new CrystalReport1();
crystalReport1.SetDataSource(dataSet1.Tables[1]);

crystalReportViewer1.ReportSource = crystalReport1;
crystalReportViewer1.Refresh();
}
- http://social.msdn.microsoft.com/Forums/en-US/5a562e3b-3e5c-46ad-88dc-ef7c19675b02/create-report-from-datagridview-with-crystal-report
- http://forums.sdn.sap.com/forum.jspa?forumID=313