Hello there
I m using Vs 2010 Crystal Reporting
ma Reports Working Well When using Normally bt nw When I Use sub reports then reports are showing bt blankso that the main report showing all the data bt sub report w showing ny of them .... acctually i m using pivot in sql
that gives me same column name as same data name
that i acctually want
bt nt showing in report
when i use the data table with that
Dim SQL As String = "usp_x_GetMarkSheet " & StudentID
'da = New SqlDataAdapter(SQL, Conn)
'da.Fill(ds, "DataSet1")
dt = _dh.ExecuteDataTable(SQL, CommandType.Text, Nothing)
Dim dtNew As DataTable = Nothing
Dim _sqlNew As String = "usp_rpt_GetStudentPersonalityGrade " & StudentID
dtNew = _dh.ExecuteDataTable(_sqlNew, CommandType.Text, Nothing)
'dt.WriteXmlSchema("D:\GetMarkSheet.xsd")
rpt = New rptTest
rpt.Subreports.Item(0).setDataSource(dtNew)
rpt.SetDataSource(dt)
Return
kindly hav a look