I'm looking for an easy way to enable a user of my app to print the contet of a GridView.However, I think an easy way will be to convert it into a Crystal Report or pdf (many people say to pdf is terrible), so, I'd like to convert it into a Cyrstal Report (or just a report). Some people have talked about converting a GridView into a Crystal Report, but none have I seen talking about this when I generated my GridView in codes. I mean, people will talk of creating the dataset and data adapter using the GUI in VS2010, but I created mine in codes. Also, when telling the CR where to get its data, people talk about dragging the data connections (table fields etc) to the report in a GUI way, but I can't see how to do that in codes. I use codes for dataset and data adapter in my application forms, how can I code the Crystal Report?
=========== My codes please ==========
'database dbProvider = "PROVIDER= Microsoft.Jet.OLEDB.4.0;" dbSource = "Data Source = data/Human Resource.mdb;" con.ConnectionString = dbProvider & dbSource 'Search for Department If rdDept.Checked = True Then ds.Tables.Clear() con.Open() sqlRadio = "SELECT ID,FirstName,MiddleName,Surname,Phone,Birthday,Empl_Year,Department,Residence,Status " _ + "FROM tblDetails" _ + " WHERE Department = '" & Trim(Me.txtSearch.Text) & "'" da = New OleDb.OleDbDataAdapter(sqlRadio, con) da.Fill(ds, "HumanResource") con.Close() 'Fill the data grid dgv1.DataSource = ds.Tables("HumanResource") 'If nothing was found If ds.Tables("HumanResource").Rows.Count = 0 Then MsgBox("No any record found matching your search.", vbCritical, "GreatestHR:Search Results") dgv1.DataSource = ds.Tables("HumanResource") End If
I want to enable the user to print these results by creating a Crystal Report that will get its data from this gridView, (then I can print from the CR).
I have googled for this for some day now, can someone out there please help?
Thank in advance,