anuj6928 5 Junior Poster in Training

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