The screen shot was stripped please bear with me I will paste the original query and the original output now:

    WITH cteTestGroups AS (SELECT MIN(A.iSrNo) AS iGroupSrNo
            , B.cTitle
            , MIN(C.iSrNo) AS iSubGroupSrNo
            , C.cSubGroup
        FROM sReqSlipTestGroup A
            JOIN mTestGroups B
                ON  B.iID = A.iTestGroupID
            JOIN lTestGroupsTest C
                ON C.iPID = B.iID
            JOIN mTests D
                ON D.iID = C.iTestID
        WHERE A.iPID = 1
        GROUP BY B.lNewPage
            , A.iSrNo
            , B.cTitle
            , C.cSubGroup
        ORDER BY 1, 2, 3, 4)
       
    SELECT cteTG.*
        FROM cteTestGroups cteTG
       

1    Haemogram Report                                      1    Routine Haemogram                                
1    Haemogram Report                                      5    Diff. Count (Mature Cells)                       
1    Haemogram Report                                      10    Special Investigations                           
2    Haemogram Report                                      1    Diff. Count (Mature Cells)                       
3    C-Reactive Protine                                    1                                                     
4    Urine Analysis                                        1    Physical Examination                             
4    Urine Analysis                                        8    Chemical Examination                             
4    Urine Analysis                                        10    Microscopic Examination of Centrifugalised Deposit
5    Haemogram Report                                      1    E.S.R.                                           

Thanks
Bhavbhuti