one column is missing in crystal report using dataset

Question

I have a stored procedure and a data set i am filling this data set using stored procedure , when i execute the stored procedure in sql server but when i place the crystal report in the page it is missing one column i check the data type and in stored procedure it is coming , what can be wrong ??

Danish Habib · Answer

The mistake was a space in stored procedure THanks :)

Danish Habib · Answer

below are the details of the error I have a stored procedure which return true result set as show in figure  my Dataset picture is also attached but when i am binding the dataset from db the district column columns twice when i return the Using dsReport As New testset() sda.Fill(dsReport DataTable1) Return dsReport End Using when i check dsReport the district Column comes twice and on report it does not even shown once  i below diagram i have once district column but when i return dsReport i check it comes two times one time it empty and one times it with values

Raja T · Answer

Hi Danish Check bellow code static data and try dynamically... Hide Shrink Copy Code // Create a data table with the same name of crystal report's table. demoTable = new DataTable(  table1 ); // Create table columns with the same fields name of crystal report's table. demoTable.Columns.Add(  Name ); demoTable.Columns.Add(  Age ); demoTable.Columns.Add(  Address ); demoTable.Columns.Add(  Phone ); // Adding 1000 rows to the data table for ( int index = 1 ; index 1000 ; index++) { Random rnd = new Random(); // Create a data row of the created table. DataRow row = demoTable.NewRow(); // Assign values to each cell. We can assign any type of data to // the cell (object type) row[  Name ] =  Prathap ; row[  Age ] = rnd.Next( 10  100 ); row[  Address ] =  Trivandrum ; row[  Phone ] =  954712449198 ; demoTable.Rows.Add(row); } // Create instance of the crystal report. CrystalReportDemo report = new CrystalReportDemo(); // Set data source to the crystal report. If the report contains multiple // datatables then we can index each tables by using the table // name. Following code explains how table name is used for indexing. report.Database.Tables[  table1 ].SetDataSource(( DataTable) demoTable ); // Assign the report to the Crystal report viewer. crystalReportViewer.ReportSource = report; More details checkout below links http://www.codeproject.com/Articles/18332/Crystal-Report-Basics-and-Integration-with-DataSet http://www.codeproject.com/Articles/20670/Dynamic-Crystal-Report-with-C http://www.aspsnippets.com/Articles/Basic-Crystal-Report-Tutorial-with-example-in-Windows-Forms-WinForms-Application-using-C-and-VBNet.aspx