I have a dataset having few columns like parent_id , parent_section_title and child_id ,child_sections_title , questions .Now I report I have added a list with parent_section_titleunder that another list with child_section_title under that another list for questions. I have added a sorting using parent_id then child_id then by questions_id . For few records I have only parent,child questions , but for few I have parent_sections>>child_section_sub_child_section. there is no column for storing sub_child_id . For example: If parent_id has 101 having father as parent_section and child sections are boy ,girl .the child_id for boy is 201 and girl is 202 . Now under boy I have another section which is tall boy and short boy . At this point of time tall and short boy Id stored in child_id which is 301,302 and the child_id (boy) who is parent_id for tall and short boy ,stored under parent_id as 201. Means same Id of child(boy) stored under parent when it has sub_child section. please guide me , how can i sort this ..As I have grouped it with parent_id then by child_id .The result am getting is different..Like father>Boy next father>girl next boy>tall boy ,,boy>>short boy ... it should be father>boy>tallboy>short boy ,father>girl.
... View more