Creating Report in datagrid

Question

Hi I want to show the report in datagrid my database table data snap shot is

Suresh Babu · Answer

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 Zhong · Answer

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 { 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

Creating Report in datagrid

Answers (2)