Crystal Reports Passing all report values to sub report

Message

   Hello All,

I have created crystal report with subreport in it.

I have two prompts in my main report as
1.City
2.School

My main report displays information of student id and student name for selected city and school.

  student id      Student name
   001               Peter                      View Detail
   002               John                       View Detail
   003               Alex                        View Detail

I have subreport View Detail.rpt that gives detail information of student.

Now if i select View Detail for student 001, detail report will display detail information for that student.

Requirement is that I need to provide "View ALL" option in main report so that detail repot can display information for all students in Sub report.

Is there any way to pass all values of report field column to subreport ?

Please  let me know how to achieve this functionality in Crystal Report.

Note:- Report is directly based on database and no Business View is implemented.

Thanks,
Amit J