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